erd

Tables (5)

Answer (Untitled3)

  • aid (Key) — Long — Primary key — NOT NULL
  • qid (Key2) — Long — Foreign key → Question.qid — NOT NULL
  • uid (Key3) — Long — Foreign key → User.uid — NOT NULL
  • content (Field) — Varchar
  • createdAt (Field2) — Datetime
  • modifiedAt (Field3) — Datetime
  • isSelected (Field4) — Boolean

Answer Vote (Untitled5)

  • arid (Key) — Long — Primary key — NOT NULL
  • aid (Key2) — Long — Foreign key → Answer.aid — NOT NULL
  • uid (Key4) — Long — Foreign key → User.uid — NOT NULL

Question (Untitled2)

  • qid (Key) — Long — Primary key — NOT NULL
  • uid (Key2) — Long — Foreign key → User.uid — NOT NULL
  • title (Field) — Varchar
  • content (Field2) — Varchar
  • createdAt (Field3) — Datetime
  • modifiedAt (Field4) — Datetime
  • view (Field5) — Integer

Question Vote (Untitled4)

  • qrid (Key) — Long — Primary key — NOT NULL
  • qid (Key2) — Long — Foreign key → Question.qid — NOT NULL
  • uid (Key3) — Long — Foreign key → User.uid — NOT NULL

User (Untitled)

  • uid (Key) — Long — Primary key — NOT NULL
  • email (Field) — Varchar
  • username (Field2) — Varchar
  • image (Field3) — Varchar
  • password (Field4) — Varchar