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
24 lines
1.1 KiB
2 years ago
|
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);
|