ㅡ
Tables (13)
calendars
- id — INT
- user_id — INT
- event_title — VARCHAR(255)
- start_datetime — DATETIME
- end_datetime — DATETIME
- is_routine — BOOLEAN
group_availability
- id — INT
- group_id — INT
- user_id — INT
- available_time_range — JSON
- date — DATE
group_members
- id — INT
- group_id — INT
- user_id — INT
- joined_at — DATETIME
groups
- id — INT
- leader_id — INT
- title — VARCHAR(255)
- special_key — VARCHAR(20)
- created_at — DATETIME
- expires_at — DATETIME
question_results
- id — INT
- attempt_id — INT
- question_id — INT
- user_answer — TEXT
- is_correct — BOOLEAN
quiz_attempts
- id — INT
- user_id — INT
- quiz_id — INT
- attempt_time — DATETIME
- score — INT
- review_count — INT
quiz_questions
- id — INT
- quiz_id — INT
- question_text — TEXT
- correct_answer — TEXT
- options — JSON
- image_url — TEXT
quizzes
- id — INT
- user_id — INT
- title — VARCHAR(255)
- file_url — TEXT
- keywords — TEXT
- question_type — ENUM('objective', 'ox', 'short', 'fill_blank')
- summary — TEXT
routine_records
- id — INT
- user_id — INT
- routine_id — INT
- date — DATE
- completed — BOOLEAN
study_routines
- id — INT
- title — VARCHAR(100)
- start_time — TIME
- end_time — TIME
- days_of_week — VARCHAR(20)
- is_active — BOOLEAN
study_sessions
- id — INT
- user_id — INT
- subject — VARCHAR(100)
- start_time — DATETIME
- end_time — DATETIME
- resumed — BOOLEAN
timetables
- id — INT
- user_id — INT
- subject_name — VARCHAR(100)
- day_of_week — VARCHAR(10)
- start_time — TIME
- end_time — TIME
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- social_provider — ENUM('kakao', 'apple', 'google', 'none')
- name — VARCHAR(100)
- university — VARCHAR(100)
- department — VARCHAR(100)
- profile_image_url — TEXT