참고
테이블 (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