ERD

Tables (5)

Availability (가능시간)

  • availabilityId (가능시간아이디) — BIGINT — Primary key — NOT NULL
  • tutorId (튜토아이디) — BIGINT — Foreign key → Tutor.tutorId — NOT NULL
  • startTime (시작시간) — DATETIME
  • duration (기간) — INT
  • availabilityStatus (가능시간상태) — ENUM
  • AvailabilityStatusDetail (Field) — ENUM
  • created_at (생성일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

Booking (예약)

  • bookingId (예약아이디) — BIGINT — Primary key — NOT NULL
  • studentId (학생아이디) — BIGINT — Foreign key → Student.studentId — NOT NULL
  • subjectName (과목명) — VARCHAR(100)
  • created_at (생성일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

Booking_Availability (예약관리내역)

  • bookingAvailabilityId (예약관리아이디) — BIGINT — Primary key — NOT NULL
  • bookingId (예약아이디) — BIGINT — Foreign key → Booking.bookingId — NOT NULL
  • availabilityId (가능시간아이디) — BIGINT — Foreign key → Availability.availabilityId — NOT NULL
  • bookingStatus (예약관리상태) — ENUM
  • created_at (생성일) — DATETIME
  • updated_at (업데이트일) — DATETIME
  • deleted_at (삭제일) — DATETIME

Student (학생)

  • studentId (학생아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(100)
  • email (이메일) — VARCHAR(100)
  • created_at (생성일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

Tutor (튜터)

  • tutorId (튜토아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(100)
  • email (이메일) — VARCHAR(255)
  • created_at (생성일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP