/* ================================================================================ 档案代号:cps_file 档案名称:员工班别单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cps_file ( cps01 varchar2(10) NOT NULL, /*员工代码 */ cps02 number(5) NOT NULL, /*年度 */ cps021 number(5) NOT NULL, /*月份 */ cps03 varchar2(10), /*公司别 */ cps04 varchar2(10), /*部门别 */ cps05 varchar2(1), /*No Use */ cpsacti varchar2(1), /*资料有效否 */ cpsuser varchar2(10), /*资料所有者 */ /*系统维护 */ cpsgrup varchar2(10), /*资料所有群 */ /*系统维护 */ cpsmodu varchar2(10), /*资料更改者 */ /*系统维护 */ cpsdate date /*最近修改日 */ /*系统维护 */ ); create unique index cps_pk on cps_file (cps01,cps02,cps021); alter table cps_file add constraint cps_pk primary key (cps01,cps02,cps021) enable validate; grant select on cps_file to public; grant index on cps_file to public; grant update on cps_file to public; grant delete on cps_file to public; grant insert on cps_file to public; |