참고

테이블 (35)

BadManner

  • badMannerId — int — 기본 키 — NOT NULL
  • name — varchar

Badge

  • badgeId — int — 기본 키 — NOT NULL
  • name — varchar
  • gold — boolean

Chat

  • chatId — int — 기본 키 — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • chatroomId — int — 외래 키 → Chatroom.chatroomId — NOT NULL
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

ChatImage

  • chatImageId — int — 기본 키 — NOT NULL
  • chatId — int — 외래 키 → Chat.chatId — NOT NULL
  • URL — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Chatroom

  • chatroomId — int — 기본 키 — NOT NULL
  • postId — int — 외래 키 → Post.postId — NOT NULL
  • sellerId — int — 외래 키 → Post.userId — NOT NULL
  • buyerId — int — 외래 키 → User.userId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Comment

  • commentId — int — 기본 키 — NOT NULL
  • villageLifePostId — int — 외래 키 → VillageLifePost.villageLifePostId — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

CommentComment

  • commentCommentId — int — 기본 키 — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • commentId — int — 외래 키 → Comment.commentId — NOT NULL
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

CommentLike

  • userId — int — 외래 키 → User.userId — NOT NULL
  • commentId — int — 외래 키 → Comment.commentId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

InterestPost

  • userId — int — 외래 키 → User.userId — NOT NULL
  • postId — int — 외래 키 → Post.postId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

InterestPostCategory

  • userId — int — 외래 키 → User.userId — NOT NULL
  • postCategoryId — int — 외래 키 → PostCategory.postCategoryId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Keyword

  • keywordId — int — 기본 키 — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • name — varchar
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Manner

  • mannerId — int — 기본 키 — NOT NULL
  • name — varchar

Notice

  • noticeId — int — 기본 키 — NOT NULL
  • title — varchar
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Offer

  • userId — int — 외래 키 → User.userId — NOT NULL
  • postId — int — 외래 키 → Post.postId — NOT NULL
  • price — int
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Post

  • postId — int — 기본 키 — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • postCategoryId — int — 외래 키 → PostCategory.postCategoryId — NOT NULL
  • village1Id — int — 외래 키 → Village1.village1Id — NOT NULL
  • title — varchar
  • content — text
  • price — int
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar
  • pullUpAt — timestamp
  • pullUpCount — int

PostCategory

  • postCategoryId — int — 기본 키 — NOT NULL
  • name — varchar

PostCompleted

  • postId — int — 외래 키 → Post.postId — NOT NULL
  • sellerId — int — 외래 키 → Post.userId — NOT NULL
  • buyerId — int — 외래 키 → User.userId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

PostImage

  • postImageId — int — 기본 키 — NOT NULL
  • postId — int — 외래 키 → Post.postId — NOT NULL
  • representative — boolean
  • URL — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Report

  • postId — int — 외래 키 → Post.postId — NOT NULL
  • userId — int — 외래 키 → Post.userId — NOT NULL
  • reportCategoryId — int — 외래 키 → ReportCategory.reportCategoryId — NOT NULL
  • reporterId — int — 외래 키 → User.userId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

ReportCategory

  • reportCategoryId — int — 기본 키 — NOT NULL
  • name — varchar

Review

  • postId — int — 외래 키 → PostCompleted.postId — NOT NULL
  • sellerId — int — 외래 키 → PostCompleted.sellerId — NOT NULL
  • buyerId — int — 외래 키 → PostCompleted.buyerId — NOT NULL
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

User

  • userId — int — 기본 키 — NOT NULL
  • nickname — varchar
  • phone — varchar
  • email — varchar
  • URL — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

UserBadManner

  • userId — int — 외래 키 → User.userId — NOT NULL
  • badMannerId — int — 외래 키 → BadManner.badMannerId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

UserBadge

  • userId — int — 외래 키 → User.userId — NOT NULL
  • badgeId — int — 외래 키 → Badge.badgeId — NOT NULL
  • representative — boolean
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

UserManner

  • userId — int — 외래 키 → User.userId — NOT NULL
  • mannerId — int — 외래 키 → Manner.mannerId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

UserVillage

  • userId — int — 외래 키 → User.userId — NOT NULL
  • village1Id — int — 외래 키 → Village1.village1Id — NOT NULL
  • villageRange — int
  • nearbyVillageId — int
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

Village1

  • village1Id — int — 기본 키 — NOT NULL
  • village2Id — int — 외래 키 → Village2.village2Id — NOT NULL
  • name — varchar

Village2

  • village2Id — int — 기본 키 — NOT NULL
  • village3Id — int — 외래 키 → Village3.village3Id — NOT NULL
  • name — varchar

Village3

  • village3Id — int — 기본 키 — NOT NULL
  • name — varchar

VillageLifePost

  • villageLifePostId — int — 기본 키 — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • villageLifePostCategoryId — int — 외래 키 → VillageLifePostCategory.villageLifePostCategoryId — NOT NULL
  • village1Id — int — 외래 키 → Village1.village1Id — NOT NULL
  • title — varchar
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

VillageLifePostCategory

  • villageLifePostCategoryId — int — 기본 키 — NOT NULL
  • name — varchar

VillageLifePostImage

  • villageLifePostImageId — int — 기본 키 — NOT NULL
  • villageLifePostId — int — 외래 키 → VillageLifePost.villageLifePostId — NOT NULL
  • representative — boolean
  • URL — text
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

VillageLifePostLike

  • villageLifePostId — int — 외래 키 → VillageLifePost.villageLifePostId — NOT NULL
  • userId — int — 외래 키 → User.userId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

VillageLifePostReport

  • villageLifePostId — int — 외래 키 → VillageLifePost.villageLifePostId — NOT NULL
  • userId — int — 외래 키 → VillageLifePost.userId — NOT NULL
  • villageLifePostReportCategoryId — int — 외래 키 → VillageLifePostReportCategory.villageLifePostReportCategoryId — NOT NULL
  • reporterId — int — 외래 키 → User.userId — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar

VillageLifePostReportCategory

  • villageLifePostReportCategoryId — int — 기본 키 — NOT NULL
  • name — varchar