Devmountain-test
Tables (9)
Category
- category_id — BIGINT
- category_name — VARCHAR(255)
ChatMessage
- chat_id — BIGINT
- chatroom_id — BIGINT
- user_id — BIGINT
- message — TEXT
- is_ai_response — BOOLEAN
- created_at — DATETIME
ChatRoom
- chatroom_id — BIGINT
- user_id — BIGINT
- room_type — ENUM('DEFAULT', 'PREMIUM')
- created_at — DATETIME
Lecture
- lecture_id — BIGINT
- title — VARCHAR(255)
- summary — TEXT
- instructor — VARCHAR(255)
- price — INTEGER
- image_url — VARCHAR(255)
- category_id — BIGINT
Order
- order_id — BIGINT
- user_id — BIGINT
- price — INTEGER
- status — ENUM('PENDING', 'PAID', 'FAILED')
- created_at — DATETIME
- updated_at — DATETIME
Payment
- payment_id — BIGINT
- order_id — BIGINT
- payment_key — VARCHAR(255)
- method — ENUM('CARD', 'KAKAO', 'TOSS')
- result — ENUM('SUCCESS', 'FAIL')
- membership_level_changed_to — ENUM('FREE', 'PRO')
- created_at — DATETIME
Recommendation
- recommend_id — BIGINT
- chat_id — BIGINT
- user_id — BIGINT
- lecture_id — BIGINT
- score — FLOAT
- created_at — DATETIME
User
- user_id — BIGINT
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- login_type — ENUM('EMAIL', 'GOOGLE', 'KAKAO')
- membership_level — ENUM('FREE', 'PRO')
- created_at — DATETIME
- updated_at — DATETIME
UserCategory
- user_category_id — BIGINT
- user_id — BIGINT
- category_id — BIGINT