seungstagram

Tables (7)

Comment

  • Key (id) — int — Primary key — NOT NULL
  • Key (post_id) — int — Foreign key → Post.Key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (text) — VARCHAR
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime

Copy Of Post (File)

  • Key (id) — int — Primary key — NOT NULL
  • Key (post_id) — int — Foreign key → Post.Key — NOT NULL
  • Field (url) — VARCHAR
  • Field (createdAt) — VARCHAR
  • Field (updatedAt) — VARCHAR

Like

  • Key (id) — int — Primary key — NOT NULL
  • Key (post_id) — int — Foreign key → Post.Key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime

Post

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (caption) — VARCHAR
  • Field (location) — VARCHAR
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime

Profile

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (username) — VARCHAR
  • Field (firstName) — VARCHAR
  • Field (lastName) — VARCHAR
  • Field (picture) — VARCHAR
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime

Untitled (Follow)

  • Key (id) — int — Primary key — NOT NULL
  • Key (follower_user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (followee_user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime

User

  • Key (id) — int — Primary key — NOT NULL
  • Field (email) — VARCHAR
  • Field (password) — VARCHAR