한걸음씩 erd
테이블 (7)
category (Category)
- Key (post_id) — 외래 키 → post.Key — NOT NULL
- Field2 (free_category) — String — NOT NULL
- Field (info_category) — String — NOT NULL
comment (Comment)
- Key (comment_id) — 기본 키 — NOT NULL
- Key (post_id) — 외래 키 → post.Key — NOT NULL
- id (user_id) — 외래 키 → profile.id — NOT NULL
- Field2 (body) — String — NOT NULL
- Field (create_time) — String
post (Post)
- Key (post_id) — 기본 키 — NOT NULL
- id (user_id) — 외래 키 → profile.id — NOT NULL
- Field (title)
- Field2 (body) — String — NOT NULL
- Field (create_time) — String — NOT NULL
- Field (update_time)
post_likes (Post_likes)
- Key (post_id) — 외래 키 → post.Key — NOT NULL
- id (user_id) — 외래 키 → profile.id — NOT NULL
profile (Profile)
- id (user_id) — 외래 키 → user.id — NOT NULL
- Field (nickname)
- Field2 (phone_number) — String — NOT NULL
- Field (email) — String — NOT NULL
- Field (name) — String
profile_image (Post_image)
- Key (post_image_id) — 기본 키 — NOT NULL
- Key (post_id) — 외래 키 → post.Key — NOT NULL
- Field2 (url) — String — NOT NULL
user (User)
- id (user_id) — 기본 키 — NOT NULL
- Field (id)
- Field (password)
- Field (kakao_id)
- Field2 (naver_id)
- Field3 (role) — enum