/* ================================================================================ 档案代号:pmt_file 档案名称:常用特殊说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmt_file ( pmt01 varchar2(4) NOT NULL, /*特殊常用说明编号 */ pmt03 number(5) NOT NULL, /*行序 */ pmt04 varchar2(255) /*说明 */ ); create unique index pmt_pk on pmt_file (pmt01,pmt03); alter table pmt_file add constraint pmt_pk primary key (pmt01,pmt03) enable validate; grant select on pmt_file to public; grant index on pmt_file to public; grant update on pmt_file to public; grant delete on pmt_file to public; grant insert on pmt_file to public; |