instagram prac
Tables (7)
Copy Of Untitled (comments)
- Key (comment_id) — BIGINT — Primary key — NOT NULL
- Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id2) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (content) — VARCHAR(100)
- Field (timestamp) — TIMESTAMP
Untitled (posts)
- Key (post_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field (content) — VARCHAR(100)
Untitled (users)
- Key (user_id) — BIGINT — Primary key — NOT NULL
- Field (email) — VARCHAR(50)
- Field (password) — VARCHAR(50)
- Field (name) — VARCHAR(50)
Untitled (tags)
- Key (tag_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARGHAR(20)
Untitled (tag_post_map)
- Key (tag_post_map_id) — BIGINT — Primary key — NOT NULL
- Key (tag_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (likes)
- Key (like_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Copy Of Untitled.Key — NOT NULL
- Key (user_id2) — BIGINT — Foreign key → Copy Of Untitled.Key — NOT NULL
- Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id3) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (tomestamp) — TIMESTAMP
- Field (target_type) — INTEGER
Untitled (follower_map)
- Key (follower_map_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL