/* ================================================================================ 档案代号:gsd_file 档案名称:票券外汇投资备注档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gsd_file ( gsd01 varchar2(16) NOT NULL, /*投资单号 */ gsd02 number(5) NOT NULL, /*行序 */ gsd03 varchar2(255) /*说明 */ ); create unique index gsd_pk on gsd_file (gsd01,gsd02); alter table gsd_file add constraint gsd_pk primary key (gsd01,gsd02) enable validate; grant select on gsd_file to public; grant index on gsd_file to public; grant update on gsd_file to public; grant delete on gsd_file to public; grant insert on gsd_file to public; |