kingkong instagram
Tables (5)
Untitled (comments)
- Key (comments_id) — BIGINT — Primary key — NOT NULL
- id (post_id) — BIGINT — Foreign key → posts.id — NOT NULL
- id (user_id) — BIGINT — Foreign key → posts.id — NOT NULL
- id (user_id2) — BIGINT — Foreign key → users.id — NOT NULL
- Field (content) — VARCHAR(100)
- Field (timestamp) — TIMESTAMP
follower_map
- id (follower_id) — BIGINT — Primary key — NOT NULL
- id (target_id) — BIGINT — Foreign key → users.id — NOT NULL
- Field (user_id)
likes
- id (likes_id) — BIGINT — Primary key — NOT NULL
- id (post_id) — BIGINT — Foreign key → posts.id — NOT NULL
- id (user_id) — BIGINT — Foreign key → posts.id — NOT NULL
- id (user_id2) — BIGINT — Foreign key → users.id — NOT NULL
- timestamp — TIMESTAMP
- target_type — INTEGER
posts
- id (post_id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
- timestamp — TIMESTAMP
- content — VARCHAR(100)
users (user)
- id (user_id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(50)
- password — VARCHAR(50)
- name — VARCHAR(50)