/*
================================================================================
档案代号:imab_file
档案名称:主档抛转记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table imab_file
(
imab00      varchar2(1) NOT NULL,    /*申请类别(I:新增 U:修改)                */
imabno      varchar2(80) NOT NULL,   /*申请单号                               */
imab01      varchar2(40) NOT NULL,   /*申请料件/客户/厂商编号                 */
imabtype    varchar2(1) NOT NULL,    /*主档类型(1:料号 2:客户 3:厂商)         */
imabdate    date,                    /*抛转日期                               */
imabdb      varchar2(20) NOT NULL    /*抛转资料库代码                         */
);

create unique index imab_pk on imab_file (imabno,imabtype,imabdb);
alter table imab_file add  constraint imab_pk primary key  (imabno,imabtype,imabdb) enable validate;
grant select on imab_file to public;
grant index on imab_file to public;
grant update on imab_file to public;
grant delete on imab_file to public;
grant insert on imab_file to public;