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