tennis

Tables (6)

coach (코치)

  • PK (id) — int — Primary key — NOT NULL
  • (created_at) — date
  • (updated_at) — date
  • 이름 (name) — varchar

lesson (레슨)

  • PK (id) — int — Primary key — NOT NULL
  • FK (user_id) — int — Foreign key → user.PK — NOT NULL
  • FK (coach_id) — int — Foreign key → coach.PK — NOT NULL
  • (password) — uuid
  • (created_at) — date
  • (updated_at) — date
  • one-time/regular (type) — varchar
  • 소요시간 (run_time) — float
  • 레슨 횟수 (lesson_number) — int
  • 취소된시간 (cancelled_at) — date
  • 수업스케쥴 (schedule) — jsonb

lesson_histories (레슨 히스토리)

  • PK (id) — int — Primary key — NOT NULL
  • FK (user_id) — int — Foreign key → user.PK — NOT NULL
  • FK (coach_id) — int — Foreign key → coach.PK — NOT NULL
  • FK (lesson_id) — int — Foreign key → lesson.PK — NOT NULL
  • (created_at) — date
  • (updated_at) — date
  • 레슨날짜 (lesson_date) — date
  • 소요시간 (run_time) — float

lesson_slot (레슨슬롯)

  • PK (id) — int — Primary key — NOT NULL
  • FK (coach_id) — int — Foreign key → coach.PK — NOT NULL
  • (created_at) — date
  • (updated_at) — date
  • 요일 (day) — varchar
  • 타임슬롯 (time_slot) — float
  • open/booked/closed (status) — varchar

setting (세팅)

  • PK (id) — int — Primary key — NOT NULL
  • (created_at) — date
  • (updated_at) — date
  • (key) — varchar
  • (value) — varchar

user (유저)

  • PK (id) — int — Primary key — NOT NULL
  • (created_at) — date
  • (updated_at) — date
  • 이름 (name) — varchar
  • 연락처 (phone) — varchar