/*
================================================================================
档案代号:tre_file
档案名称:OJT 等级资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tre_file
(
tre01       varchar2(4) NOT NULL,    /*OJT 等级代号                           */
tre02       varchar2(80),            /*OJT 等级说明                           */
tre03       varchar2(1),             /*No Use                                 */
treacti     varchar2(1),             /*资料有效码                             */
treuser     varchar2(10),            /*资料所有者                             */
tregrup     varchar2(10),            /*资料所有部门                           */
tremodu     varchar2(10),            /*资料修改者                             */
tredate     date                     /*最近修改日                             */
);

create unique index tre_pk on tre_file (tre01);
alter table tre_file add  constraint tre_pk primary key  (tre01) enable validate;
grant select on tre_file to public;
grant index on tre_file to public;
grant update on tre_file to public;
grant delete on tre_file to public;
grant insert on tre_file to public;