four

Tables (22)

attendance_records

  • id — BIGINT — Primary key — NOT NULL
  • attendance_session_id — BIGINT — Foreign key → attendance_sessions.id — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • attended_at — DATETIME — NOT NULL

attendance_sessions

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → course_sessions.id — NOT NULL
  • qr_token — VARCHAR(255) — NOT NULL
  • qr_expires_at — DATETIME — NOT NULL
  • is_used — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

bookings

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • session_id — BIGINT — Foreign key → course_sessions.id — NOT NULL
  • booking_type — ENUM('NORMAL','EARLY_BIRD') — NOT NULL
  • status — ENUM('PENDING_PAYMENT','CONFIRMED','CANCELLED','WAITLISTED') — NOT NULL
  • payment_due_at — DATETIME
  • cancelled_at — DATETIME
  • cancel_reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • message_type — ENUM('USER','AI','SYSTEM') — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_room_members

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • joined_at — DATETIME — NOT NULL

chat_rooms

  • id — BIGINT — Primary key — NOT NULL
  • type — ENUM('CLASS','CS') — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id
  • status — ENUM('OPEN','CLOSED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

course_sessions

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • session_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • capacity — INT — NOT NULL
  • early_bird_capacity — INT — NOT NULL
  • enrolled_count — INT — NOT NULL
  • open_at — DATETIME — NOT NULL
  • early_bird_open_at — DATETIME — NOT NULL
  • status — ENUM('SCHEDULED','ONGOING','COMPLETED','CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

courses

  • id — BIGINT — Primary key — NOT NULL
  • instructor_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • category — ENUM('FITNESS','ART','COOKING') — NOT NULL
  • price — INT — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • status — ENUM('DRAFT','OPEN','CLOSED','CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

instructor_subscriptions

  • id — BIGINT — Primary key — NOT NULL
  • subscriber_id — BIGINT — Foreign key → users.id — NOT NULL
  • instructor_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

memberships

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — ENUM('ACTIVE','CANCELLED','EXPIRED') — NOT NULL
  • started_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • cancelled_at — DATETIME
  • monthly_price — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — ENUM( 'BOOKING_CONFIRMED', 'WAITLIST_PROMOTED', 'CLASS_REMINDER', 'CLASS_CANCELLED', 'INSTRUCTOR_NEW_CLASS' ) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • ref_id — BIGINT
  • ref_type — VARCHAR(50)
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

onboarding_categories

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category — ENUM('FITNESS','ART','COOKING') — NOT NULL

onboarding_profiles

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • goal — VARCHAR(100)
  • level — ENUM('BEGINNER','INTERMEDIATE','ADVANCED')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • amount — INT — NOT NULL
  • pg_provider — VARCHAR(50) — NOT NULL
  • pg_transaction_id — VARCHAR(255)
  • status — ENUM('PENDING','PAID','REFUNDED','FAILED') — NOT NULL
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

qna_answers

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → qna_posts.id — NOT NULL
  • instructor_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

qna_posts

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_answered — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

refunds

  • id — BIGINT — Primary key — NOT NULL
  • payment_id — BIGINT — Foreign key → payments.id — NOT NULL
  • amount — INT — NOT NULL
  • reason — ENUM('STUDENT_REQUEST','INSTRUCTOR_CANCEL') — NOT NULL
  • status — ENUM('REQUESTED','COMPLETED','FAILED') — NOT NULL
  • refunded_at — DATETIME
  • pg_refund_id — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reviews

  • id — BIGINT — Primary key — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('ELIGIBLE','WRITTEN','EXPIRED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

social_accounts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — ENUM('KAKAO','GOOGLE') — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('STUDENT','INSTRUCTOR','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE','BANNED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

waitlists

  • id — BIGINT — Primary key — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
  • session_id — BIGINT — Foreign key → course_sessions.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • position — INT — NOT NULL
  • promoted_at — DATETIME
  • status — ENUM('WAITING','PROMOTED','CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

wishlists

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • created_at — DATETIME — NOT NULL