아이헤이트플라잉버그스
테이블 (12)
FeedResults
- result_id — VARCHAR(36)
- feed_id — VARCHAR(36) — NOT NULL
- student_id — VARCHAR(36) — NOT NULL
- result_type — ENUM('VIDEO', 'MULTIPLE_CHOICE', 'GRAMMAR') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
Feeds
- feed_id — VARCHAR(36)
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- feed_type — ENUM('VIDEO', 'MULTIPLE_CHOICE', 'GRAMMAR') — NOT NULL
- content — LONGTEXT
- group_id — VARCHAR(36) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
GrammarFeeds
- feed_id — VARCHAR(36)
- question — TEXT — NOT NULL
- correct_answer — TEXT — NOT NULL
- explanation — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
GrammarResults
- result_id — VARCHAR(36)
- answer — TEXT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
GroupStudents
- group_id — VARCHAR(36) — 기본 키 — NOT NULL
- student_id — VARCHAR(36) — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
Groups
- group_id — VARCHAR(36)
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- grade — INT
- level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED') — NOT NULL
- teacher_id — VARCHAR(36) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
MultipleChoiceFeeds
- feed_id — VARCHAR(36)
- question — TEXT — NOT NULL
- options — JSON — NOT NULL
- correct_answer — VARCHAR(10) — NOT NULL
- explanation — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
MultipleChoiceResults
- result_id — VARCHAR(36)
- selected_option — VARCHAR(10) — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
Students
- student_id — VARCHAR(36)
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
Teachers
- teacher_id — VARCHAR(36)
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
VideoFeeds
- feed_id — VARCHAR(36)
- video_url — VARCHAR(255) — NOT NULL
- duration — INT — NOT NULL
- thumbnail_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
VideoResults
- result_id — VARCHAR(36)
- watch_duration — INT — NOT NULL
- completed — BOOLEAN
- last_position — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP