apppppp
Tables (7)
Untitled (posts)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (content) — VARCHAR(100)
- Field
Untitled (likes)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
- Key (target_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (target_type) — INTEGER
- Field
Untitled (tags)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (name)
Untitled (tag_post_map)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (tag_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
comments
- key (id) — BIGINT — Primary key — NOT NULL
- Key (id2) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- field (content) — VARCHAR(100)
- Field (timestamp) — TIMESTAMP
- Field
follower_map (follwer_map)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
users
- Key (user_id) — BIGINT — Primary key — NOT NULL
- Field (email) — VARCHAR(50)
- Field2 (password) — VARCHAR(50)
- Field3 (name) — VARCHAR(50)