앱개발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