/*
================================================================================
档案代号:trm_file
档案名称:教育训练课程开课明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table trm_file
(
trm01       number(5) NOT NULL,      /*年度                                   */
trm02       date NOT NULL,           /*申请日期                               */
trm03       varchar2(8) NOT NULL,    /*课程代号                               */
trm04       number(5) NOT NULL,      /*行序                                   */
trm05       varchar2(10),            /*员工编号                               */
trm06       number(5),               /*成绩                                   */
trm07       varchar2(1),             /*合格否                                 */
trm08       varchar2(30),            /*证书执照号码                           */
trmud01     varchar2(255),           /*自订栏位-Textedit                      */
trmud02     varchar2(40),            /*自订栏位-文字                          */
trmud03     varchar2(40),            /*自订栏位-文字                          */
trmud04     varchar2(40),            /*自订栏位-文字                          */
trmud05     varchar2(40),            /*自订栏位-文字                          */
trmud06     varchar2(40),            /*自订栏位-文字                          */
trmud07     number(15,3),            /*自订栏位-数值                          */
trmud08     number(15,3),            /*自订栏位-数值                          */
trmud09     number(15,3),            /*自订栏位-数值                          */
trmud10     number(10),              /*自订栏位-整数                          */
trmud11     number(10),              /*自订栏位-整数                          */
trmud12     number(10),              /*自订栏位-整数                          */
trmud13     date,                    /*自订栏位-日期                          */
trmud14     date,                    /*自订栏位-日期                          */
trmud15     date                     /*自订栏位-日期                          */
);

create unique index trm_pk on trm_file (trm01,trm02,trm03,trm04);
alter table trm_file add  constraint trm_pk primary key  (trm01,trm02,trm03,trm04) enable validate;
grant select on trm_file to public;
grant index on trm_file to public;
grant update on trm_file to public;
grant delete on trm_file to public;
grant insert on trm_file to public;