Spring Assignment
Tables (3)
COMMENT (comment)
- commentId (Key) — bigint — Primary key — NOT NULL
- userId (Key2) — bigint — Foreign key → USER.userId — NOT NULL
- postId (Key3) — bigint — Foreign key → POST.postId — NOT NULL
- contents (Field) — varchar
- createdAt (Field2) — datetime
- modifiedAt (Field3) — datetime
POST (post)
- postId (Key) — bigint — Primary key — NOT NULL
- userId (Key2) — bigint — Foreign key → USER.userId — NOT NULL
- title (Field) — varchar
- contents (Field3) — varchar
- createdAt (Field4) — datetime
- moditiedAt (Field5) — datetime
USER (user)
- userId (Key) — bigint — Primary key — NOT NULL
- nickname (Field) — varchar — NOT NULL
- password (Field2) — varchar
- createdAt (Field3) — datetime
- modifiedAt (Field4) — datetime