/*
================================================================================
档案代号:gcd_file
档案名称:资料上传下载单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gcd_file
(
gcd01       varchar2(10) NOT NULL,   /*格式代码                               */
gcd02       number(5) NOT NULL,      /*序号                                   */
gcd03       varchar2(1),             /*资料格式                               */
gcd04       varchar2(15),            /*表格名称                               */
gcd05       varchar2(255),           /*资料内容                               */
gcd06       varchar2(1),             /*是否使用条件式                         */
gcd07       varchar2(20),            /*群组                                   */
gcd08       varchar2(20),            /*起始位置                               */
gcd09       varchar2(20),            /*截止位置                               */
gcd10       varchar2(1)              /*资料排列                               */
);

create unique index gcd_pk on gcd_file (gcd01,gcd02);
alter table gcd_file add  constraint gcd_pk primary key  (gcd01,gcd02) enable validate;
grant select on gcd_file to public;
grant index on gcd_file to public;
grant update on gcd_file to public;
grant delete on gcd_file to public;
grant insert on gcd_file to public;