/* ================================================================================ 档案代号:gim_file 档案名称:揭露事项说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gim_file ( gim00 varchar2(1) NOT NULL, /*合并否 */ /*合并否(Y/N) */ gim01 number(5) NOT NULL, /*顺序 */ gim02 varchar2(80), /*说明 */ gim03 number(20,6) /*金额 */ ); create unique index gim_pk on gim_file (gim00,gim01); alter table gim_file add constraint gim_pk primary key (gim00,gim01) enable validate; grant select on gim_file to public; grant index on gim_file to public; grant update on gim_file to public; grant delete on gim_file to public; grant insert on gim_file to public; |