/* ================================================================================ 档案代号:pmq_file 档案名称:厂商料号品名规格额外说明资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmq_file ( pmq01 varchar2(40) NOT NULL, /*料件编号 */ pmq02 varchar2(10) NOT NULL, /*供应厂商编号 */ pmq03 varchar2(40), /*厂商料件编号 */ pmq04 number(5) NOT NULL, /*行序 */ pmq05 varchar2(255) /*厂商料号品名规格额外说明 */ ); create unique index pmq_pk on pmq_file (pmq01,pmq02,pmq04); alter table pmq_file add constraint pmq_pk primary key (pmq01,pmq02,pmq04) enable validate; grant select on pmq_file to public; grant index on pmq_file to public; grant update on pmq_file to public; grant delete on pmq_file to public; grant insert on pmq_file to public; |