/*
================================================================================
档案代号: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;