ruby_exam_project

Tables (3)

Exams (시험)

  • exam_id (Key) — Primary key — NOT NULL
  • stare_num (응시 인원)
  • available_num (가능 인원)
  • start_time (시작일)
  • end_time (종료일)
  • title (시험 제목)
  • content (시험 내용)

Reservation (예약)

  • reservation_id (Key) — Primary key — NOT NULL
  • customer_id (Key2) — Foreign key → Users.customer_id — NOT NULL
  • exam_id (Key3) — Foreign key → Exams.exam_id — NOT NULL
  • status (예약 상태)

Users (고객)

  • customer_id (Key) — Primary key — NOT NULL
  • email (이메일)
  • role (권한)
  • pw (비번)