ERD연습
테이블 (5)
Copy Of Copy Of Untitled (follower)
- Key (follower_id) — bigint — 기본 키 — NOT NULL
- user_id — bigint — 외래 키 → user.user_id — NOT NULL
- Field (following_user) — varchar(50)
- Field (follower_user) — varchar(50)
Copy Of Untitled (comments)
- Key (commets_id) — bigint — 기본 키 — NOT NULL
- user_id — bigint — 외래 키 → user.user_id — NOT NULL
- Key (post_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (comment_content) — varchar(50)
- Field2 (comment_time) — timestamp
Untitled (posts)
- Key (post_id) — bigint — 기본 키 — NOT NULL
- user_id — bigint — 외래 키 → user.user_id — NOT NULL
- Field (eed_contents) — varchar(50)
- Field (feed_picture) — varchar(50)
- Field2 (feed_time) — timestamp
Untitled (like)
- Key (like_id) — bigint — 기본 키 — NOT NULL
- user_id — bigint — 외래 키 → user.user_id — NOT NULL
- Key (post_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
user (users)
- user_id — bigint — 기본 키 — NOT NULL
- Field (user_email) — varchar(50)
- Field2 (user_password) — varchar(50)
- Field3 (user_nickname) — varchar(50)
- Field4 (user_name) — varchar(50)
- Field2 (user_picture) — varchar(50)