/*
================================================================================
档案代号:sgk_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sgk_file
(
sgk01       varchar2(16) DEFAULT '' NOT NULL, /*报工单号*/
sgk02       date DEFAULT sysdate NOT NULL, /*报工日期*/
sgk03       varchar2(10) DEFAULT '' NOT NULL, /*报工人员*/
sgk04       varchar2(80) DEFAULT '' NOT NULL, /*备注*/
sgk05       varchar2(1) DEFAULT '' NOT NULL, /*飞票报工否*/
sgk06       varchar2(1) DEFAULT '' NOT NULL, /*团体报工否*/
sgk07       varchar2(1) DEFAULT '' NOT NULL, /*审核码*/
sgkacti     varchar2(1),             /*资料有效码                             */
sgkdate     date,                    /*资料修改日期                           */
sgkgrup     varchar2(10),            /*资料所属群组                           */
sgkmodu     varchar2(10),            /*资料修改者                             */
sgkuser     varchar2(10)             /*资料所有者                             */
);

create unique index sgk_pk on sgk_file (sgk01);
alter table sgk_file add  constraint sgk_pk primary key  (sgk01) enable validate;
grant select on sgk_file to public;
grant index on sgk_file to public;
grant update on sgk_file to public;
grant delete on sgk_file to public;
grant insert on sgk_file to public;