ptrb-new
Tables (10)
album
- id — varchar(128) — Primary key — NOT NULL
- title — varchar(64) — NOT NULL
- introduction — varchar(128)
- is_private — tinyint — NOT NULL
- created_time — timestamp — NOT NULL
- updated_time — timestamp — NOT NULL
- deleted_time — timestamp
album_member
- user_id — varchar(128) — Foreign key → user.id — NOT NULL
- album_id — varchar(128) — Foreign key → album.id — NOT NULL
- auth_type — tinyint — NOT NULL
- created_time — timestamp — NOT NULL
album_post
- id — varchar(128) — Primary key — NOT NULL
- album_id — varchar(128) — Foreign key → album.id — NOT NULL
- title — varchar(64) — NOT NULL
- content — varchar(512)
- pictured_time — timestamp
- created_time — timestamp — NOT NULL
- updated_time — timestamp — NOT NULL
- deleted_time — timestamp
- user_id — varchar(128) — Foreign key → user.id
album_post_comment
- id — varchar(128) — Primary key — NOT NULL
- post_id — varchar(128) — Foreign key → album_post.id — NOT NULL
- user_id — varchar(12) — Foreign key → user.id — NOT NULL
- comment — varchar(256) — NOT NULL
- created_time — timestamp — NOT NULL
- updated_time — timestamp — NOT NULL
- deleted_time — timestamp
album_post_like
- id — varchar(128) — Primary key — NOT NULL
- user_id — varchar(128) — Foreign key → user.id — NOT NULL
- post_id — varchar(128) — Foreign key → album_post.id — NOT NULL
- created_time — timestamp — NOT NULL
- updated_time — timestamp — NOT NULL
album_request
- id — varchar(128) — Primary key — NOT NULL
- album_id — varchar(128) — Foreign key → album.id — NOT NULL
- send_user_id — varchar(12) — Foreign key → user.id
- receive_user_id — varchar(12) — Foreign key → user.id
- request_type — tinyint — NOT NULL
- created_time — timestamp — NOT NULL
- has_accept — tinyint
auth
- id — varchar(255) — Primary key — NOT NULL
- social_type — int — NOT NULL
- email — varchar(64) — NOT NULL
- created_time — timestamp — NOT NULL
- updated_time — timestamp — NOT NULL
- deleted_time — timestamp
file_info
- id — varchar(255) — Primary key — NOT NULL
- ext — varchar(15) — NOT NULL
- version — int — NOT NULL
- ref_id — varchar(255) — NOT NULL
- category — int — NOT NULL
- created_time — timestamp — NOT NULL
- updated_time — timestamp — NOT NULL
notice
- id — varchar(128) — Primary key — NOT NULL
- title — varchar(64) — NOT NULL
- content — varchar(512)
user
- id — varchar(12) — Primary key — NOT NULL
- auth_id — varchar(255) — Foreign key → auth.id — NOT NULL
- nickname — varchar(6) — NOT NULL