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)