/* ================================================================================ 档案代号:vml_file 档案名称:aps 品项分配法则维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vml_file ( vml01 varchar2(40) DEFAULT '' NOT NULL, /*完成品料号*/ vml02 varchar2(60) DEFAULT '' NOT NULL, /*分配法则编号*/ vml03 varchar2(40) DEFAULT '' NOT NULL, /*为part_id本身或其下阶料号*/ vml04 varchar2(60) DEFAULT '' NOT NULL /*供给法则编号*/ ); create unique index vml_pk on vml_file (vml01,vml02,vml03,vml04); alter table vml_file add constraint vml_pk primary key (vml01,vml02,vml03,vml04) enable validate; grant select on vml_file to public; grant index on vml_file to public; grant update on vml_file to public; grant delete on vml_file to public; grant insert on vml_file to public; |