Karrot

Tables (16)

Badge

  • idx — int — Primary key — NOT NULL
  • name — varchar(15)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10)

BadgeCollection

  • idx — bigint — Primary key — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • badgeIdx — int — Foreign key → Badge.idx — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10)

LocalAnswer

  • idx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.idx — NOT NULL
  • idx (postIdx) — int — Foreign key → LocalPost.idx — NOT NULL
  • type — varchar(10) — NOT NULL — 'REPLY' 'COMMENT'
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — 'CANCELED'

LocalCategory

  • idx — bigint — Primary key — NOT NULL
  • name — varchar(10)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED'

LocalFavorite

  • idx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.idx — NOT NULL
  • idx (postIdx) — int — Foreign key → LocalPost.idx — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — 'CANCELED'

LocalPost

  • idx (postIdx) — bigint — Primary key — NOT NULL
  • userrIdx (userIdx) — bigint — Foreign key → User.idx — NOT NULL
  • regionIdx — bigint — Foreign key → Region.idx — NOT NULL
  • content — text — NOT NULL
  • categoryIdx — bigint — Foreign key → LocalCategory.idx — NOT NULL
  • imgURL — text
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED' 'HIDDEN'

LocalReaction

  • idx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.idx — NOT NULL
  • idx (postIdx) — int — Foreign key → LocalPost.idx — NOT NULL
  • type — varchar(10) — NOT NULL — 'INTEREST' 'LIKE'
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — 'CANCELED'

Region

  • idx — bigint — Primary key — NOT NULL
  • name — varchar(10)
  • locationInfo — text — 위치 정보 (경도 위동 등)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED'

RegionSettings

  • idx — bigint — Primary key — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • region1 — bigint — Foreign key → Region.idx — NOT NULL
  • region1verify — int — 위치 정보 (경도 위동 등)
  • region2 — bigint — Foreign key → Region.idx — NOT NULL
  • region2verify — int — NOT NULL
  • select — int — NOT NULL — 1 또는 2 지역 설정
  • range — int — NOT NULL — 1 2 3 4 단계
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED'

Review

  • idx — bigint — Primary key — NOT NULL
  • idx (postIdx) — bigint — Foreign key → SellPost.idx — NOT NULL
  • overall — varchar(5) — 'BAD' 'GOOD' 'GREAT'
  • content — text
  • imgURL — text
  • createdAt — datetime
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — 'DELETED' 'HIDDEN'

ReviewKeyword

  • idx — bigint — Primary key — NOT NULL
  • idx (postIdx) — bigint — Foreign key → SellPost.idx — NOT NULL
  • isCome — int — NOT NULL — 1일경우 근처까지 와서 거래
  • isNice — int — NOT NULL — 1일경우 친절하고 매너가좋아요
  • onTime — int — NOT NULL — 1일 경우 시간 약속을 잘 지켜요
  • isFast — int — NOT NULL — 1일경우 응답이 빨라요
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL

SellCateInterest

  • idx — bigint — Primary key — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • cateIdx — bigint — Foreign key → SellCategory.idx — NOT NULL
  • isCheck — varchar(1) — NOT NULL — 'N'
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED'

SellCategory

  • idx — bigint — Primary key — NOT NULL
  • name — varchar(10)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED'

SellFavorite (Portfolio)

  • idx — int — Primary key — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • postIdx — bigint — Foreign key → SellPost.idx — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — 'CANCELED'

SellPost

  • idx — bigint — Primary key — NOT NULL
  • sellerIdx — bigint — Foreign key → User.idx — NOT NULL
  • buyerIdx — bigint — Foreign key → User.idx
  • regionIdx — bigint — NOT NULL
  • type — varchar(10) — NOT NULL — 'BOOST' 'RESERVED' 'SOLD'
  • title — varchar(30) — NOT NULL
  • content — text — NOT NULL
  • categoryIdx — bigint — Foreign key → SellCategory.idx — NOT NULL
  • isFree — varchar(1) — 'Y'
  • price — int
  • wantNego — varchar(10) — NOT NULL — 'Y'
  • locationX — float
  • locationY — float
  • imgURL — text
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — 'DELETED' 'HIDDEN'

User

  • idx — bigint — Primary key — NOT NULL
  • email — text — NOT NULL
  • phoneNum — bigint — NOT NULL
  • nickName — varchar(20) — NOT NULL
  • manner — float — NOT NULL
  • profileImgUrl — text
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(1) — NOT NULL — 'S' 사용불가 (정지 등) 'N' 휴면 'D' 탈퇴