정승우_board
테이블 (5)
categories
- Category_Id (category_id) — INT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
comments
- Comment_Id (comment_id) — INT — 기본 키 — NOT NULL
- content — TEXT — NOT NULL
- Post_Id (post_id) — INT — 외래 키 → posts.Post_Id — NOT NULL
- User_Id (user_id) — INT — 외래 키 → users.User_Id — NOT NULL
posts
- Post_Id (post_id) — INT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- Category_Id (category_id) — INT — 외래 키 → categories.Category_Id — NOT NULL
- User_Id (user_id) — INT — 외래 키 → users.User_Id — NOT NULL
replies
- id — INT
- content — TEXT — NOT NULL
- Comment_Id (comment_id) — INT — 외래 키 → comments.Comment_Id — NOT NULL
- User_Id (user_id) — INT — 외래 키 → users.User_Id — NOT NULL
users
- User_Id (user_id) — INT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL