/*
================================================================================
档案代号:src_file
档案名称:机台(生产线)换料资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table src_file
(
src01       varchar2(10) NOT NULL,   /*机台生产线                             */
src02       varchar2(40) NOT NULL,   /*生产料号                               */
src03       varchar2(40) NOT NULL,   /*换线品号                               */
src04       number(15,3),            /*维修时间(分钟)                         */
srcacti     varchar2(1)              /*有效否                                 */
);

create unique index src_pk on src_file (src01,src02,src03);
alter table src_file add  constraint src_pk primary key  (src01,src02,src03) enable validate;
grant select on src_file to public;
grant index on src_file to public;
grant update on src_file to public;
grant delete on src_file to public;
grant insert on src_file to public;