Citistagram
Tables (7)
Untitled (contents)
- Key (post_id) — BICINT — Primary key — NOT NULL
- Key (user_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Field2 (image)
- Field3 (desc) — VARCHAR(100)
- Field (timestamp) — TIMESTAMP
Untitled (users)
- Key (user_id) — BICINT — Primary key — NOT NULL
- Field (email) — VARCHAR(50)
- Field2 (password) — VARCHAR(50)
- Field3 (name) — VARCHAR(50)
Untitled (likes)
- Key (like_id) — BICINT — Primary key — NOT NULL
- Key (user_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (post_type) — INTERGER
Untitled (follower_map)
- Key (follow_id) — BICINT — Primary key — NOT NULL
- Key (follower_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Field (following_id)
Untitled (tags)
- Key (tag_id) — BICINT — Primary key — NOT NULL
- Field (name) — VARCHAR(20)
Untitled (tag_post_map)
- Key (tag_post_id) — BICINT — Primary key — NOT NULL
- Key (tag_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
comments
- Key (comment_id) — BICINT — Primary key — NOT NULL
- Key (user_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
- Field (content) — VARCHAT(100)
- Field2 (timestamp) — TIMESTAMP