session_aggr_stat surface: Depositsession Results of aggregate statistics
CREATE TABLE `session_aggr_stat` ( `task_id` int(11) NOT NULL, `session_count`
int(11) DEFAULT NULL, `1s_3s` double DEFAULT NULL, `4s_6s` double DEFAULT NULL,
`7s_9s` double DEFAULT NULL, `10s_30s` double DEFAULT NULL, `30s_60s` double
DEFAULT NULL, `1m_3m` double DEFAULT NULL, `3m_10m` double DEFAULT NULL,
`10m_30m` double DEFAULT NULL, `30m` double DEFAULT NULL, `1_3` double DEFAULT
NULL, `4_6` double DEFAULT NULL, `7_9` double DEFAULT NULL, `10_30` double
DEFAULT NULL, `30_60` double DEFAULT NULL, `60` double DEFAULT NULL, PRIMARY KEY
(`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
session_random_extract surface: Store the data that we extract according to the time scale random sampling function1000 individualsession
CREATE TABLE `session_random_extract` ( `task_id` int(11) NOT NULL,
`session_id` varchar(255) DEFAULT NULL, `start_time` varchar(50) DEFAULT NULL,
`end_time` varchar(50) DEFAULT NULL, `search_keywords` varchar(255) DEFAULT NULL
,PRIMARY KEY (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
top10_category surface: Store Click, Ordered by order and paymenttop10 Category data
CREATE TABLE `top10_category` ( `task_id` int(11) NOT NULL, `category_id` int(
11) DEFAULT NULL, `click_count` int(11) DEFAULT NULL, `order_count` int(11)
DEFAULT NULL, `pay_count` int(11) DEFAULT NULL, PRIMARY KEY (`task_id`) )
ENGINE=InnoDBDEFAULT CHARSET=utf8
top10_category_session surface: storagetop10 Click of each categorytop10 Ofsession
CREATE TABLE `top10_category_session` ( `task_id` int(11) NOT NULL,
`category_id` int(11) DEFAULT NULL, `session_id` varchar(255) DEFAULT NULL,
`click_count` int(11) DEFAULT NULL, PRIMARY KEY (`task_id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8
session_detail surface: Store randomly extractedsession Detailed data of,top10 Categorysession Detailed data of.
CREATE TABLE `session_detail` ( `task_id` int(11) NOT NULL, `user_id` int(11)
DEFAULT NULL, `session_id` varchar(255) DEFAULT NULL, `page_id` int(11) DEFAULT
NULL, `action_time` varchar(255) DEFAULT NULL, `search_keyword` varchar(255)
DEFAULT NULL, `click_category_id` int(11) DEFAULT NULL, `click_product_id` int(
11) DEFAULT NULL, `order_category_ids` varchar(255) DEFAULT NULL,
`order_product_ids` varchar(255) DEFAULT NULL, `pay_category_ids` varchar(255)
DEFAULT NULL, `pay_product_ids` varchar(255) DEFAULT NULL, PRIMARY KEY (
`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
task surface: Used for storagej2ee Information of tasks inserted by the platform
CREATE TABLE `task` ( `task_id` int(11) NOT NULL AUTO_INCREMENT, `task_name`
varchar(255) DEFAULT NULL, `create_time` varchar(255) DEFAULT NULL, `start_time`
varchar(255) DEFAULT NULL, `finish_time` varchar(255) DEFAULT NULL, `task_type`
varchar(255) DEFAULT NULL, `task_status` varchar(255) DEFAULT NULL, `task_param`
text,PRIMARY KEY (`task_id`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT
CHARSET=utf8