assignment_ERD

Tables (11)

Comment (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key3) — Long — Foreign key → User.id — NOT NULL
  • post_id (Key2) — Long — Foreign key → Post.id — NOT NULL
  • message (Field) — String

Follow (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • follower_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • following_id (Key3) — Long — Foreign key → User.id — NOT NULL

Image (Untitled11)

  • id (Key) — Long — Primary key — NOT NULL
  • post_id (Key2) — Long — Foreign key → Post.id — NOT NULL
  • image_url (Field) — String

Post (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • like (Field3) — int
  • created_at (Field5) — LocalDateTime
  • modified_at (Field6) — LocalDateTime

Post_Like (Untitled3)

  • id (Key3) — Long — Primary key — NOT NULL
  • post_id (Key) — Long — Foreign key → Post.id — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL

Save (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • post_id (Key3) — Long — Foreign key → Post.id — NOT NULL

Story (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • image (Field) — String
  • created_at (Field2) — LocalDateTime
  • modified_at (Field3) — LocalDateTime

Story_Comment (Untitled10)

  • id (Key) — Long — Primary key — NOT NULL
  • message (Field) — String
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • story_id (Key3) — Long — Foreign key → Story.id — NOT NULL

Stroy_Like (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • story_id (Key3) — Long — Foreign key → Story.id — NOT NULL

User (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • age (Field2) — int
  • nickName (Field5) — String
  • email (Field3) — String
  • phoneNumber (Field4) — String
  • profile_image (Field6) — String

Video (Untitled12)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → Post.id — NOT NULL
  • video_url (Field) — String