/* ================================================================================ 档案代号:pmv_file 档案名称:多属性料收货替代原则档 档案目的:多属性料收货替代原则档 假双档 上游档案: 下游档案: ============.========================.========================================== */ create table pmv_file ( pmv01 varchar2(40) DEFAULT '' NOT NULL, /*多属性母料号/多属性明细料号*/ pmv02 varchar2(10) DEFAULT '' NOT NULL, /*供应商编号,*号代表不区分供 */ pmv03 varchar2(10) DEFAULT '' NOT NULL, /*属性代码,放单身*/ pmv04 varchar2(255) DEFAULT '' NOT NULL, /*属性值 *号代表所有,放单身*/ pmv05 varchar2(255) DEFAULT '' NOT NULL, /*可替代属性值 *号代表所有,放 */ pmv06 varchar2(1) DEFAULT '' NOT NULL, /*同属性群组都可以替代否,若此*/ pmv07 varchar2(80), /*属性值说明 */ pmv08 varchar2(80), /*可替代属性值说明 */ pmv09 date DEFAULT sysdate NOT NULL, /*生效日期,放单身*/ pmv10 date /*失效日期,放单身 */ ); create unique index pmv_pk on pmv_file (pmv01,pmv02,pmv03,pmv04,pmv05,pmv06); alter table pmv_file add constraint pmv_pk primary key (pmv01,pmv02,pmv03,pmv04,pmv05,pmv06) enable validate; grant select on pmv_file to public; grant index on pmv_file to public; grant update on pmv_file to public; grant delete on pmv_file to public; grant insert on pmv_file to public; |