simple_board
Tables (3)
board
- id (Key) — BIGINT(32) — Primary key — NOT NULL
- board_name (Field) — VARCHAR(100) — NOT NULL
- status (Field2) — VARCHAR(50) — NOT NULL
post (Untitled)
- id (Key) — BIGINT(32) — Primary key — NOT NULL
- board_id (Key2) — BIGINT(32) — Foreign key → board.id — NOT NULL
- username (Field) — VARCHAR(50) — NOT NULL
- password (Field2) — VARCHAR(5) — NOT NULL
- email (Field3) — VARCHAR(100) — NOT NULL
- status (Field4) — VARCHAR(50) — NOT NULL
- title (Field5) — VARCHAR(100) — NOT NULL
- content (Field6) — TEXT
- posted_at (Field7) — DATETIME — NOT NULL
reply (Untitled2)
- id (Key) — BIGINT(32) — Primary key — NOT NULL
- post_id (Key2) — BIGINT(32) — Foreign key → post.id — NOT NULL
- user_name (Field) — VARCHAR(50) — NOT NULL
- password (Field2) — VARCHAR(4) — NOT NULL
- status (Field3) — VARCHAR(50) — NOT NULL
- title (Field4) — VARCHAR(100) — NOT NULL
- content (Field5) — TEXT — NOT NULL
- replied_at (Field6) — DATETIME — NOT NULL