/* ================================================================================ 档案代号: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; |