/* ================================================================================ 档案代号:aak_file 档案名称:会计科目额外说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aak_file ( aak01 varchar2(24) NOT NULL, /*科目编号 */ aak02 varchar2(4) NOT NULL, /*类别 */ aak03 number(5) NOT NULL, /*行序 */ aak04 varchar2(80), /*额外说明 */ aak00 varchar2(5) NOT NULL /*帐别 */ ); create unique index aak_pk on aak_file (aak00,aak01,aak02,aak03); alter table aak_file add constraint aak_pk primary key (aak00,aak01,aak02,aak03) enable validate; grant select on aak_file to public; grant index on aak_file to public; grant update on aak_file to public; grant delete on aak_file to public; grant insert on aak_file to public; |