Instagram-clone

Tables (10)

Posts (posts)

  • Key (id) — String — Primary key — NOT NULL
  • Key (users_id) — String — Foreign key → Users.Key — NOT NULL
  • Field (post_content) — longtext
  • Field (location) — String
  • Field (is_hide) — boolean
  • Field (is_comment) — boolean
  • Field (posts_status) — String

PostsComments (postsComments)

  • Key (id) — String — Primary key — NOT NULL
  • Key (posts_id) — String — Foreign key → Posts.Key — NOT NULL
  • Key (users_id) — String — Foreign key → Posts.Key — NOT NULL
  • Field (comments_content) — String

PostsCommentsLike (postsCommentsLike)

  • Key (id) — String — Primary key — NOT NULL
  • Key (comments_id) — String — Foreign key → PostsComments.Key — NOT NULL
  • Key (posts_id) — String — Foreign key → PostsComments.Key — NOT NULL
  • Key (users_id) — String — Foreign key → PostsComments.Key — NOT NULL

PostsLike (postsLike)

  • Key (id) — String — Primary key — NOT NULL
  • Key (posts_id) — String — Foreign key → Posts.Key — NOT NULL
  • Key (users_id) — String — Foreign key → Posts.Key — NOT NULL

PostsPhoto (postsPhoto)

  • Key (id) — String — Foreign key → Posts.Key — NOT NULL
  • Key (posts_id) — String — Foreign key → Posts.Key — NOT NULL

PostsTemporary (postsTemporary)

  • Key (id) — String — Primary key — NOT NULL
  • Key (users_id) — String — Foreign key → Users.Key — NOT NULL
  • Field (posts_content) — longtext
  • Field (location) — String
  • Field (is_hide_count) — boolean
  • Field (is_comment) — boolean
  • Field (posts_like) — Int
  • Field (posts_status) — String

Report (report)

  • Key (id) — String — Primary key — NOT NULL
  • Key (users_id) — String — Foreign key → Users.Key — NOT NULL
  • Field (other_user_id) — String
  • Field (posts_id) — String
  • Field (comments_id) — String
  • Field (reason) — String
  • Field (report_number) — Long

Users (users)

  • Key (id) — String — Primary key — NOT NULL
  • Field (phone_number) — String
  • Field (email) — String
  • Field (name) — String
  • Field (nickname) — String
  • Field (password) — String
  • Field (introduction) — longtext
  • Field (sex) — String
  • Field (profile_image) — String

UsersBlock (usersBlock)

  • Key (id) — String — Primary key — NOT NULL
  • Key (users_id) — String — Foreign key → Users.Key — NOT NULL
  • Field (other_user_id) — String

UsersFollow (usersFollow)

  • Key (id) — String — Primary key — NOT NULL
  • Key (users_id) — String — Foreign key → Users.Key — NOT NULL
  • Field (other_users_id) — String