/*
================================================================================
档案代号:bnk_file
档案名称:委外加工核准函档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bnk_file
(
bnk01       varchar2(8) NOT NULL,    /*核准函号码                             */
bnk02       varchar2(10),            /*厂商编号                               */
bnk03       date,                    /*申请日期                               */
bnk04       date,                    /*截止日期                               */
bnk05       varchar2(1)              /*是否展延                               */
                                     /*(Y/N)                                  */
);

create unique index bnk_pk on bnk_file (bnk01);
alter table bnk_file add  constraint bnk_pk primary key  (bnk01) enable validate;
grant select on bnk_file to public;
grant index on bnk_file to public;
grant update on bnk_file to public;
grant delete on bnk_file to public;
grant insert on bnk_file to public;