ㅇㅇ
Tables (11)
announcement
- announcement_id — BIGINT
- course_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- is_important — BOOLEAN
- is_published — BOOLEAN
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
category
- category_id — BIGINT
- parent_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- display_order — INT
- is_active — BOOLEAN
- created_at — TIMESTAMP
course
- course_id — BIGINT
- instructor_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- thumbnail — VARCHAR(500)
- category_id — BIGINT
- level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED')
- language — VARCHAR(10)
- access_type — ENUM('FREE', 'SUBSCRIPTION')
- subscription_price — DECIMAL(10, 2)
- is_published — BOOLEAN
- total_duration — INT
- total_lessons — INT
- rating_avg — DECIMAL(3, 2)
- rating_count — INT
- view_count — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_access_type
- INDEX — idx_category
- INDEX — idx_instructor
course_bookmark
- bookmark_id — BIGINT
- member_id — BIGINT — NOT NULL
- course_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
course_review
- review_id — BIGINT
- course_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- rating — TINYINT — NOT NULL
- comment — TEXT — EX
- is_published — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
course_subscription
- subscription_id — BIGINT
- member_id — BIGINT — NOT NULL
- course_id — BIGINT — NOT NULL
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- status — ENUM('ACTIVE', 'CANCELLED', 'EXPIRED')
- payment_method — ENUM('CARD', 'BANK_TRANSFER', 'PAYPAL') — NOT NULL
- amount_paid — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
- cancelled_at — TIMESTAMP
- INDEX — idx_member_status
- INDEX — idx_course_status
instructor_profile
- instructor_id — BIGINT
- expertise — TEXT
- experience — TEXT
- education — TEXT
- certifications — TEXT
- social_links — JSON
- bank_account — VARCHAR(100)
- tax_info — JSON
learning_progress
- progress_id — BIGINT
- member_id — BIGINT — NOT NULL
- lesson_id — BIGINT — NOT NULL
- watched_duration — INT
- is_completed — BOOLEAN
- last_watched_at — TIMESTAMP
- completed_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
lesson
- lesson_id — BIGINT
- course_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- video_url — VARCHAR(500)
- duration — INT — NOT NULL
- lesson_order — INT — NOT NULL
- access_type — ENUM('FREE', 'SUBSCRIPTION')
- thumbnail — VARCHAR(500)
- is_published — BOOLEAN
- view_count — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_course_order
- INDEX — idx_access_type
member
- member_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('STUDENT', 'INSTRUCTOR', 'ADMIN')
- profile_image — VARCHAR(500)
- bio — TEXT
- phone — VARCHAR(20)
- is_active — BOOLEAN
- email_verified — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payment_history
- payment_id — BIGINT
- subscription_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- course_id — BIGINT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- payment_method — ENUM('CARD', 'BANK_TRANSFER', 'PAYPAL') — NOT NULL
- payment_status — ENUM('PENDING', 'SUCCESS', 'FAILED', 'REFUNDED')
- transaction_id — VARCHAR(255)
- paid_at — TIMESTAMP
- refunded_at — TIMESTAMP
- created_at — TIMESTAMP
- INDEX — idx_member_status
- INDEX — idx_transaction