prac
Tables (7)
comments
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (post__id) — BIGINT — Foreign key → user.Key — NOT NULL
- Key (user__id) — BIGINT — Foreign key → posts.Key — NOT NULL
- Field (content) — ARCHAR(100)
- Field2 (timestamp) — TIMESTAMP
follower_map
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (target_id) — BIGINT — Foreign key → user.Key — NOT NULL
likes
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user__id) — BIGINT — Foreign key → user.Key — NOT NULL
- Key (target_id) — BIGINT — Foreign key → posts.Key — NOT NULL
- Field4 (target_type) — INTEGER
- t (mestamp) — TIMESTAMP
posts
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user__id) — BIGINT — Foreign key → user.Key — NOT NULL
- Field (timestamp) — TIMESTAMP
- Field2 (content) — VARCHAR(100)
- Field
tag_post_map
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (tag__id) — BIGINT — Foreign key → posts.Key — NOT NULL
- Key (user__id) — BIGINT — Foreign key → posts.Key — NOT NULL
- Key (id2) — BIGINT — Foreign key → tags.Key — NOT NULL
tags
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(20)
user (users)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (email) — VARCHAR(50)
- Field2 (password) — VARCHAR(50)
- (name) — VARCHAR(50)