/* ================================================================================ 档案代号:trc_file 档案名称:受训类别资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table trc_file ( trc01 varchar2(8) NOT NULL, /*受训类别代号 */ trc02 varchar2(80), /*受训类别名称 */ trc03 varchar2(1), /*No Use */ trcacti varchar2(1), /*资料有效码 */ trcuser varchar2(10), /*资料所有者 */ trcgrup varchar2(10), /*资料所有部门 */ trcmodu varchar2(10), /*资料修改者 */ trcdate date /*最近修改日 */ ); create unique index trc_pk on trc_file (trc01); alter table trc_file add constraint trc_pk primary key (trc01) enable validate; grant select on trc_file to public; grant index on trc_file to public; grant update on trc_file to public; grant delete on trc_file to public; grant insert on trc_file to public; |