연습3
테이블 (5)
board
- board_id — INT — 기본 키 — NOT NULL
- cate_id — INT — 외래 키 → category.cate_id — NOT NULL
- board_name — VARCHAR(20) — NOT NULL
- write_permission — ENUM('admin', 'member') — NOT NULL
category
- cate_id — INT — 기본 키 — NOT NULL
- cate_name — VARCHAR(20) — NOT NULL
comment
- comment_id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → post.post_id — NOT NULL
- id — INT — 외래 키 → user.id — NOT NULL
- nickname — VARCHAR(50)
- content — VARCHAR(1000) — NOT NULL
- created_date — DATETIME — NOT NULL
post
- post_id — INT — 기본 키 — NOT NULL
- board_id — INT — 외래 키 → board.board_id — NOT NULL
- id — INT — 외래 키 → user.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- region — VARCHAR(20)
- travel_start — DATE
- travel_end — DATE
- personnel — INT
- content — VARCHAR(4000) — NOT NULL
- nickname — VARCHAR(50)
- image_path — VARCHAR(255)
- created_date — DATETIME — NOT NULL
- views — INT
user
- id — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(20) — NOT NULL
- password — VARCHAR(20) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50)
- phone_number — VARCHAR(20)
- email — VARCHAR(50) — NOT NULL
- role — ENUM('admin', 'member') — NOT NULL