week06_hw-spring-mapping
Tables (3)
AUTHOR (author)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- created_at — DATETIME
- updated_at — DATETIME
COMMENT (comment)
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR
- created_at — DATETIME
- updated_at — DATETIME
- post_id — BIGINT — Foreign key → AUTHOR.id — NOT NULL
- author_id — BIGINT — Foreign key → POST.id — NOT NULL
POST (post)
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR
- content — VARCHAR
- created_at — DATETIME
- updated_at — DATETIME
- author_id — BIGINT — Foreign key → AUTHOR.id — NOT NULL