/*
================================================================================
档案代号:sft_file
档案名称:工单发料底稿单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sft_file
(
sft01       varchar2(16) NOT NULL,   /*发料单号                               */
sft03       varchar2(16) NOT NULL,   /*工单                                   */
sft04       varchar2(40) NOT NULL,   /*料号                                   */
sft05       number(15,3),            /*未发数量                               */
sft06       varchar2(4) NOT NULL,    /*发料单位                               */
sft10       number(5) NOT NULL       /*作业序号                               */
);

create unique index sft_pk on sft_file (sft01,sft03,sft04,sft06,sft10);
alter table sft_file add  constraint sft_pk primary key  (sft01,sft03,sft04,sft06,sft10) enable validate;
grant select on sft_file to public;
grant index on sft_file to public;
grant update on sft_file to public;
grant delete on sft_file to public;
grant insert on sft_file to public;