reservation

Tables (4)

instructor (Untitled4)

  • instructor_id (강사 id) — Primary key — NOT NULL

participant (Untitled2)

  • reservation_id (상담 id) — Foreign key → reservation.reservation_id — NOT NULL
  • student_id (학생 id) — Foreign key → student.student_id — NOT NULL

reservation (Untitled)

  • reservation_id (상담 id) — Primary key — NOT NULL
  • instructor_id (강사 id) — Foreign key → instructor.instructor_id — NOT NULL
  • reservation_at (예약 당시 날짜)
  • reservation_date (예약 날짜)
  • time (예약 타임)

student (Untitled3)

  • student_id (학생 id) — Primary key — NOT NULL