/*
================================================================================
档案代号:bmj_file
档案名称:料件/制造商承认资料维护
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bmj_file
(
bmj01       varchar2(40) NOT NULL,   /*料件编号                               */
bmj02       varchar2(10) NOT NULL,   /*制造商                                 */
bmj03       varchar2(10) NOT NULL,   /*供应商                                 */
bmj04       varchar2(40),            /*厂商料号                               */
bmj05       varchar2(10),            /*送样编号                               */
bmj06       date,                    /*送样日期                               */
bmj07       varchar2(10),            /*送样人                                 */
bmj08       varchar2(1),             /*承认状态                               */
bmj09       varchar2(4),             /*No Use                                 */
bmj10       varchar2(10),            /*承认文号                               */
bmj11       date,                    /*承认日期                               */
bmj12       varchar2(255),           /*备注                                   */
bmj13       varchar2(1),             /*No Use                                 */
bmj14       varchar2(1),             /*No Use                                 */
bmj15       varchar2(1),             /*No Use                                 */
bmj99       varchar2(18),            /*No Use                                 */
bmjacti     varchar2(1),             /*资料有效码                             */
bmjuser     varchar2(10),            /*资料所有者                             */
bmjgrup     varchar2(10),            /*资料所有部门                           */
bmjmodu     varchar2(10),            /*资料修改者                             */
bmjdate     date                     /*最近修改日                             */
);

create unique index bmj_pk on bmj_file (bmj01,bmj02,bmj03);
alter table bmj_file add  constraint bmj_pk primary key  (bmj01,bmj02,bmj03) enable validate;
grant select on bmj_file to public;
grant index on bmj_file to public;
grant update on bmj_file to public;
grant delete on bmj_file to public;
grant insert on bmj_file to public;