/*
================================================================================
档案代号:trh_file
档案名称:职务评鉴委员单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table trh_file
(
trh01       varchar2(8) NOT NULL,    /*考试科目                               */
trh02       date NOT NULL,           /*委任起始日期                           */
trh03       date NOT NULL,           /*委任截止日期                           */
trh04       number(15,3),            /*评鉴点数                               */
trh05       varchar2(1),             /*No Use                                 */
trhacti     varchar2(1),             /*资料有效码                             */
trhuser     varchar2(10),            /*资料所有者                             */
trhgrup     varchar2(10),            /*资料所有部门                           */
trhmodu     varchar2(10),            /*资料修改者                             */
trhdate     date                     /*最近修改日                             */
);

create unique index trh_pk on trh_file (trh01,trh02,trh03);
alter table trh_file add  constraint trh_pk primary key  (trh01,trh02,trh03) enable validate;
grant select on trh_file to public;
grant index on trh_file to public;
grant update on trh_file to public;
grant delete on trh_file to public;
grant insert on trh_file to public;