/* ================================================================================ 档案代号:apw_file 档案名称:付款单贷方常用会计科目档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apw_file ( apw01 varchar2(1) NOT NULL, /*类别 */ apw02 varchar2(80), /*说明 */ apw03 varchar2(24), /*会计科目 */ apw031 varchar2(24) /*会计科目二 */ ); create unique index apw_pk on apw_file (apw01); alter table apw_file add constraint apw_pk primary key (apw01) enable validate; grant select on apw_file to public; grant index on apw_file to public; grant update on apw_file to public; grant delete on apw_file to public; grant insert on apw_file to public; |