/* ================================================================================ 档案代号:aznn_file 档案名称:帐别会计期间明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aznn_file ( aznn00 varchar2(5) NOT NULL, /*帐别 */ aznn01 date NOT NULL, /*日期 */ aznn02 number(5), /*年度 */ /*1-12期,2-13期 */ aznn03 number(5), /*季别 */ aznn04 number(5), /*期别 */ aznn05 number(5) /*周别 */ ); create index aznn_02 on aznn_file (aznn02,aznn04); create unique index aznn_pk on aznn_file (aznn00,aznn01); alter table aznn_file add constraint aznn_pk primary key (aznn00,aznn01) enable validate; grant select on aznn_file to public; grant index on aznn_file to public; grant update on aznn_file to public; grant delete on aznn_file to public; grant insert on aznn_file to public; |