CRUD
Tables (3)
Untitled (Member)
- Key (id) — Long — Primary key — NOT NULL
- Field (name) — String
- Field (e-mail) — String
- Field (password) — String
Untitled (Post)
- Key (id) — Long — Primary key — NOT NULL — PK
- Key (member_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field (title) — String
- Field (date) — DATE
- Field (like) — int
Untitled (Comment)
- Key (id) — Long — Primary key — NOT NULL
- Key (member_id) — Member — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — Post — Foreign key → Untitled.Key — NOT NULL — PK
- Field (contents) — String