/*
================================================================================
档案代号:trj_file
档案名称:员工考试资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table trj_file
(
trj01       varchar2(10) NOT NULL,   /*员工编号                               */
trj02       varchar2(10) NOT NULL,   /*挑战职称代号                           */
trj021      varchar2(10),            /*挑战职等代号                           */
trj022      number(5),               /*挑战职级代号                           */
trj03       date NOT NULL,           /*考试日期                               */
trj04       varchar2(8),             /*考试科目                               */
trj05       date,                    /*合格日期                               */
trj06       number(15,3),            /*评鉴点数                               */
trj07       varchar2(1),             /*No Use                                 */
trjacti     varchar2(1),             /*资料有效码                             */
trjuser     varchar2(10),            /*资料所有者                             */
trjgrup     varchar2(10),            /*资料所有部门                           */
trjmodu     varchar2(10),            /*资料修改者                             */
trjdate     date                     /*最近修改日                             */
);

create unique index trj_pk on trj_file (trj01,trj02,trj03);
alter table trj_file add  constraint trj_pk primary key  (trj01,trj02,trj03) enable validate;
grant select on trj_file to public;
grant index on trj_file to public;
grant update on trj_file to public;
grant delete on trj_file to public;
grant insert on trj_file to public;