/* ================================================================================ 档案代号:axm_file 档案名称:股东权益列印报表格式 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table axm_file ( axm01 varchar2(6) NOT NULL, /*报表代号 */ axm02 varchar2(80), /*报表名称 */ axm03 number(10) NOT NULL, /*顺序 */ axm04 varchar2(8), /*群组代码 */ axm05 varchar2(80), /*说明 */ axm06 varchar2(1), /*No Use */ axm07 varchar2(1), /*No Use */ axm08 varchar2(1) /*No Use */ ); create unique index axm_pk on axm_file (axm01,axm03); alter table axm_file add constraint axm_pk primary key (axm01,axm03) enable validate; grant select on axm_file to public; grant index on axm_file to public; grant update on axm_file to public; grant delete on axm_file to public; grant insert on axm_file to public; |