sootam_clone

Tables (5)

Ainfo (형태소, 문제 중계모델)

  • Key3 — Primary key — NOT NULL
  • fk_problem_id (Key) — integer — Foreign key → Question.id — NOT NULL
  • fk_element_id (Key2) — integer — Foreign key → Unit.id — NOT NULL

Question (문제)

  • id (Key) — integer — Primary key — NOT NULL
  • year (Field) — string
  • month (Field3) — string
  • copyright (Field2) — string
  • test_type (Field8) — string
  • number (Field5) — integer
  • answer (Field6) — integer
  • corper (Field9) — integer
  • image_data (Field4) — text
  • solution_data (Field7) — text

Union_pu (Untitled5)

  • fk_user_id (key) — integer — Foreign key → Users.id — NOT NULL
  • kf_problem_id (Key) — integer — Foreign key → Question.id — NOT NULL

Unit (형태소)

  • id (Key) — integer — Primary key — NOT NULL
  • chapter (Field) — string
  • name (Field2) — string

Users (유저)

  • id (key) — integer — Primary key — NOT NULL
  • birth (Field3) — string
  • current_sign_in_at (Field) — datetime
  • current_sign_in_ip (Field2) — string
  • email (Field4) — string
  • encrypted_password (Field5) — string
  • grade (Field6) — string
  • sign_in_count (Field7) — integer