/*
================================================================================
档案代号:bod_file
档案名称:成品材料属性对应关系
档案目的:成品材料属性对应关系单身档
上游档案:
下游档案:
============.========================.==========================================
*/
create table bod_file
(
bod01       varchar2(40) DEFAULT '' NOT NULL, /*主件款式*/
bod02       varchar2(40) DEFAULT '' NOT NULL, /*元件款式*/
bod03       varchar2(10) DEFAULT '' NOT NULL, /*主件属性代码*/
bod04       varchar2(10) DEFAULT '' NOT NULL, /*元件属性代码*/
bod05       varchar2(20) DEFAULT '' NOT NULL, /*主件属性值*/
bod06       varchar2(10) DEFAULT '' NOT NULL, /*部位*/
bod07       varchar2(20) DEFAULT '' NOT NULL, /*元件属性值*/
bod08       varchar2(80) DEFAULT '' NOT NULL, /*主件属性描述*/
bod09       varchar2(80) DEFAULT '' NOT NULL /*元件属性描述*/
);

create unique index bod_pk on bod_file (bod01,bod02,bod03,bod04,bod05,bod06);
alter table bod_file add  constraint bod_pk primary key  (bod01,bod02,bod03,bod04,bod05,bod06) enable 
validate;
grant select on bod_file to public;
grant index on bod_file to public;
grant update on bod_file to public;
grant delete on bod_file to public;
grant insert on bod_file to public;