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)