/* ================================================================================ 档案代号:tro_file 档案名称:OJT 必修课程资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tro_file ( tro01 varchar2(6) NOT NULL, /*职务代号 */ tro02 varchar2(10) NOT NULL, /*部门代号 */ tro03 varchar2(8) NOT NULL, /*OJT 课程代号 */ tro04 varchar2(1), /*必修否 */ troacti varchar2(1), /*资料有效码 */ trouser varchar2(10), /*资料所有者 */ trogrup varchar2(10), /*资料所有部门 */ tromodu varchar2(10), /*资料修改者 */ trodate date /*最近修改日 */ ); create unique index tro_pk on tro_file (tro01,tro02,tro03); alter table tro_file add constraint tro_pk primary key (tro01,tro02,tro03) enable validate; grant select on tro_file to public; grant index on tro_file to public; grant update on tro_file to public; grant delete on tro_file to public; grant insert on tro_file to public; |