ㅁㅁ

Tables (9)

answer_form

  • answer_form_id — BIGINT — Primary key — NOT NULL
  • answer — TEXT — NOT NULL
  • score — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

candidate

  • candidate_id — BIGINT — Primary key — NOT NULL
  • candidate_key — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(255) — NOT NULL
  • birth — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat

  • chat_id — BIGINT — Primary key — NOT NULL
  • chatroom_code — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30)
  • role — VARCHAR(30)
  • text — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

chatroom_info

  • chatroom_info_id — BIGINT — Primary key — NOT NULL
  • chatroom_code — VARCHAR(255) — NOT NULL
  • interview_key — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

company

  • company_id — VARCHAR(255) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • company_code — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee

  • employee_id — BIGINT — Primary key — NOT NULL
  • employee_key — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(13) — NOT NULL
  • birth — DATE — NOT NULL
  • company_name — VARCHAR(50) — NOT NULL
  • company_code — VARCHAR(255) — NOT NULL
  • department — VARCHAR(30) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

interview

  • interview_id — BIGINT — Primary key — NOT NULL
  • interview_key — VARCHAR(255) — NOT NULL
  • company_id — VARCHAR(255) — NOT NULL
  • department — VARCHAR(50) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • interview_date — DATE — NOT NULL
  • start_time — DATETIME — NOT NULL — 면접 시작 시간
  • end_time — DATETIME — NOT NULL — 면접 종료 시간
  • created_at — DATETIME — NOT NULL — 면접 일정 생성 시간
  • updated_at — DATETIME — NOT NULL — 면접 일정 수정 시간

interview_participants

  • interview_participants_id — BIGINT — Primary key — NOT NULL
  • interview_key — VARCHAR(255) — NOT NULL
  • participants_key — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • interview_number — BIGINT — 응시자만
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

question_form

  • question_form_id — BIGINT — Primary key — NOT NULL
  • interview_key — VARCHAR(255) — NOT NULL — 면접 키
  • question — TEXT — NOT NULL — List<String> 으로 받아옴
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL