/* ================================================================================ 档案代号: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; |