ㅡ

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