instargram

Tables (6)

comment (Untitled2)

  • comment_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.post_id — NOT NULL
  • user_id (Key3) — Foreign key → user.user_id — NOT NULL
  • content (Field)
  • created_at (Field2)

follow (Untitled4)

  • from_user_id (Key) — Foreign key → user.user_id — NOT NULL
  • to_user_id (Key2) — Foreign key → user (alias).user_id — NOT NULL
  • created_at (Field)

likes (Untitled3)

  • post_id (Key) — Foreign key → post.post_id — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL

post (CopyOfUntitled)

  • post_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • image_url (Field)
  • content (Field2)
  • created_at (Field3)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • phone (Field3)
  • profile_image (Field4)
  • create_date (Field5)

user (alias) (CopyOfUntitled2)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • phone (Field3)
  • profile_image (Field4)
  • create_date (Field5)