QQ_SERVICE

-- Create table
create table QQ_SERVICE
(
  ID          INTEGER not null,
  NAME        VARCHAR2(30 CHAR),
  QQ          VARCHAR2(20 CHAR),
  CREATE_TIME DATE default SYSDATE,
  UPDATE_TIME DATE null,
  TYPE_ID     INTEGER not null
)
-- Add comments to the table 
comment on table QQ_SERVICE
  is 'QQ客服表';
-- Add comments to the columns 
comment on column QQ_SERVICE.ID
  is '主键';
comment on column QQ_SERVICE.NAME
  is '客服名称';
comment on column QQ_SERVICE.QQ
  is 'qq号码';
comment on column QQ_SERVICE.CREATE_TIME
  is '创建时间';
comment on column QQ_SERVICE.UPDATE_TIME
  is '更新时间';
comment on column QQ_SERVICE.TYPE_ID
  is 'QQ客服类型 QQServiceType';
--Create sequences
Create sequence SEQ_QQ_SERVICE;
-- Create/Recreate primary, unique and foreign key constraints 
alter table QQ_SERVICE add primary key (ID);
alter table QQ_SERVICE
  add constraint FK_QQ_SERVICE foreign key (TYPE_ID)
  references COMMON_TYPE (TYPE_ID);