-- 评论 create table c_comment( comment_id VARCHAR(30) NOT NULL COMMENT '评论ID', user_id varchar(30) not null comment '评论者用户ID', b_id VARCHAR(30) NOT NULL COMMENT '订单ID', comment_type_cd varchar(2) not null default 'S' comment '评论类型 S表示 商品 M表示 商户 T 物流', out_id varchar(30) not null comment '外部ID，如商品ID 商户ID等', `month` INT NOT NULL COMMENT '月份', create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态，详细参考c_status表，S 保存，0, 在用 1失效' ) PARTITION BY RANGE (`month`) ( PARTITION comment_1 VALUES LESS THAN (2), PARTITION comment_2 VALUES LESS THAN (3), PARTITION comment_3 VALUES LESS THAN (4), PARTITION comment_4 VALUES LESS THAN (5), PARTITION comment_5 VALUES LESS THAN (6), PARTITION comment_6 VALUES LESS THAN (7), PARTITION comment_7 VALUES LESS THAN (8), PARTITION comment_8 VALUES LESS THAN (9), PARTITION comment_9 VALUES LESS THAN (10), PARTITION comment_10 VALUES LESS THAN (11), PARTITION comment_11 VALUES LESS THAN (12), PARTITION comment_12 VALUES LESS THAN (13) ); CREATE INDEX idx_comment_b_id ON c_comment(b_id); CREATE INDEX idx_comment_out_id ON c_comment(out_id); -- 评论子表 create table c_sub_comment( sub_comment_id varchar(30) not null comment '子评论ID', comment_id varchar(30) not null comment '评论ID ', b_id VARCHAR(30) NOT NULL COMMENT '订单ID', parent_sub_comment_id varchar(30) not null default '-1' comment '父 子评论ID 如果不是回复 写成-1', sub_comment_type_cd varchar(2) not null default 'C' comment '评论类型 C 评论 R 回复 A 追加', comment_context LONGTEXT not null COMMENT '评论内容', `month` INT NOT NULL COMMENT '月份', create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态，详细参考c_status表，S 保存，0, 在用 1失效' ) PARTITION BY RANGE (`month`) ( PARTITION sub_comment_1 VALUES LESS THAN (2), PARTITION sub_comment_2 VALUES LESS THAN (3), PARTITION sub_comment_3 VALUES LESS THAN (4), PARTITION sub_comment_4 VALUES LESS THAN (5), PARTITION sub_comment_5 VALUES LESS THAN (6), PARTITION sub_comment_6 VALUES LESS THAN (7), PARTITION sub_comment_7 VALUES LESS THAN (8), PARTITION sub_comment_8 VALUES LESS THAN (9), PARTITION sub_comment_9 VALUES LESS THAN (10), PARTITION sub_comment_10 VALUES LESS THAN (11), PARTITION sub_comment_11 VALUES LESS THAN (12), PARTITION sub_comment_12 VALUES LESS THAN (13) ); CREATE INDEX idx_sub_comment_b_id ON c_sub_comment(b_id); CREATE INDEX idx_sub_comment_comment_id ON c_sub_comment(comment_id); CREATE INDEX idx_sub_comment_parent_sub_comment_id ON c_sub_comment(parent_sub_comment_id); -- 属性 create table c_sub_comment_attr( attr_id VARCHAR(30) NOT NULL COMMENT '属性id', sub_comment_id VARCHAR(30) NOT NULL COMMENT '子评论ID', b_id VARCHAR(30) NOT NULL COMMENT '订单ID', spec_cd VARCHAR(12) NOT NULL COMMENT '规格id,参考spec表', value VARCHAR(50) NOT NULL COMMENT '属性值', `month` INT NOT NULL COMMENT '月份', create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态，详细参考c_status表，S 保存，0, 在用 1失效' ) PARTITION BY RANGE (`month`) ( PARTITION sub_comment_attr_1 VALUES LESS THAN (2), PARTITION sub_comment_attr_2 VALUES LESS THAN (3), PARTITION sub_comment_attr_3 VALUES LESS THAN (4), PARTITION sub_comment_attr_4 VALUES LESS THAN (5), PARTITION sub_comment_attr_5 VALUES LESS THAN (6), PARTITION sub_comment_attr_6 VALUES LESS THAN (7), PARTITION sub_comment_attr_7 VALUES LESS THAN (8), PARTITION sub_comment_attr_8 VALUES LESS THAN (9), PARTITION sub_comment_attr_9 VALUES LESS THAN (10), PARTITION sub_comment_attr_10 VALUES LESS THAN (11), PARTITION sub_comment_attr_11 VALUES LESS THAN (12), PARTITION sub_comment_attr_12 VALUES LESS THAN (13) ); CREATE INDEX idx_sub_comment_attr_b_id ON c_sub_comment_attr(b_id); CREATE INDEX idx_sub_comment_attr_sub_comment_id ON c_sub_comment_attr(sub_comment_id); CREATE INDEX idx_sub_comment_attr_spec_cd ON c_sub_comment_attr(spec_cd); -- 评论 照片 CREATE TABLE c_sub_comment_photo( comment_photo_id VARCHAR(30) NOT NULL COMMENT '评论照片ID', b_id VARCHAR(30) NOT NULL COMMENT '业务Id', sub_comment_id VARCHAR(30) NOT NULL COMMENT '商店ID', comment_photo_type_cd VARCHAR(2) NOT NULL default 'S' COMMENT '评论照片类型,S 商品照片 M 商户ID', photo VARCHAR(100) NOT NULL COMMENT '照片', `month` INT NOT NULL COMMENT '月份', create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态，详细参考c_status表，S 保存，0, 在用 1失效' ) PARTITION BY RANGE (`month`) ( PARTITION sub_comment_photo_1 VALUES LESS THAN (2), PARTITION sub_comment_photo_2 VALUES LESS THAN (3), PARTITION sub_comment_photo_3 VALUES LESS THAN (4), PARTITION sub_comment_photo_4 VALUES LESS THAN (5), PARTITION sub_comment_photo_5 VALUES LESS THAN (6), PARTITION sub_comment_photo_6 VALUES LESS THAN (7), PARTITION sub_comment_photo_7 VALUES LESS THAN (8), PARTITION sub_comment_photo_8 VALUES LESS THAN (9), PARTITION sub_comment_photo_9 VALUES LESS THAN (10), PARTITION sub_comment_photo_10 VALUES LESS THAN (11), PARTITION sub_comment_photo_11 VALUES LESS THAN (12), PARTITION sub_comment_photo_12 VALUES LESS THAN (13) ); CREATE INDEX idx_sub_comment_photo_b_id ON c_sub_comment_photo(b_id); CREATE INDEX idx_sub_comment_photo_sub_comment_id ON c_sub_comment_photo(sub_comment_id); -- 评论分数 CREATE TABLE c_comment_score( comment_score_id VARCHAR(30) NOT NULL COMMENT '评论分数ID', comment_id VARCHAR(30) NOT NULL COMMENT '评论ID', b_id VARCHAR(30) NOT NULL COMMENT '业务Id', score_type_cd VARCHAR(2) NOT NULL COMMENT '打分类别，S 商品相符，U 卖家打分，T 物流打分', `value` INT NOT NULL COMMENT '分数', `month` INT NOT NULL COMMENT '月份', create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态，详细参考c_status表，S 保存，0, 在用 1失效' ) PARTITION BY RANGE (`month`) ( PARTITION comment_score_1 VALUES LESS THAN (2), PARTITION comment_score_2 VALUES LESS THAN (3), PARTITION comment_score_3 VALUES LESS THAN (4), PARTITION comment_score_4 VALUES LESS THAN (5), PARTITION comment_score_5 VALUES LESS THAN (6), PARTITION comment_score_6 VALUES LESS THAN (7), PARTITION comment_score_7 VALUES LESS THAN (8), PARTITION comment_score_8 VALUES LESS THAN (9), PARTITION comment_score_9 VALUES LESS THAN (10), PARTITION comment_score_10 VALUES LESS THAN (11), PARTITION comment_score_11 VALUES LESS THAN (12), PARTITION comment_score_12 VALUES LESS THAN (13) ); CREATE INDEX idx_comment_score_b_id ON c_comment_score(b_id); CREATE INDEX idx_comment_score_comment_id ON c_comment_score(comment_id);