Carstagram
Tables (6)
Copy Of Users (posts)
- Key (post_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (content) — VARCHAR(100)
Untitled (postlikes)
- Key (postlike_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
- Key (post_id) — BIGINT — Foreign key → Copy Of Users.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (target_type) — INTEGER
Untitled (commentlikes)
- Key (commentlike_id) — BIGINT — Primary key — NOT NULL
- Key (comment_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (target_type) — INTEGER
Untitled2 (follower_map)
- Key (follower_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
- Field (target_id) — BIGINT
Untitled3 (comments)
- Key (comment_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
- Field (content) — VARCHAR(100)
- Field2 (timestamp) — TIMESTAMP
Users (users)
- Key (user_id) — BIGINT — Primary key — NOT NULL
- Field (email) — VARCHAR(50)
- Field2 (password) — VARCHAR(50)
- Field3 (name) — VARCHAR(50)