앱개발1

테이블 (5)

problem

  • id — BIGINT
  • subject_id — INTEGER — 외래 키 → subject.id — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT — NOT NULL
  • 텍스트) — explanation
  • (비용 — 절감) — NOT NULL
  • difficulty — INTEGER
  • option1 — TEXT
  • option2 — TEXT
  • option3 — TEXT
  • option4 — TEXT
  • option5 — TEXT
  • is_ai_generated — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

study_session

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • subject_id — INTEGER — 외래 키 → subject.id — NOT NULL
  • total_count — INTEGER
  • correct_count — INTEGER
  • created_at — TIMESTAMPTZ

subject

  • id — SERIAL
  • name — TEXT — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

user_answer

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • problem_id — BIGINT — 외래 키 → problem.id — NOT NULL
  • session_id — BIGINT — 외래 키 → study_session.id — NOT NULL
  • submitted_answer — TEXT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • submitted_at — TIMESTAMPTZ

users

  • id — BIGINT
  • google_id — TEXT
  • email — TEXT — NOT NULL
  • nickname — TEXT
  • role — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ