lxp-second
Tables (11)
carts
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- created_at — DATETIME — NOT NULL
courses
- id — BIGINT — Primary key — NOT NULL
- instructor_id — BIGINT — Foreign key → instructor.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- price — INT — NOT NULL
- thumbnail_url — VARCHAR(500)
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
enrollments
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- enrolled_at — DATETIME — NOT NULL
- expired_at — DATETIME
- order_item_id — BIGINT — Foreign key → order_items.id — NOT NULL
instructor
- id — BIGINT — Primary key — NOT NULL
- introduction — TEXT — NOT NULL
- expertise — VARCHAR(255) — NOT NULL
- career — TEXT
- image_url — VARCHAR(500)
- contact — VARCHAR(100)
- portfolio_url — VARCHAR(500)
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
lectures
- id — BIGINT — Primary key — NOT NULL
- section_id — BIGINT — Foreign key → sections.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content_url — VARCHAR(500)
- video_url — VARCHAR(500)
- duration_sec — INT
- sort_order — INT — NOT NULL
- is_preview — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
members
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone — VARCHAR(30)
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
missions
- id — BIGINT — Primary key — NOT NULL
- section_id — BIGINT — Foreign key → sections.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
order_items
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- course_title_snapshot — VARCHAR(200) — NOT NULL
- instructor_name_snapshot — VARCHAR(100) — NOT NULL
- course_price_snapshot — INT — NOT NULL
- created_at — DATETIME — NOT NULL
orders
- id — BIGINT — Primary key — NOT NULL
- order_no — VARCHAR(100) — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- total_amount — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
payments
- id — BIGINT — Primary key — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- payment_key — VARCHAR(255)
- requested_amount — INT — NOT NULL
- approved_amount — INT
- status — VARCHAR(30) — NOT NULL
- approved_at — DATETIME
- failed_reason — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
sections
- id — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL