mine
Tables (6)
Comment (댓글)
- 댓글 ID (comment_id) — BIGINT — Primary key — NOT NULL
- 게시글 ID (post_id) — BIGINT — Foreign key → Post.게시글 ID — NOT NULL
- 유저 ID (user_id) — BIGINT — Foreign key → User.유저 ID — NOT NULL
- 내용 (content) — TEXT — NOT NULL
Comment_Like (댓글 좋아요)
- 댓글 좋아요 ID (comment_like_id) — BIGINt — Primary key — NOT NULL
- 유저 ID (user_id) — BIGINT — Foreign key → User.유저 ID — NOT NULL
- 댓글 ID (comment_id) — BIGINT — Foreign key → Comment.댓글 ID — NOT NULL
Post (게시글)
- 게시글 ID (post_id) — BIGINT — Primary key — NOT NULL
- 유저 ID (user_id) — BIGINT — Foreign key → User.유저 ID — NOT NULL
- 내용 (content) — TEXT — NOT NULL
- 지역 ID (region_id) — BIGINT — Foreign key → Region.지역 ID — NOT NULL
Post_Like (게시글 좋아요)
- 게시글 좋아요 ID (post_like_id) — BIGINT — Primary key — NOT NULL
- 유저 ID (user_id) — BIGINT — Foreign key → User.유저 ID — NOT NULL
- 게시글 ID (post_id) — BIGINT — Foreign key → Post.게시글 ID — NOT NULL
Region (지역)
- 지역 ID (region_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — String
User (유저)
- 유저 ID (user_id) — BIGINT — Primary key — NOT NULL