/*
================================================================================
档案代号:gsl_file
档案名称:投资现值维护资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gsl_file
(
gsl01       varchar2(16) NOT NULL,   /*投资单号                               */
gsl02       date NOT NULL,           /*现价日期                               */
gsl03       number(20,6),            /*现价(本币)                             */
gsl04       varchar2(255),           /*备注                                   */
gslacti     varchar2(1),             /*资料有效码                             */
gsluser     varchar2(10),            /*资料所有者                             */
gslgrup     varchar2(10),            /*资料所有部门                           */
gslmodu     varchar2(10),            /*资料修改者                             */
gsldate     date                     /*最近修改日                             */
);

create unique index gsl_pk on gsl_file (gsl01,gsl02);
alter table gsl_file add  constraint gsl_pk primary key  (gsl01,gsl02) enable validate;
grant select on gsl_file to public;
grant index on gsl_file to public;
grant update on gsl_file to public;
grant delete on gsl_file to public;
grant insert on gsl_file to public;