Instagram

Tables (11)

Block (Untitled10)

  • id (Key) — long — Primary key — NOT NULL
  • id (blocked_id) — long — Foreign key → User.id — NOT NULL
  • id (blocking_id) — long — Foreign key → User.id — NOT NULL

Comments (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.id — NOT NULL
  • post_id (Key3) — long — Foreign key → Post.id — NOT NULL
  • content (Field) — String
  • created_at (Field2) — LocalDateTime
  • modified_at (Field3)

Following (Untitled8)

  • id (Key) — long — Primary key — NOT NULL
  • follower_id (Key2) — long — Foreign key → User.id — NOT NULL
  • following_id (Key22) — long — Foreign key → User.id — NOT NULL
  • accepted (Field) — Boolean

Images (Untitled5)

  • id (Key) — long — Primary key — NOT NULL
  • post_id (Key2) — long — Foreign key → Post.id — NOT NULL
  • url (Field) — String
  • created_at (Field2)
  • modified_at (Field3) — LocalDateTime

Likes_post (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • post_id (Key2) — int — Foreign key → Post.id — NOT NULL
  • user_id (Key22) — int — Foreign key → User.id — NOT NULL
  • created_at (Field) — LocalDateTime
  • modified_at (Field2) — LocalDateTime

Likes_story (Untitled7)

  • id (Key) — long — Primary key — NOT NULL
  • story_id (Key2) — long — Foreign key → Story.id — NOT NULL
  • user_id (Key22) — long — Foreign key → User.id — NOT NULL
  • created_at (Field) — LocalDateTime
  • modified_at (Field2) — LocalDateTime
  • Key3 — Foreign key → Story.Key3 — NOT NULL

Post (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.id — NOT NULL
  • content (Field) — String
  • like_count (Field2) — int
  • created_at (Field3) — LocalDateTime
  • modifiried (Field4) — LocalDateTime
  • tag (Field5) — String

Save (Untitled9)

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

Story (Untitled6)

  • id (Key) — long — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.id — NOT NULL
  • image_url (Field) — String

User (Untitled)

  • id (Key2) — long — Primary key — NOT NULL
  • passward (Field) — String
  • email (Field2) — String
  • birthday (Field3) — String
  • created_at (Field5) — LocalDateTime
  • modified_at (Field6) — LocalDateTime
  • name (Field4) — Stirng

Video (CopyOfUntitled5)

  • id (Key) — long — Primary key — NOT NULL
  • post_id (Key2) — long — Foreign key → Post.id — NOT NULL
  • url (Field) — String
  • created_at (Field2)
  • modified_at (Field3) — LocalDateTime