/*
================================================================================
档案代号:trx_file
档案名称:人员工种资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table trx_file
(
trx01       varchar2(6) NOT NULL,    /*工作种类                               */
trx02       varchar2(10) NOT NULL,   /*人员                                   */
trx03       varchar2(255)            /*备注                                   */
);

create unique index trx_pk on trx_file (trx01,trx02);
alter table trx_file add  constraint trx_pk primary key  (trx01,trx02) enable validate;
grant select on trx_file to public;
grant index on trx_file to public;
grant update on trx_file to public;
grant delete on trx_file to public;
grant insert on trx_file to public;