/*
================================================================================
档案代号:fir_file
档案名称:设备检查记录单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fir_file
(
fir01       varchar2(16) NOT NULL,   /*检查单号                               */
fir02       number(5) NOT NULL,      /*序号                                   */
fir03       varchar2(4),             /*项目                                   */
fir04       varchar2(1),             /*项目判定                               */
firud01     varchar2(255),           /*自订栏位-Textedit                      */
firud02     varchar2(40),            /*自订栏位-文字                          */
firud03     varchar2(40),            /*自订栏位-文字                          */
firud04     varchar2(40),            /*自订栏位-文字                          */
firud05     varchar2(40),            /*自订栏位-文字                          */
firud06     varchar2(40),            /*自订栏位-文字                          */
firud07     number(15,3),            /*自订栏位-数值                          */
firud08     number(15,3),            /*自订栏位-数值                          */
firud09     number(15,3),            /*自订栏位-数值                          */
firud10     number(10),              /*自订栏位-整数                          */
firud11     number(10),              /*自订栏位-整数                          */
firud12     number(10),              /*自订栏位-整数                          */
firud13     date,                    /*自订栏位-日期                          */
firud14     date,                    /*自订栏位-日期                          */
firud15     date                     /*自订栏位-日期                          */
);

create unique index fir_pk on fir_file (fir01,fir02);
alter table fir_file add  constraint fir_pk primary key  (fir01,fir02) enable validate;
grant select on fir_file to public;
grant index on fir_file to public;
grant update on fir_file to public;
grant delete on fir_file to public;
grant insert on fir_file to public;