검흰_마이그레이션
테이블 (14)
assignment_submissions
- id — BIGINT
- assignment_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT
- file_url — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- score — INT
- feedback — TEXT
- submitted_at — TIMESTAMP
assignments
- id — BIGINT
- group_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- due_date — TIMESTAMP
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP
boards
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- description — TEXT
- type — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
carts
- id — BIGINT
- user_id — BIGINT
- session_id — VARCHAR(100)
- lecture_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
enrollments
- id — BIGINT
- user_id — BIGINT — NOT NULL
- lecture_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- progress — INT
- enrolled_at — TIMESTAMP
- completed_at — TIMESTAMP
group_members
- id — BIGINT
- group_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- role — VARCHAR(20) — NOT NULL
- joined_at — TIMESTAMP
groups
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- teacher_id — BIGINT — NOT NULL
- max_students — INT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
lecture_contents
- id — BIGINT
- lecture_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content_url — VARCHAR(255) — NOT NULL
- order_num — INT — NOT NULL
- duration — INT
- created_at — TIMESTAMP
lectures
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- level — VARCHAR(20) — NOT NULL
- pro_player_name — VARCHAR(50) — NOT NULL
- thumbnail_url — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
payments
- id — BIGINT
- user_id — BIGINT — NOT NULL
- enrollment_id — BIGINT — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- paid_at — TIMESTAMP
- cancelled_at — TIMESTAMP
- created_at — TIMESTAMP
posts
- id — BIGINT
- board_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
teacher_applications
- id — BIGINT
- user_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- description — TEXT
- document_url — VARCHAR(255)
- reviewed_by — BIGINT
- reviewed_at — TIMESTAMP
- created_at — TIMESTAMP
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP