/* ================================================================================ 档案代号:npy_file 档案名称:票据格式设定单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table npy_file ( npy01 varchar2(10) NOT NULL, /*格式代号 */ npy02 number(5) NOT NULL, /*单据项次 */ npy03 varchar2(10), /*列印项目 */ npy04 number(5), /*空几列 */ npy05 number(5), /*空几行 */ npy06 varchar2(30), /*本列结束否 */ npy07 varchar2(30) /*No Use */ ); create unique index npy_pk on npy_file (npy01,npy02); alter table npy_file add constraint npy_pk primary key (npy01,npy02) enable validate; grant select on npy_file to public; grant index on npy_file to public; grant update on npy_file to public; grant delete on npy_file to public; grant insert on npy_file to public; |