/* ================================================================================ 档案代号:pmp_file 档案名称:请购/采购单重要备忘档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmp_file ( pmp01 varchar2(16) NOT NULL, /*请购/采购单编号 */ /*Special Note Code */ pmp02 varchar2(1) NOT NULL, /*资料性质 */ /*Data Type */ /*0:请购单 */ /*1:采购单 */ pmp03 date NOT NULL, /*记录日期 */ /*Date */ pmp04 number(5) NOT NULL, /*行序 */ /*Line Sequence */ pmp05 varchar2(255) /*说明 */ /*Description */ ); create unique index pmp_pk on pmp_file (pmp01,pmp03,pmp02,pmp04); alter table pmp_file add constraint pmp_pk primary key (pmp01,pmp03,pmp02,pmp04) enable validate; grant select on pmp_file to public; grant index on pmp_file to public; grant update on pmp_file to public; grant delete on pmp_file to public; grant insert on pmp_file to public; |