/* ================================================================================ 档案代号:pjg_file 档案名称:费用代号名称档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjg_file ( pjg01 varchar2(10) NOT NULL, /*费用代号 */ pjg02 varchar2(80), /*费用名称 */ pjg03 varchar2(24), /*预设会计科目一 */ pjg04 varchar2(24), /*预设会计科目二 */ pjg05 varchar2(1), /*费用性质 */ pjgacti varchar2(1), /*资料有效码 */ pjgdate date, /*最近修改日 */ pjggrup varchar2(10), /*资料所有部门 */ pjgmodu varchar2(10), /*资料修改者 */ pjguser varchar2(10) /*资料所有者 */ ); create unique index pjg_pk on pjg_file (pjg01); alter table pjg_file add constraint pjg_pk primary key (pjg01) enable validate; grant select on pjg_file to public; grant index on pjg_file to public; grant update on pjg_file to public; grant delete on pjg_file to public; grant insert on pjg_file to public; |