devlife

Tables (17)

Follow

  • id — bigint(20) — Primary key — NOT NULL
  • following_id — bigint(20) — Foreign key → Following.id — NOT NULL
  • follower_id — bigint(20) — Foreign key → Follower.id — NOT NULL

Follower

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

Following

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

blog_comment

  • id — bigint(20) — Primary key — NOT NULL
  • blog_post_id — bigint(20) — Foreign key → blog_post.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • comment — varchar — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL

blog_like

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • id (id2) — bigint(20) — Foreign key → blog_post.id — NOT NULL

blog_post

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • title (Field) — varchar — NOT NULL
  • content — varchar — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL
  • updated_date (updated_by) — timestamp — NOT NULL

hashtag

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL

image

  • id — bigint(20) — Primary key — NOT NULL
  • blog_post_id — bigint(20) — Foreign key → blog_post.id
  • sns_post_id — bigint(20) — Foreign key → sns_post.id
  • src — varchar(255) — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL
  • updated_date (updated_by) — timestamp — NOT NULL

o_auth

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • version — bigint(20) — NOT NULL
  • access_token — varchar(255) — NOT NULL
  • provider — varchar(255) — NOT NULL

role

  • id — bigint(20) — Primary key — NOT NULL
  • authority — varchar(255) — NOT NULL

sns_comment

  • id — bigint(20) — Primary key — NOT NULL
  • sns_post_id — bigint(20) — Foreign key → sns_post.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • comment — varchar(255) — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL

sns_like

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • sns_post_id — bigint(20) — Foreign key → sns_post.id — NOT NULL

sns_post

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • content — varchar — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL
  • updated_date (updated_by) — timestamp — NOT NULL

sns_post_hashtag

  • id — bigint(20) — Primary key — NOT NULL
  • sns_post_id — bigint(20) — Foreign key → sns_post.id — NOT NULL
  • hashtag_id — bigint(20) — Foreign key → hashtag.id — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • username — varchar(20) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL
  • updated_date (updated_by) — timestamp — NOT NULL

user_role

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • role_id — bigint(20) — Foreign key → role.id — NOT NULL

video

  • id — bigint(20) — Primary key — NOT NULL
  • blog_post_id — bigint(20) — Foreign key → blog_post.id
  • sns_post_id — bigint(20) — Foreign key → sns_post.id
  • src — varchar(255) — NOT NULL
  • created_date (created_by) — timestamp — NOT NULL
  • updated_date (updated_by) — timestamp — NOT NULL