/*
================================================================================
档案代号:sfk_file
档案名称:报废单头档(工单)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sfk_file
(
sfk01       varchar2(16) NOT NULL,   /*报废单号(SCR)                          */
sfk02       date,                    /*报废日期                               */
sfk03       varchar2(255),           /*备注                                   */
sfkpost     varchar2(1),             /*过帐否                                 */
                                     /*过帐否(Y/N/X)                          */
sfkuser     varchar2(10),            /*资料所有者                             */
sfkgrup     varchar2(10),            /*资料所有部门                           */
sfkmodu     varchar2(10),            /*资料修改者                             */
sfkdate     date,                    /*最近修改日                             */
sfkconf     varchar2(1),             /*确认码                                 */
sfkud01     varchar2(255),           /*自订栏位-Textedit                      */
sfkud02     varchar2(40),            /*自订栏位-文字                          */
sfkud03     varchar2(40),            /*自订栏位-文字                          */
sfkud04     varchar2(40),            /*自订栏位-文字                          */
sfkud05     varchar2(40),            /*自订栏位-文字                          */
sfkud06     varchar2(40),            /*自订栏位-文字                          */
sfkud07     number(15,3),            /*自订栏位-数值                          */
sfkud08     number(15,3),            /*自订栏位-数值                          */
sfkud09     number(15,3),            /*自订栏位-数值                          */
sfkud10     number(10),              /*自订栏位-整数                          */
sfkud11     number(10),              /*自订栏位-整数                          */
sfkud12     number(10),              /*自订栏位-整数                          */
sfkud13     date,                    /*自订栏位-日期                          */
sfkud14     date,                    /*自订栏位-日期                          */
sfkud15     date                     /*自订栏位-日期                          */
);

create unique index sfk_pk on sfk_file (sfk01);
alter table sfk_file add  constraint sfk_pk primary key  (sfk01) enable validate;
grant select on sfk_file to public;
grant index on sfk_file to public;
grant update on sfk_file to public;
grant delete on sfk_file to public;
grant insert on sfk_file to public;