/* ================================================================================ 档案代号:cxg_file 档案名称:单别成会分类设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cxg_file ( cxg01 varchar2(5) NOT NULL, /*单别 */ cxg02 varchar2(1) NOT NULL, /*科目种类 */ cxg03 varchar2(1) NOT NULL, /*种类来源 */ cxg04 varchar2(10) NOT NULL, /*种类编号 */ cxg05 varchar2(24), /*科目编号 */ cxg051 varchar2(24) /*科目代号二 */ ); create unique index cxg_pk on cxg_file (cxg01,cxg02,cxg03,cxg04); alter table cxg_file add constraint cxg_pk primary key (cxg01,cxg02,cxg03,cxg04) enable validate; grant select on cxg_file to public; grant index on cxg_file to public; grant update on cxg_file to public; grant delete on cxg_file to public; grant insert on cxg_file to public; |