/* ================================================================================ 档案代号:ahf_file 档案名称:科目异动码弹性设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ahf_file ( ahf00 varchar2(5) NOT NULL, /*帐别 */ ahf01 varchar2(24) NOT NULL, /*科目编号 */ ahf02 varchar2(20) NOT NULL, /*交易作业代号 */ ahf03 varchar2(2) NOT NULL, /*异动码顺序 */ ahf04 varchar2(20) /*预设值栏位 */ ); create unique index ahf_pk on ahf_file (ahf00,ahf01,ahf02,ahf03); alter table ahf_file add constraint ahf_pk primary key (ahf00,ahf01,ahf02,ahf03) enable validate; grant select on ahf_file to public; grant index on ahf_file to public; grant update on ahf_file to public; grant delete on ahf_file to public; grant insert on ahf_file to public; |