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