ss
Tables (5)
BOARD
- board_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
- category_id — BIGINT — Foreign key → CATEGORY.category_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — DATETIME — NOT NULL
BOARD_LIKE
- board_id — BIGINT — Foreign key → BOARD.board_id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
CATEGORY
- category_id — BIGINT — Primary key — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
COMMENT
- comment_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARD.board_id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
MEMBER
- member_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL