ㅁㅁ
Tables (4)
Boards
- board_id — INT
- writer_id — VARCHAR(100) — Foreign key → Members.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME
- deleted_date — DATETIME
Files
- file_id — INT
- board_id — INT — Foreign key → Boards.board_id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- path — VARCHAR(255) — NOT NULL
Members
- id — VARCHAR(100)
- password_hash — VARCHAR(255) — NOT NULL
Replies
- reply_id — INT
- board_id — INT — Foreign key → Boards.board_id — NOT NULL
- writer_id — VARCHAR(100) — Foreign key → Members.id — NOT NULL
- content — TEXT — NOT NULL
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME
- deleted_date — DATETIME