/*
================================================================================
档案代号:gad_file
档案名称:目录暂存档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gad_file
(
gad01       varchar2(10) NOT NULL,   /*使用者名称                             */
gad02       varchar2(10) NOT NULL,   /*目录代号                               */
gad03       number(5) NOT NULL,      /*序号                                   */
gad04       varchar2(20)             /*程式代号                               */
);

create unique index gad_pk on gad_file (gad01,gad02,gad03);
alter table gad_file add  constraint gad_pk primary key  (gad01,gad02,gad03) enable validate;
grant select on gad_file to public;
grant index on gad_file to public;
grant update on gad_file to public;
grant delete on gad_file to public;
grant insert on gad_file to public;