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