SimpleBoard
Tables (3)
Untitled (board)
- Key (id) — BIGINT(32) — Primary key — NOT NULL
- Field (board_name) — VARCHAR(100)
- Field2 (status) — VARCHAR(100)
Untitled (post)
- Key (id) — BIGINT(32) — Primary key — NOT NULL
- Key (board_id) — BIGINT(32) — Foreign key → Untitled.Key — NOT NULL
- Field (user_name) — VARCHAR(50)
- Field (password) — VARCHAR(4)
- Field (email) — VARCHAR(100)
- Field (status) — VARCHAR(50)
- Field (title) — VARCHAR(100)
- Field (content) — TEXT
- Field (posted_at) — DATETIME
Untitled (reply)
- Key (id) — BIGINT(32) — Primary key — NOT NULL
- Key (post_id) — BIGINT(32) — Foreign key → Untitled.Key — NOT NULL
- Field (user_name) — VARCHAR(50)
- Field (password) — VARCHAR(50)
- Field (title) — VARCHAR(100)
- Field (content) — TEXT
- Field (replied_at) — DATETIME