create sequence SEQ_TRADESCORE_AUTOINC
minvalue 1
maxvalue 9999999999999
start with 1
increment by 1
nocache;
-- Create table
create table TBTRADESCORE
(
ID
NUMBER(13) not null,
PRODUCTCODE
VARCHAR2(24),
TYPE
NUMBER(2),
SCORESUM NUMBER(9),
NUM
NUMBER(9),
CREATETIME
DATE,
STATE
NUMBER(2)
)
tablespace XWXDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TBTRADESCORE
is '交易评分总表';
-- Add comments to the columns
comment on column TBTRADESCORE.PRODUCTCODE
is '产品编号';
comment on column TBTRADESCORE.TYPE
is '类型 0未知 1 自行车 2路书';
comment on column TBTRADESCORE.SCORESUM
is '评分总得分数';
comment on column TBTRADESCORE.NUM
is '评分次数';
comment on column TBTRADESCORE.CREATETIME
is '创建时间';
comment on column TBTRADESCORE.STATE
is '状态 0 正常 99 删除';
create sequence SEQ_TRADESCOREDETAIL_AUTOINC
minvalue 1
maxvalue 9999999999999
start with 1
increment by 1
nocache;
-- Create table
create table TBTRADESCOREDETAIL
(
ID
NUMBER(13) not null,
SCOREID
NUMBER(13) not null,
CUST_CODE
VARCHAR2(24),
SCORE NUMBER(2),
CREATETIME
DATE,
MODIFYTIME
DATE,
STATE
NUMBER(2),
REMARK
VARCHAR2(255)
)
tablespace XWXDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TBTRADESCOREDETAIL
is '交易评分明细表';
-- Add comments to the columns
comment on column TBTRADESCOREDETAIL.SCOREID
is 'ID 来自TBTRADESCORE的ID';
comment on column TBTRADESCOREDETAIL.CUST_CODE
is '用户编号';
comment on column TBTRADESCOREDETAIL.SCORE
is '分数';
comment on column TBTRADESCOREDETAIL.CREATETIME
is '创建时间';
comment on column TBTRADESCOREDETAIL.MODIFYTIME
is '修改时间';
comment on column TBTRADESCOREDETAIL.STATE
is '状态 0 正常 99 删除';
comment on column TBTRADESCOREDETAIL.REMARK
is '备注';
create sequence SEQ_TRADECOMMENT_AUTOINC
minvalue 1
maxvalue 9999999999999
start with 1
increment by 1
nocache;
-- Create table
create table TBTRADECOMMENT
(
ID
NUMBER(13) not null,
PRODUCTCODE
VARCHAR2(24),
TYPE
NUMBER(2),
COMMENTSUM
NUMBER(9),
REPLYSUM NUMBER(9),
CREATETIME DATE,
STATE
NUMBER(2)
)
tablespace XWXDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TBTRADECOMMENT
is '交易评论总表';
-- Add comments to the columns
comment on column TBTRADECOMMENT.PRODUCTCODE
is '产品编号';
comment on column TBTRADECOMMENT.TYPE
is '类型 0未知 1 自行车 2路书';
comment on column TBTRADECOMMENT.COMMENTSUM
is '评论总数';
comment on column TBTRADECOMMENT.REPLYSUM
is '回复总数';
comment on column TBTRADECOMMENT.CREATETIME
is '创建时间';
comment on column TBTRADECOMMENT.STATE
is '状态 0 正常 99 删除';
create sequence SEQ_TRADECOMMENTDETAIL_AUTOINC
minvalue 1
maxvalue 9999999999999
start with 1
increment by 1
nocache;
-- Create table
create table TBTRADECOMMENTDETAIL
(
ID
NUMBER(13) not null,
COMMENTID
NUMBER(13) not null,
FROMID
NUMBER(13),
CUSTCODE VARCHAR2(24),
TYPE
NUMBER(2),
REMARK
VARCHAR2(255),
CREATETIME DATE,
MODIFYTIME
DATE,
STATE
NUMBER(2)
)
tablespace XWXDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TBTRADECOMMENTDETAIL
is '交易评论明细表';
-- Add comments to the columns
comment on column TBTRADECOMMENTDETAIL.COMMENTID
is '过滤关键字';
comment on column TBTRADECOMMENTDETAIL.FROMID
is '来源ID 来自本表的ID';
comment on column TBTRADECOMMENTDETAIL.CUSTCODE
is '用户编号';
comment on column TBTRADECOMMENTDETAIL.TYPE
is '类型 0评论 1回复';
comment on column TBTRADECOMMENTDETAIL.REMARK
is '评语';
comment on column TBTRADECOMMENTDETAIL.CREATETIME
is '创建时间';
comment on column TBTRADECOMMENTDETAIL.MODIFYTIME
is '修改时间';
comment on column TBTRADECOMMENTDETAIL.STATE
is '状态 0 正常 99 删除';
create sequence SEQ_COMMENTFILTERKEY_AUTOINC
minvalue 1
maxvalue 9999999999999
start with 1
increment by 1
nocache;
-- Create table
create table TBCOMMENTFILTERKEY
(
ID
NUMBER(13) not null,
FILTERVALUE
VARCHAR2(255)
)
tablespace XWXDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TBCOMMENTFILTERKEY
is '评论过滤关键字表';
comment on column TBCOMMENTFILTERKEY.FILTERVALUE
is '过滤关键字';
