人力资源
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

24 lines
1.1 KiB

create table position_rating
(
id serial not null,
pep_user_id int not null
constraint position_rating_member_pep_user_id_fk
references member (pep_user_id),
rating_time timestamp not null,
theory_basic_score numeric not null,
theory_passed boolean default false not null,
total_score numeric not null,
total_rating_passed bool default false not null,
technical_grade varchar(255) not null
);
comment on table position_rating is '岗位评级';
comment on column position_rating.rating_time is '评级时间';
comment on column position_rating.theory_basic_score is '理论基础测评成绩';
comment on column position_rating.theory_passed is '理论基础测评是否通过(≥60';
comment on column position_rating.total_score is '评级总成绩';
comment on column position_rating.total_rating_passed is '评级总成绩是否通过(K≥60)';
comment on column position_rating.technical_grade is '技术职级等级';
create unique index position_rating_id_uindex on position_rating (id);
alter table position_rating add constraint position_rating_pk primary key (id);