/*
================================================================================
档案代号:gaj_file
档案名称:画面元件权限设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gaj_file
(
gaj01       varchar2(20) NOT NULL,   /*程式代号                               */
gaj02       varchar2(20) NOT NULL,   /*栏位名称                               */
gaj03       varchar2(250),           /*要显现的群组                           */
gaj04       varchar2(250),           /*要隐藏的群组                           */
gaj05       varchar2(250),           /*要显现的个人                           */
gaj06       varchar2(250),           /*要隐藏的个人                           */
gaj07       varchar2(250),           /*可输入的群组                           */
gaj08       varchar2(250),           /*不可输入的群组                         */
gaj09       varchar2(250),           /*可输入的个人                           */
gaj10       varchar2(250),           /*不可输入的个人                         */
gaj11       varchar2(10) DEFAULT 'std' NOT NULL /*行业别*/
);

create unique index gaj_pk on gaj_file (gaj01,gaj02,gaj11);
alter table gaj_file add  constraint gaj_pk primary key  (gaj01,gaj02,gaj11) enable validate;
grant select on gaj_file to public;
grant index on gaj_file to public;
grant update on gaj_file to public;
grant delete on gaj_file to public;
grant insert on gaj_file to public;