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