/* ================================================================================ 档案代号:tna_file 档案名称:历年主会计帐别档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tna_file ( tna00 varchar2(1) NOT NULL, /*类别 */ /*0.财务帐 1.管理帐 */ tna01 number(5) NOT NULL, /*年度 */ tna02 varchar2(5) /*帐别 */ ); create unique index tna_pk on tna_file (tna00,tna01); alter table tna_file add constraint tna_pk primary key (tna00,tna01) enable validate; grant select on tna_file to public; grant index on tna_file to public; grant update on tna_file to public; grant delete on tna_file to public; grant insert on tna_file to public; |