/* ================================================================================ 档案代号:tre_file 档案名称:OJT 等级资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tre_file ( tre01 varchar2(4) NOT NULL, /*OJT 等级代号 */ tre02 varchar2(80), /*OJT 等级说明 */ tre03 varchar2(1), /*No Use */ treacti varchar2(1), /*资料有效码 */ treuser varchar2(10), /*资料所有者 */ tregrup varchar2(10), /*资料所有部门 */ tremodu varchar2(10), /*资料修改者 */ tredate date /*最近修改日 */ ); create unique index tre_pk on tre_file (tre01); alter table tre_file add constraint tre_pk primary key (tre01) enable validate; grant select on tre_file to public; grant index on tre_file to public; grant update on tre_file to public; grant delete on tre_file to public; grant insert on tre_file to public; |