/* ================================================================================ 档案代号:cpg_file 档案名称:员工其它津贴扣款项目资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpg_file ( cpg01 varchar2(10) NOT NULL, /*员工代号 */ cpg02 number(5), /*No Use */ cpg03 varchar2(1), /*No Use */ cpg04 varchar2(10) NOT NULL, /*津贴代码 */ cpg05 varchar2(10), /*No Use */ cpg06 varchar2(1), /*No Use */ cpg07 varchar2(1), /*No Use */ cpg08 number(20,6), /*津贴金额 */ /*津贴金额 #modify 030314 NO.A066*/ cpg09 date NOT NULL, /*生效日期 */ cpg10 date /*失效日期 */ ); create unique index cpg_pk on cpg_file (cpg01,cpg04,cpg09); alter table cpg_file add constraint cpg_pk primary key (cpg01,cpg04,cpg09) enable validate; grant select on cpg_file to public; grant index on cpg_file to public; grant update on cpg_file to public; grant delete on cpg_file to public; grant insert on cpg_file to public; |