36 lines
1.8 KiB
MySQL
36 lines
1.8 KiB
MySQL
|
-- 面试邀约表
|
||
|
|
create table "interview_invitation"
|
||
|
|
(
|
||
|
|
"id" bigint not null,
|
||
|
|
"company_id" bigint not null,
|
||
|
|
"job_id" bigint not null,
|
||
|
|
"user_id" bigint not null,
|
||
|
|
"apply_id" bigint null,
|
||
|
|
"interview_time" varchar(100) null,
|
||
|
|
"interview_method" varchar(20) null,
|
||
|
|
"meeting_link" varchar(500) null,
|
||
|
|
"meeting_password" varchar(100) null,
|
||
|
|
"interview_location" varchar(500) null,
|
||
|
|
"contact_phone" varchar(50) null,
|
||
|
|
"status" varchar(20) default 'pending' null,
|
||
|
|
"del_flag" char(1) default '0' null,
|
||
|
|
"create_by" varchar(64) default '' null,
|
||
|
|
"create_time" timestamp(0) null,
|
||
|
|
"update_by" varchar(64) default '' null,
|
||
|
|
"update_time" timestamp(0) null,
|
||
|
|
"remark" varchar(500) null
|
||
|
|
);
|
||
|
|
|
||
|
|
comment on table "interview_invitation" is '面试邀约表';
|
||
|
|
comment on column "interview_invitation"."id" is '主键id';
|
||
|
|
comment on column "interview_invitation"."company_id" is '企业id';
|
||
|
|
comment on column "interview_invitation"."job_id" is '岗位id';
|
||
|
|
comment on column "interview_invitation"."user_id" is '用户id';
|
||
|
|
comment on column "interview_invitation"."apply_id" is '申请id';
|
||
|
|
comment on column "interview_invitation"."interview_time" is '面试时间';
|
||
|
|
comment on column "interview_invitation"."interview_method" is '面试方式(online/offline)';
|
||
|
|
comment on column "interview_invitation"."meeting_link" is '腾讯会议链接';
|
||
|
|
comment on column "interview_invitation"."meeting_password" is '会议密码';
|
||
|
|
comment on column "interview_invitation"."interview_location" is '面试地点';
|
||
|
|
comment on column "interview_invitation"."status" is '状态(pending/accepted/rejected/completed)';
|