pre

Tables (3)

Answer

  • Key (aid) — bigint — Primary key — NOT NULL
  • Key (user_email) — String — Foreign key → Users.Key — NOT NULL
  • Key (qid) — Bigint — Foreign key → Question.Key — NOT NULL
  • Key (other_email) — String — Foreign key → Question.Key — NOT NULL
  • Field (body) — String
  • Field (created) — date
  • Field (modified) — date

Question

  • Key (qid) — Bigint — Primary key — NOT NULL
  • Key (user_email) — String — Foreign key → Users.Key — NOT NULL
  • Field (title) — String
  • Field (body) — String
  • Field (created) — date
  • Field (modified) — date

Users (User)

  • Key (email) — String — Primary key — NOT NULL
  • Field (username) — String
  • Field2 (password) — String
  • Field (created) — date