/*
================================================================================
档案代号:tri_file
档案名称:职务评鉴委员单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tri_file
(
tri01       varchar2(8) NOT NULL,    /*考试科目                               */
tri02       date NOT NULL,           /*委任起始日期                           */
tri03       date NOT NULL,           /*委任截止日期                           */
tri04       number(5) NOT NULL,      /*行序                                   */
tri05       varchar2(1),             /*外聘否                                 */
tri06       varchar2(10),            /*委员代号                               */
tri07       varchar2(1)              /*主委否                                 */
);

create unique index tri_pk on tri_file (tri01,tri02,tri03,tri04);
alter table tri_file add  constraint tri_pk primary key  (tri01,tri02,tri03,tri04) enable validate;
grant select on tri_file to public;
grant index on tri_file to public;
grant update on tri_file to public;
grant delete on tri_file to public;
grant insert on tri_file to public;