/*
================================================================================
档案代号:bgx_file
档案名称:薪资部门会计科目维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgx_file
(
bgx01       varchar2(10) NOT NULL,   /*部门代码                               */
bgx02       varchar2(1) NOT NULL,    /*直间接                                 */
                                     /*直间接  1.直接 2.间接                  */
bgx03       varchar2(6) NOT NULL,    /*费用项目                               */
bgx04       varchar2(24),            /*会计科目                               */
bgxacti     varchar2(1),             /*资料有效否                             */
bgxuser     varchar2(10),            /*资料所有者                             */
bgxgrup     varchar2(10),            /*资料所有群                             */
bgxmodu     varchar2(10),            /*资料更改者                             */
bgxdate     date                     /*最近修改日                             */
);

create unique index bgx_pk on bgx_file (bgx01,bgx02,bgx03);
alter table bgx_file add  constraint bgx_pk primary key  (bgx01,bgx02,bgx03) enable validate;
grant select on bgx_file to public;
grant index on bgx_file to public;
grant update on bgx_file to public;
grant delete on bgx_file to public;
grant insert on bgx_file to public;