데베설

테이블 (14)

Booking

  • booking_id — 기본 키 — NOT NULL
  • student_id (Key2) — 외래 키 → Student.student_id — NOT NULL
  • sport_id — 외래 키 → Sport.sport_id — NOT NULL

Cerrification (Hashtag)

  • certification_id (hashtag_id) — 기본 키 — NOT NULL

Hashtag (Location)

  • hashtag_idy (location_id) — 기본 키 — NOT NULL

Instructor

  • Instructor_id (instructor_id) — 기본 키 — NOT NULL

Instructor_Certification (Instructor_Hashtag)

  • instructor_certification_id (Instructor_hashtag_id) — 기본 키 — NOT NULL
  • Instructor_id (Key2) — 외래 키 → Instructor.Instructor_id — NOT NULL
  • certification_id (Key3) — 외래 키 → Cerrification.certification_id — NOT NULL

Instructor_Locatoin (sdfsf)

  • Key (instructor_certification_id) — 기본 키 — NOT NULL
  • Instructor_id (instructor_id) — 외래 키 → Instructor.Instructor_id — NOT NULL
  • location_id (lotaon) — 외래 키 → Location.location_id — NOT NULL

Instructor_Sport

  • instructor_sport_id — 기본 키 — NOT NULL
  • Instructor_id (Key2) — 외래 키 → Instructor.Instructor_id — NOT NULL
  • sport_id (Key3) — 외래 키 → Sport.sport_id — NOT NULL

Lesson

  • lesson_id — 기본 키 — NOT NULL
  • Instructor_id (instructor_id) — 외래 키 → Instructor.Instructor_id — NOT NULL
  • sport_id — 외래 키 → Sport.sport_id — NOT NULL
  • location_id (lotaon) — 외래 키 → Location.location_id — NOT NULL
  • booking_id — 외래 키 → Booking.booking_id — NOT NULL
  • student_id (Key2) — 외래 키 → Booking.student_id — NOT NULL
  • sport_id (sport_id2) — 외래 키 → Booking.sport_id — NOT NULL
  • student_id — 외래 키 → Student.student_id — NOT NULL
  • Key (review_id) — 외래 키 → Review.Key — NOT NULL
  • student_id (Key) — 외래 키 → Review.student_id — NOT NULL

Location (lcoation)

  • location_id (lotaon) — 기본 키 — NOT NULL

Review

  • Key (review_id) — 기본 키 — NOT NULL
  • student_id (Key) — 외래 키 → Student.student_id — NOT NULL

Sport

  • sport_id — 기본 키 — NOT NULL

Student

  • student_id — 기본 키 — NOT NULL

Untitled (Slot)

  • Key (slot_id) — 기본 키 — NOT NULL
  • Instructor_id (instructor_id) — 외래 키 → Instructor.Instructor_id — NOT NULL
  • booking_id — 외래 키 → Booking.booking_id — NOT NULL

instructor_hashtag (Instructor_Location)

  • instructor_hashtag_id (instructor_location_id) — 기본 키 — NOT NULL
  • Instructor_id (Key2) — 외래 키 → Instructor.Instructor_id — NOT NULL
  • hashtag_idy (Key3) — 외래 키 → Hashtag.hashtag_idy — NOT NULL