Instagram

Tables (6)

Follow

  • Key (follow_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (follower_id) — int — NOT NULL
  • Field2 (following_id) — int — NOT NULL

Untitled (Post)

  • Key (post_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (content) — text
  • Field (hashtag) — text
  • Field2 (like_count) — int
  • Field3 (created_date) — timestamp — NOT NULL
  • Field4 (modified_date) — timestamp — NOT NULL

Untitled (Comment)

  • Key (comment_id) — int — Primary key — NOT NULL
  • Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field3 (content) — text
  • Field2 (like) — int
  • Field (created_date) — timestamp — NOT NULL
  • Field2 (modified_date) — timestamp — NOT NULL

Untitled (Story)

  • Key (story_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (view_count) — int
  • Field (created_date) — timestamp — NOT NULL

Untitled (Image)

  • Key (image_id) — int — Primary key — NOT NULL
  • Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — text — NOT NULL

User

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (email) — varchar(45) — NOT NULL
  • Field2 (nickname) — varchar(45) — NOT NULL
  • Field3 (password) — varchar(45) — NOT NULL
  • Field (created_date) — timestamp — NOT NULL
  • Field2 (modified_date) — timestamp — NOT NULL