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