basic-blog
Tables (11)
clipping
- clipping_id — bigint(20) — Primary key — NOT NULL
- content_id — bigint(20) — Foreign key → content.content_id — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- clipped — bit(1) — NOT NULL
- created_date — datetime — NOT NULL
comment
- comment_id — bigint(20) — Primary key — NOT NULL
- content_id — bigint(20) — Foreign key → content.content_id — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- text — text — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — datetime — NOT NULL
comment_like
- comment_like_id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- comment_id — bigint(20) — Foreign key → comment.comment_id — NOT NULL
- created_date — datetime — NOT NULL
- liked — bit(1) — NOT NULL
content
- content_id — bigint(20) — Primary key — NOT NULL
- author_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- title — varchar(255) — NOT NULL
- updated_date — datetime — NOT NULL
- created_date — datetime — NOT NULL
- text — longtext — NOT NULL
- deleted — bit(1) — NOT NULL
content_hashtag
- content_id — bigint(20) — Foreign key → content.content_id — NOT NULL
- hashtag_id — bigint(20) — Foreign key → hashtag.hashtag_id — NOT NULL
content_like
- content_like_id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- content_id — bigint(20) — Foreign key → content.content_id — NOT NULL
- created_date — datetime — NOT NULL
- liked — bit(1) — NOT NULL
follow
- follower — bigint(20) — NOT NULL
- following — bigint(20) — NOT NULL
- followed — bit(1) — NOT NULL
- created_date — datetime — NOT NULL
hashtag
- hashtag_id — bigint(20) — Primary key — NOT NULL
- text — varchar(255) — NOT NULL
reply
- reply_id — bigint(20) — Primary key — NOT NULL
- comment_id — bigint(20) — Foreign key → comment.comment_id — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- text — text — NOT NULL
- created_date — datetime — NOT NULL
- updated_date — datetime — NOT NULL
reply_like
- reply_like_id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- reply_id — bigint(20) — Foreign key → reply.reply_id — NOT NULL
- created_date — datetime — NOT NULL
- liked — bit(1) — NOT NULL
user
- user_id — bigint(20) — Primary key — NOT NULL
- nickname — varchar(20) — NOT NULL
- picture — varchar(255) — NOT NULL
- role — bit(1) — NOT NULL
- created_date — datetime — NOT NULL
- withdraw — bit(1) — NOT NULL
- withdraw_date — datetime
- password — varchar(255) — NOT NULL
- username — varchar(15) — NOT NULL
- mobile_number — varchar(11) — NOT NULL
- gender — bit(1) — NOT NULL
- birth — datetime — NOT NULL
- email — varchar(100)