/* ================================================================================ 档案代号:cqu_file 档案名称:员工计薪绩效资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cqu_file ( cqu01 varchar2(5) NOT NULL, /*计薪指标 */ cqu02 varchar2(10) NOT NULL, /*员工代号 */ cqu03 number(8,4), /*考核分数 */ cquacti varchar2(1), /*资料有效否 */ cquuser varchar2(10), /*资料所有者 */ cqugrup varchar2(10), /*资料所有群 */ cqumodu varchar2(10), /*资料更改者 */ cqudate date /*最近修改日 */ ); create unique index cqu_pk on cqu_file (cqu01,cqu02); alter table cqu_file add constraint cqu_pk primary key (cqu01,cqu02) enable validate; grant select on cqu_file to public; grant index on cqu_file to public; grant update on cqu_file to public; grant delete on cqu_file to public; grant insert on cqu_file to public; |