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