무제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