무제ek
테이블 (9)
Applications
- application_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- status — ENUM('submitted', 'interview_waiting', 'review_waiting', 'review_completed')
- is_passed — BOOLEAN
- applied_at — TIMESTAMP
- updated_at — TIMESTAMP
- post_id — INT — 외래 키 → Posts.post_id — NOT NULL
CustomQuestions
- question_id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → Posts.post_id — NOT NULL
- question_text — TEXT — NOT NULL
- question_order — INT — NOT NULL
- created_at — TIMESTAMP
Images
- image_id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → Posts.post_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- image_order — INT — NOT NULL
- created_at — TIMESTAMP
InterviewReservations
- reservation_id — INT — 기본 키 — NOT NULL
- slot_id — INT — 외래 키 → InterviewSlots.slot_id
- status — ENUM('reserved', 'completed', 'cancelled')
- created_at — TIMESTAMP
- application_id — INT — 외래 키 → Applications.application_id — NOT NULL
InterviewSlots
- slot_id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → Posts.post_id — NOT NULL
- interview_date — DATE — NOT NULL
- interview_time — TIME — NOT NULL
- max_capacity — INT
- created_at — TIMESTAMP
Messages
- message_id — INT — 기본 키 — NOT NULL
- sender_user_id — INT — NOT NULL
- receiver_user_id — INT — NOT NULL
- post_id — INT — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
Posts
- post_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- organization — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- recruitment_start — DATE — NOT NULL
- recruitment_end — DATE — NOT NULL
- has_interview — BOOLEAN
- status — ENUM('recruiting', 'completed')
- requires_name — BOOLEAN
- requires_student_id — BOOLEAN
- requires_department — BOOLEAN
- requires_gender — BOOLEAN
- requires_age — BOOLEAN
- requires_phone — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
QuestionAnswers
- answer_id — INT — 기본 키 — NOT NULL
- application_id — INT — 외래 키 → Applications.application_id — NOT NULL
- question_id — INT — 외래 키 → CustomQuestions.question_id — NOT NULL
- answer_text — TEXT
- created_at — TIMESTAMP
Users
- user_id — INT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- birth_year — INT — NOT NULL
- gender — ENUM('M', 'F') — NOT NULL
- department — VARCHAR(100) — NOT NULL
- student_id — VARCHAR(20) — NOT NULL
- phone — VARCHAR(20)
- password_hash — VARCHAR(255)
- is_verified — BOOLEAN
- terms_agreed — BOOLEAN — NOT NULL
- privacy_agreed — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP