/*
================================================================================
档案代号:gja_file
档案名称:专案名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gja_file
(
gja01       varchar2(10) NOT NULL,   /*专案编号                               */
                                     /*Project number                         */
gja02       varchar2(80),            /*专案名称                               */
                                     /*Project name                           */
gja03       date,                    /*专案起始日期                           */
                                     /*Project start date                     */
gja04       date,                    /*专案结束日期                           */
                                     /*Project close date                     */
gja05       number(15,2),            /*No Use                                 */
gja06       number(15,2),            /*No Use                                 */
gja07       number(15,2),            /*No Use                                 */
gja08       number(15,2),            /*No Use                                 */
gjaacti     varchar2(1),             /*资料有效码                             */
gjauser     varchar2(10),            /*资料所有者                             */
gjagrup     varchar2(10),            /*资料所有部门                           */
gjamodu     varchar2(10),            /*资料修改者                             */
gjadate     date                     /*最近修改日                             */
);

create unique index gja_pk on gja_file (gja01);
alter table gja_file add  constraint gja_pk primary key  (gja01) enable validate;
grant select on gja_file to public;
grant index on gja_file to public;
grant update on gja_file to public;
grant delete on gja_file to public;
grant insert on gja_file to public;