Instagram_Modeling

Tables (5)

Comment (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • post_id (Key3) — int — Foreign key → Post.id — NOT NULL
  • text (Field) — varchar

Like (Untitled4)

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

Media (Untitled3)

  • Key — Primary key — NOT NULL
  • content_url (Field2) — varchar
  • post_id (Key2) — int — Foreign key → Post.id — NOT NULL

Post (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • text (Field) — varchar
  • created_at (Field2) — timestamp
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • name (Field2) — varchar
  • password (Field3) — password
  • created_at (Field4) — timestamp