likelion ERD 과제
테이블 (7)
board
- id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT — NOT NULL
- writer — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
board_category
- id — BIGINT — NOT NULL
- board_id — BIGINT — 외래 키 → board.id — NOT NULL
- category_id — BIGINT — 외래 키 → category.id — NOT NULL
board_detail
- id — BIGINT — NOT NULL
- board_id — BIGINT — 외래 키 → board.id — NOT NULL
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
board_tag
- id — BIGINT — NOT NULL
- board_id — BIGINT — 외래 키 → board.id — NOT NULL
- tag_id — BIGINT — 외래 키 → tag.id — NOT NULL
category
- id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — LONGTEXT
comment
- id — BIGINT — NOT NULL
- board_id — BIGINT — 외래 키 → board.id — NOT NULL
- content — LONGTEXT — NOT NULL
- writer — VARCHAR(255) — NOT NULL
tag
- id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL