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