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