/*
================================================================================
档案代号:skh_file
档案名称:飞票资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table skh_file
(
skh01       varchar2(16) DEFAULT '' NOT NULL, /*飞票号码*/
skh02       varchar2(16) DEFAULT '' NOT NULL, /*pbi号*/
skh03       varchar2(80) DEFAULT '' NOT NULL, /*款式号*/
skh04       number(10) DEFAULT '0' NOT NULL, /*床号*/
skh05       number(10) DEFAULT '0' NOT NULL, /*扎号*/
skh06       varchar2(16) DEFAULT '' NOT NULL, /*工单号码*/
skh08       varchar2(10),            /*单元编号                               */
skh09       varchar2(20),            /*属性一                                 */
skh10       varchar2(20),            /*属性二                                 */
skh100      varchar2(1) DEFAULT '' NOT NULL, /*打印码*/
skh11       varchar2(20),            /*属性三                                 */
skh12       number(15,3) DEFAULT '0' NOT NULL, /*数量*/
skh13       varchar2(16) DEFAULT '' NOT NULL, /*制单号*/
skh99       varchar2(80) DEFAULT '' NOT NULL, /*飞票标识码*/
skh07       number(5),               /*工序                                   */
skh14       number(5)                /*单元次序                               */
);

create unique index skh_pk on skh_file (skh01);
alter table skh_file add  constraint skh_pk primary key  (skh01) enable validate;
grant select on skh_file to public;
grant index on skh_file to public;
grant update on skh_file to public;
grant delete on skh_file to public;
grant insert on skh_file to public;