ㅁㅁ
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