SPRING_CRUD
Tables (4)
Comment
- commentId — bigint — Primary key — NOT NULL
- postId — Foreign key → Post.postId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- userId (content) — text — NOT NULL
Post
- postId — Primary key — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- title — varchar(100) — NOT NULL
- content — TEXT — NOT NULL
- status — varchar(100) — NOT NULL
- created_at — date — NOT NULL
Untitled (like)
- Key (likeId) — bigint — Primary key — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- postId — Foreign key → Post.postId — NOT NULL
User
- userId — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL