community
Tables (3)
Comment (comment)
- commentId (comment_id) — bigint — Primary key — NOT NULL
- postId (post_id) — bigint — Foreign key → Post.postId — NOT NULL
- userId (user_id) — bigint — Foreign key → User.userId — NOT NULL
- comment — varchar(255)
- password — varchar(255)
- createdAt (created_at) — LocalDateTime
- modifiedAt (modified_at) — LocalDateTime
Post (post)
- postId (post_id) — bigint — Primary key — NOT NULL
- userId (user_id) — bigint — Foreign key → User.userId — NOT NULL
- title — varchar(255)
- content — varchar(255)
- createdAt (created_at) — LocalDateTime
User (user)
- userId (user_id) — bigint — Primary key — NOT NULL
- username — varchar(255)
- password — varchar(255)
- nickname — varchar(255)