Capstone

Tables (4)

Answer

  • answer_key — INT — Primary key — NOT NULL
  • problem_key (problem_key2) — INT — Foreign key → Problem.problem_key — NOT NULL
  • answer_text — VARCHAR(255) — NOT NULL
  • is_correct — BOOLEAN — NOT NULL

Post

  • post_key — INT — Primary key — NOT NULL
  • user_key (user_key2) — INT — Foreign key → User.user_key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • date — DATE

Problem

  • problem_key — INT — Primary key — NOT NULL
  • post_key (post_key2) — INT — Foreign key → Post.post_key — NOT NULL
  • problem_text — TEXT — NOT NULL

User

  • user_key — INT — Primary key — NOT NULL
  • id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100)
  • age — INT