NoticeBoard
Tables (4)
ChildComment (CHILD_COMMENT)
- childComment (child_comment_id) — Long — Primary key — NOT NULL
- parent (comment_id) — Long — Foreign key → CommentEntity.id — NOT NULL
- post (post_id) — Long — Foreign key → PostEntity.id — NOT NULL
- user (user_id) — Long — Foreign key → UserEntity.id — NOT NULL
- content — String — NOT NULL
- createdDateTime (create_at) — DATE — NOT NULL
CommentEntity (COMMENT)
- id (comment_id) — Long — Primary key — NOT NULL
- post (post_id) — Long — Foreign key → PostEntity.id — NOT NULL
- user (user_id) — Long — Foreign key → UserEntity.id — NOT NULL
- content — String — NOT NULL
- createdDateTime (create_at) — DATE
PostEntity (POST)
- id (post_id) — Long — Primary key — NOT NULL
- user (user_id) — Long — Foreign key → UserEntity.id — NOT NULL
- title — String — NOT NULL
- content — String — NOT NULL
- createdDateTime (created_at) — Date
UserEntity (USER)
- id (user_id) — Long — Primary key — NOT NULL
- email — String — NOT NULL
- password — String — NOT NULL
- nickname — String — NOT NULL
- role — String — NOT NULL
- createdDateTime (create_at) — Date — NOT NULL
- profieImageUrl (profile_image_url) — String — NOT NULL