Oracle语句创建表

create table dept  (
   deptid                 INTEGER                         not null,
   chinaname          VARCHAR2(50),
   simplename         VARCHAR2(50),
   parentid           INTEGER                         not null,
   indexid            INTEGER                        default (0) not null,
   sortcode           VARCHAR2(60),
   delstatus          SMALLINT                       default (0) not null,
   depttype           SMALLINT                       default (0) not null,
   deptroles          VARCHAR2(50),
   permstring         VARCHAR2(3000)                 default ',0,' not null,
   holdleader         INTEGER                        default (0) not null,
   tybmbm             VARCHAR2(255),
   dwbm               VARCHAR2(200),
   systemtype         VARCHAR2(255),
   stattype           VARCHAR2(255),
   jjry               INTEGER                        default (0),
   deptdutytype       SMALLINT                       default (0),
   adder              INTEGER                        default (0) not null,
   addtime            DATE                           default sysdate not null,
   moder              INTEGER                        default (0) not null,
   modtime            DATE                           default sysdate not null,
   constraint PK_DEPT primary key (deptid)
);

comment on column dept.deptid is
'主键';

comment on column dept.chinaname is
'部门名称';

comment on column dept.simplename is
'简称';

comment on column dept.parentid is
'父节点';

comment on column dept.indexid is
'排序号';

comment on column dept.sortcode is
'排序串';

comment on column dept.delstatus is
'删除标识';

comment on column dept.depttype is
'单位性质';

comment on column dept.deptroles is
'单位职能分工特点';

comment on column dept.permstring is
'单位权限位，形如“,2,3,6,4,1,33,”每位标识的意义见categoryvalue表的设定';

comment on column dept.holdleader is
'分管领导';

comment on column dept.tybmbm is
'统一编码';

comment on column dept.dwbm is
'单位编码';

comment on column dept.systemtype is
'所处系统分类';

comment on column dept.stattype is
'单位统计类别';

comment on column dept.jjry is
'纪检人员';

comment on column dept.deptdutytype is
'单位职能分类';

comment on column dept.adder is
'添加者';

comment on column dept.addtime is
'添加时间';

comment on column dept.moder is
'最后修改者';

comment on column dept.modtime is
'最后修改时间';