REVThing
Tables (7)
Untitled (article_like)
- Key (id) — bigint(20) — Primary key — NOT NULL
- id (user_id) — uuid — Foreign key → user.id — NOT NULL
- Key (article_id) — bigint(20) — Foreign key → article.Key — NOT NULL
Untitled (follow)
- Key (id) — bigint(20) — Primary key — NOT NULL
- id (user_id) — uuid — Foreign key → user.id — NOT NULL
- id (following_id) — uuid — Foreign key → user.id — NOT NULL
Untitled (auth_token)
- Key (id) — uuid — Primary key — NOT NULL
- id (auth_id) — uuid — Foreign key → user.id — NOT NULL
- Field (refresh_token) — varchar(255) — NOT NULL
article (review)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (create_date) — timestamp — NOT NULL
- Field (update_date) — timestamp — NOT NULL
- Field (max_id) — bigint(20) — NOT NULL
- id (author_id) — uuid — Foreign key → user.id — NOT NULL
- Field (title) — varchar(255) — NOT NULL
- Field (content) — longtext — NOT NULL
- Field (view_count) — bigint(20) — NOT NULL
- Field (like_count) — bigint(20) — NOT NULL
- Field (publish_date) — timestamp — NOT NULL
- Field (is_temp) — bit(1) — NOT NULL
- Field (selected) — bit(1) — NOT NULL
article_sequence
- id (user_id) — uuid — Foreign key → user.id — NOT NULL
- Field (max_article_id) — bigint(20) — NOT NULL
avatar (user_profile)
- id (user_id) — uuid — Foreign key → user.id — NOT NULL
- Field (last_update_date) — timestamp — NOT NULL
- Field (description) — varchar(255)
- Field (avatar) — varchar(255) — NOT NULL
user
- id — uuid — Primary key — NOT NULL
- create_date — timestamp — NOT NULL
- Field (update_date) — timestamp — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(255)
- username — varchar(15)
- Field (provider) — varchat(20)