test
Tables (6)
comments (tag_post_map)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — VARCHAR(100)
- Field (timestamp) — TIMESTAMP
- Field2 (post_id) — BIGINT
follower_map
- (follower_id) — BIGINT — Primary key — NOT NULL
- (target_id) — BIGINT
likes
- Key (likes_id) — BIGINT — Primary key — NOT NULL
- (user_id) — BIGINT — Foreign key → users.user_id — NOT NULL
- Key (comments_id) — BIGINT — Foreign key → tags.Key — NOT NULL
- (user_id2) — BIGINT — Foreign key → tags.user_id — NOT NULL
- Field2 (timestamp) — TIMESTAMP
- Field3 (target_id) — BIGINT
- Field4 (target_type) — INTEGER
posts
- Key (post_id) — BIGINT — Primary key — NOT NULL
- (user_id) — BIGINT — Foreign key → users.user_id — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (content) — VARCHAR(100)
tags (comments)
- Key (comments_id) — BIGINT — Primary key — NOT NULL
- (user_id) — BIGINT — Foreign key → users.user_id — NOT NULL
- Field (name) — VARCHAR
users
- (user_id) — BIGINT — Primary key — NOT NULL
- Field (email) — VARCHAR(50)
- Field (password) — VARCHAR(50)
- Field2 (name) — VARCHAR(50)