erd-practice

Tables (8)

comments (Untitled4)

  • comment_id — UUID — Primary key — NOT NULL
  • body — VARCHAR(100)
  • post_id — UUID — Foreign key → posts.post_id — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY

followers (Untitled7)

  • user_id (누가) — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
  • user_id (누구를) — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY

hashtags (Untitled5)

  • tag_id — UUID — Primary key — NOT NULL
  • title — VARCHAR(10)

likes (Untitled8)

  • post_id — UUID — Foreign key → posts.post_id — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY

photos (Untitled3)

  • photo_id — UUID — Primary key — NOT NULL
  • image_url — VARCHAR(100)
  • post_id — UUID — Foreign key → posts.post_id — NOT NULL

posts (Untitled2)

  • post_id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
  • content — TEXT

posts_hashtags (Untitled6)

  • tag_id — UUID — Foreign key → hashtags.tag_id — NOT NULL
  • post_id — UUID — Foreign key → posts.post_id — NOT NULL

users (Untitled)

  • user_id — UUID — Primary key — NOT NULL — RRIMARY KEY
  • name — VARCHAR(100)
  • created_at — TIMESTAMP