/*
================================================================================
档案代号:gsg_file
档案名称:投资票券费用明细资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gsg_file
(
gsg01       varchar2(16) NOT NULL,   /*投资单号                               */
gsg02       number(5) NOT NULL,      /*行序                                   */
gsg03       varchar2(6),             /*费用代号                               */
gsg04       varchar2(1),             /*No Use                                 */
gsg05       number(20,6),            /*费用金额                               */
gsg06       varchar2(24),            /*会计科目                               */
gsg07       varchar2(1),             /*No Use                                 */
gsg08       varchar2(1),             /*No Use                                 */
gsg09       varchar2(1),             /*No Use                                 */
gsg10       varchar2(1)              /*No Use                                 */
);

create unique index gsg_pk on gsg_file (gsg01,gsg02);
alter table gsg_file add  constraint gsg_pk primary key  (gsg01,gsg02) enable validate;
grant select on gsg_file to public;
grant index on gsg_file to public;
grant update on gsg_file to public;
grant delete on gsg_file to public;
grant insert on gsg_file to public;