/*
================================================================================
档案代号: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;