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