/* ================================================================================ 档案代号:oaj_file 档案名称:费用代码档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oaj_file ( oaj01 varchar2(10) NOT NULL, /*费用代码 */ oaj02 varchar2(80), /*费用名称 */ oaj03 varchar2(10), /*原因码 */ oajacti varchar2(1) /*有效码 */ ); create unique index oaj_pk on oaj_file (oaj01); alter table oaj_file add constraint oaj_pk primary key (oaj01) enable validate; grant select on oaj_file to public; grant index on oaj_file to public; grant update on oaj_file to public; grant delete on oaj_file to public; grant insert on oaj_file to public; |