/*
================================================================================
档案代号:snc_file
档案名称:工单变更单备注档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table snc_file
(
snc01       varchar2(16) NOT NULL,   /*工单单号                               */
snc02       number(5) NOT NULL,      /*变更序号                               */
snc03       varchar2(40),            /*料件编号                               */
snc08       varchar2(6),             /*作业编号                               */
snc12       varchar2(4),             /*发料单位                               */
snc05       number(5) NOT NULL,      /*行序                                   */
snc06       varchar2(255)            /*备注说明                               */
);

create unique index snc_pk on snc_file (snc01,snc02,snc05);
alter table snc_file add  constraint snc_pk primary key  (snc01,snc02,snc05) enable validate;
grant select on snc_file to public;
grant index on snc_file to public;
grant update on snc_file to public;
grant delete on snc_file to public;
grant insert on snc_file to public;