cat

Tables (13)

article

  • article_id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • title — varchar(100) — NOT NULL
  • main_text — longtext — NOT NULL
  • image — varchar(100) — NOT NULL
  • letter_number — int(5) — NOT NULL
  • finish_condition — int(5) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

article_count

  • article_count_id — bigint(20) — Primary key — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id — NOT NULL
  • view_count — int(11) — NOT NULL
  • wish_count — int(11) — NOT NULL

article_tag

  • article_tag_id — bigint(20) — Primary key — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id — NOT NULL
  • tag_id — bigint(20) — Foreign key → tag.tag_id — NOT NULL

comment

  • comment_id — bigint(20) — Primary key — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id — NOT NULL
  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • comment — varchar(500) — NOT NULL
  • wish_count — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

content

  • content_id — bigint(20) — Primary key — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id — NOT NULL
  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • parent_content_id — bigint(20)
  • content — longtext — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

follow

  • follower_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • following_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

member

  • member_id — bigint(20) — Primary key — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • login_service — varchar(20) — NOT NULL
  • age — TINYINT
  • gender — TINYINT
  • icon — varchar(255)
  • role — varchar(10) — NOT NULL
  • enabled — bit(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

member_concern

  • member_concern_id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • concern — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

member_token (member_refresh)

  • member_token_id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • access_token — varchar(255) — NOT NULL
  • expiresAt — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

member_wish_article

  • member_wish_article_id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

report

  • report_id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — NOT NULL
  • article_id — bigint(20) — NOT NULL
  • content_id — bigint(20) — NOT NULL
  • text — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

taboo

  • taboo_id — bigint(20) — Primary key — NOT NULL
  • text — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

tag

  • tag_id — bigint(20) — Primary key — NOT NULL
  • text — varchar(255) — NOT NULL
  • tagged_count — int(11) — NOT NULL
  • created_at — datetime — NOT NULL