/* ================================================================================ 档案代号:smq_file 档案名称:总帐日关帐设定资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table smq_file ( smq01 varchar2(5) NOT NULL, /*帐别 */ smq02 varchar2(80), /*帐别名称 */ smq03 number(5) /*现行日期前几天关帐 */ ); create unique index smq_pk on smq_file (smq01); alter table smq_file add constraint smq_pk primary key (smq01) enable validate; grant select on smq_file to public; grant index on smq_file to public; grant update on smq_file to public; grant delete on smq_file to public; grant insert on smq_file to public; |