/*
================================================================================
档案代号:shf_file
档案名称:稼动效率资料单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shf_file
(
shf01       date NOT NULL,           /*日期                                   */
shf02       varchar2(10) NOT NULL,   /*员工编号                               */
shf03       varchar2(10) NOT NULL,   /*线/班别代号                            */
shfud01     varchar2(255),           /*自订栏位-Textedit                      */
shfud02     varchar2(40),            /*自订栏位-文字                          */
shfud03     varchar2(40),            /*自订栏位-文字                          */
shfud04     varchar2(40),            /*自订栏位-文字                          */
shfud05     varchar2(40),            /*自订栏位-文字                          */
shfud06     varchar2(40),            /*自订栏位-文字                          */
shfud07     number(15,3),            /*自订栏位-数值                          */
shfud08     number(15,3),            /*自订栏位-数值                          */
shfud09     number(15,3),            /*自订栏位-数值                          */
shfud10     number(10),              /*自订栏位-整数                          */
shfud11     number(10),              /*自订栏位-整数                          */
shfud12     number(10),              /*自订栏位-整数                          */
shfud13     date,                    /*自订栏位-日期                          */
shfud14     date,                    /*自订栏位-日期                          */
shfud15     date                     /*自订栏位-日期                          */
);

create unique index shf_pk on shf_file (shf01,shf02,shf03);
alter table shf_file add  constraint shf_pk primary key  (shf01,shf02,shf03) enable validate;
grant select on shf_file to public;
grant index on shf_file to public;
grant update on shf_file to public;
grant delete on shf_file to public;
grant insert on shf_file to public;