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
'最后修改时间';