/*
================================================================================
档案代号:fef_file
档案名称:模具归还单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fef_file
(
fef01       varchar2(16) NOT NULL,   /*归还单号                               */
fef02       number(5) NOT NULL,      /*归还单序号                             */
fef03       varchar2(12),            /*模具编号                               */
fef04       number(15,3),            /*数量                                   */
fef05       varchar2(16),            /*借用单号                               */
fefud01     varchar2(255),           /*自订栏位-Textedit                      */
fefud02     varchar2(40),            /*自订栏位-文字                          */
fefud03     varchar2(40),            /*自订栏位-文字                          */
fefud04     varchar2(40),            /*自订栏位-文字                          */
fefud05     varchar2(40),            /*自订栏位-文字                          */
fefud06     varchar2(40),            /*自订栏位-文字                          */
fefud07     number(15,3),            /*自订栏位-数值                          */
fefud08     number(15,3),            /*自订栏位-数值                          */
fefud09     number(15,3),            /*自订栏位-数值                          */
fefud10     number(10),              /*自订栏位-整数                          */
fefud11     number(10),              /*自订栏位-整数                          */
fefud12     number(10),              /*自订栏位-整数                          */
fefud13     date,                    /*自订栏位-日期                          */
fefud14     date,                    /*自订栏位-日期                          */
fefud15     date                     /*自订栏位-日期                          */
);

create unique index fef_pk on fef_file (fef01,fef02);
alter table fef_file add  constraint fef_pk primary key  (fef01,fef02) enable validate;
grant select on fef_file to public;
grant index on fef_file to public;
grant update on fef_file to public;
grant delete on fef_file to public;
grant insert on fef_file to public;