/* ================================================================================ 档案代号:tqb_file 档案名称:组织机构资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tqb_file ( tqb01 varchar2(10) NOT NULL, /*组织机构代码 */ tqb02 varchar2(80) NOT NULL, /*组织机构名称 */ tqb03 varchar2(10) NOT NULL, /*组织机构类别 */ tqbacti varchar2(1), /*有效否 */ tqbuser varchar2(10), /*资料所有者 */ tqbgrup varchar2(10), /*资料所有部门 */ tqbmodu varchar2(10), /*资料修改者 */ tqbdate date, /*最后修改日期 */ tqb04 varchar2(1), /*是否记录营运中心 */ tqb05 varchar2(10) /*营运中心代码 */ ); create unique index tqb_pk on tqb_file (tqb01); alter table tqb_file add constraint tqb_pk primary key (tqb01) enable validate; grant select on tqb_file to public; grant index on tqb_file to public; grant update on tqb_file to public; grant delete on tqb_file to public; grant insert on tqb_file to public; |