/* ================================================================================ 档案代号:ahc_file 档案名称:常用传票额外摘要档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ahc_file ( ahc00 varchar2(5) NOT NULL, /*帐别 */ ahc000 varchar2(1) NOT NULL, /*常用传票性质 */ ahc01 varchar2(16) NOT NULL, /*常用传票编号 */ ahc02 number(5) NOT NULL, /*项次 */ ahc03 number(5) NOT NULL, /*行序 */ ahc04 varchar2(80) /*摘要 */ ); create unique index ahc_pk on ahc_file (ahc01,ahc02,ahc03,ahc00,ahc000); alter table ahc_file add constraint ahc_pk primary key (ahc01,ahc02,ahc03,ahc00,ahc000) enable validate; grant select on ahc_file to public; grant index on ahc_file to public; grant update on ahc_file to public; grant delete on ahc_file to public; grant insert on ahc_file to public; |