/* ================================================================================ 档案代号:gsk_file 档案名称:投资资料统计档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gsk_file ( gsk01 varchar2(16) NOT NULL, /*投资单号 */ gsk02 number(5) NOT NULL, /*年度 */ gsk03 number(5) NOT NULL, /*月份 */ gsk04 number(15,3) NOT NULL, /*留仓数量 */ gsk05 number(20,6) NOT NULL /*留仓金额 */ ); create unique index gsk_pk on gsk_file (gsk01,gsk02,gsk03); alter table gsk_file add constraint gsk_pk primary key (gsk01,gsk02,gsk03) enable validate; grant select on gsk_file to public; grant index on gsk_file to public; grant update on gsk_file to public; grant delete on gsk_file to public; grant insert on gsk_file to public; |