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