/* ================================================================================ 档案代号:aea_file 档案名称:分类帐档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aea_file ( aea00 varchar2(5) NOT NULL, /*帐别 */ aea01 varchar2(24) NOT NULL, /*统治或独立科目编号 */ aea02 date, /*传票日期 */ aea03 varchar2(16) NOT NULL, /*传票编号 */ aea04 number(5) NOT NULL, /*项次 */ aea05 varchar2(24) /*明细科目编号 */ ); create index aea_01 on aea_file (aea01,aea02); create index aea_02 on aea_file (aea05,aea02); create unique index aea_pk on aea_file (aea03,aea04,aea01,aea00); alter table aea_file add constraint aea_pk primary key (aea03,aea04,aea01,aea00) enable validate; grant select on aea_file to public; grant index on aea_file to public; grant update on aea_file to public; grant delete on aea_file to public; grant insert on aea_file to public; |