/*
================================================================================
档案代号:sko_file
档案名称:报工群组工单资料档
档案目的:报工群组工单资料单身档
上游档案:
下游档案:
============.========================.==========================================
*/
create table sko_file
(
sko01       varchar2(16) DEFAULT '' NOT NULL, /*工单单号*/
sko02       varchar2(10) DEFAULT '' NOT NULL, /*群组编号*/
sko03       number(15,3) DEFAULT '0' NOT NULL, /*预计生产数量*/
sko04       date,                    /*预计开工日期                           */
sko05       date                     /*预计完工日期                           */
);

create unique index sko_pk on sko_file (sko01,sko02,sko03);
alter table sko_file add  constraint sko_pk primary key  (sko01,sko02,sko03) enable validate;
grant select on sko_file to public;
grant index on sko_file to public;
grant update on sko_file to public;
grant delete on sko_file to public;
grant insert on sko_file to public;