ERD
Tables (7)
Blog
- id — BIGINT
- writer_id — BIGINT — Foreign key → User.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- pub_date — DATETIME
Blog_Like
- id — BIGINT
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- blog_id — BIGINT — Foreign key → Blog.id — NOT NULL
- created_at — DATETIME
Blog_tags
- id — BIGINT
- blog_id — BIGINT — Foreign key → Blog.id — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.id — NOT NULL
Comment
- id — BIGINT
- blog_id — BIGINT — Foreign key → Blog.id — NOT NULL
- writer_id — BIGINT — Foreign key → User.id — NOT NULL
- content — TEXT — NOT NULL
- pub_date — DATETIME
Profile
- id — BIGINT
- nickname — VARCHAR(255)
- major — VARCHAR(255)
- profile_image — VARCHAR(255)
Tag
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
User
- id — BIGINT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL