/*
================================================================================
档案代号:fim_file
档案名称:设备工单资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fim_file
(
fim01       varchar2(16) NOT NULL,   /*工单编号                               */
fim02       number(5) NOT NULL,      /*项次                                   */
fim03       varchar2(10),            /*保修项目                               */
fim04       date,                    /*开始日期                               */
fim05       date,                    /*完成日期                               */
fim06       number(8,3),             /*准备工时                               */
fim07       number(8,3),             /*标准工时                               */
fim08       varchar2(1),             /*停机否                                 */
fim09       number(15,3),            /*停机时间                               */
fim10       varchar2(80),            /*停机原因                               */
fim11       varchar2(1),             /*完成否                                 */
fimud01     varchar2(255),           /*自订栏位-Textedit                      */
fimud02     varchar2(40),            /*自订栏位-文字                          */
fimud03     varchar2(40),            /*自订栏位-文字                          */
fimud04     varchar2(40),            /*自订栏位-文字                          */
fimud05     varchar2(40),            /*自订栏位-文字                          */
fimud06     varchar2(40),            /*自订栏位-文字                          */
fimud07     number(15,3),            /*自订栏位-数值                          */
fimud08     number(15,3),            /*自订栏位-数值                          */
fimud09     number(15,3),            /*自订栏位-数值                          */
fimud10     number(10),              /*自订栏位-整数                          */
fimud11     number(10),              /*自订栏位-整数                          */
fimud12     number(10),              /*自订栏位-整数                          */
fimud13     date,                    /*自订栏位-日期                          */
fimud14     date,                    /*自订栏位-日期                          */
fimud15     date                     /*自订栏位-日期                          */
);

create unique index fim_pk on fim_file (fim01,fim02);
alter table fim_file add  constraint fim_pk primary key  (fim01,fim02) enable validate;
grant select on fim_file to public;
grant index on fim_file to public;
grant update on fim_file to public;
grant delete on fim_file to public;
grant insert on fim_file to public;