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