45
Tables (11)
ai_problem (problem)
- id — int8 — Primary key — NOT NULL
- subject_id — int4 — Foreign key → subject.id — NOT NULL
- question — varchar(2000) — NOT NULL
- subjective_answer — varchar(2000) — NOT NULL
- option1 — varchar(2000)
- option2 — varchar(2000)
- option3 — varchar(2000)
- option4 — varchar(2000)
- option5 — varchar(2000)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- OBJECTIVE::character — varying)::text)))
code_programming
- id — bigserial — Primary key — NOT NULL
- subject_id — int4 — Foreign key → subject.id
- question — varchar(1000) — NOT NULL
- subjective_answer — varchar(2000) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
money_user_have
- id — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
- money
- created_at
- updated_at
study_session
- id — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
- subject_id — int4 — Foreign key → subject.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
subject
- id — int4 — Primary key — NOT NULL
- subject_id — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL
subscribe
- id — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
- trial_started_at
- trial_expires_at
- subscription_started_at
- subscription_expires_at
- created_at
- updated_at
theory (CopyOfproblem)
- id — int8 — Primary key — NOT NULL
- subject_id — int4 — Foreign key → subject.id — NOT NULL
- question — varchar(2000) — NOT NULL
- subjective_answer — varchar(2000) — NOT NULL
- option1 — varchar(2000)
- option2 — varchar(2000)
- option3 — varchar(2000)
- option4 — varchar(2000)
- option5 — varchar(2000)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- OBJECTIVE::character — varying)::text)))
user_answer
- id — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
- session_id — int8 — Foreign key → study_session.id — NOT NULL
- item_type — varchar(32) — NOT NULL
- submitted_answer — varchar(4000) — NOT NULL
- is_wrong_answer — bool — NOT NULL
- submitted_at — timestamp — NOT NULL
- code_programming::character — varying
- ai_problem::character — varying
- theory::character — varying
- created_at — timestamp
- updated_at — timestamp
user_statistics
- id — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
- subject_id — int8 — Foreign key → subject.id — NOT NULL
- total_count (total_attempted) — int4 — NOT NULL
- wrong_count — int4 — NOT NULL
- correct_count — int4 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- SUBJECTIVE::character — varying
- code_programming::character — varying)::text)))
- theory::character — varying
users
- id — int8 — Primary key — NOT NULL
- google_id — varchar(255)
- email — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- nickname — varchar(255)
- role — varchar(32) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
wrong_answer_bookmark
- id — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
- item_type — varchar(32) — NOT NULL
- reference_id — int8 — NOT NULL
- bookmarked_at — timestamp
- review_count — int4
- SUBJECTIVE::character — varying
- code_programming::character — varying
- theory::character — varying
- created_at — timestamp
- updated_at — timestamp