Karrot_sql

Tables (16)

Badge

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

BadgeCollection

  • idx — bigint — 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 — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • postIdx — bigint — Foreign key → LocalPost.postIdx — NOT NULL
  • type — varchar(10) — NOT NULL — REPLY COMMENT
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — CANCELED

LocalCategory

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

LocalFavorite

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

LocalPost

  • postIdx — bigint — NOT NULL
  • 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 — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • postIdx — bigint — Foreign key → LocalPost.postIdx — NOT NULL
  • type — varchar(10) — NOT NULL — INTEREST LIKE
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — CANCELED

Portfolio

  • idx — int — 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

Region

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

RegionSettings

  • idx — bigint — NOT NULL
  • userIdx — bigint — Foreign key → User.idx — NOT NULL
  • region1 — bigint — Foreign key → Region.idx — NOT NULL
  • region1verify — int — NOT NULL — 인증횟수
  • region2 — bigint — Foreign key → Region.idx
  • region2verify — int — 인증횟수
  • selected — int — NOT NULL — 1 또는 2 지역 설정
  • regionRange — int — NOT NULL — 동네 범위 1 2 3 4
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — DELETED

Review

  • idx — bigint — NOT NULL
  • 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

ReviewKeyword

  • idx — bigint — NOT NULL
  • 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 — 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 — NOT NULL
  • name — varchar(10)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • status — varchar(10) — NOT NULL — DELETED

SellPost

  • idx — bigint — NOT NULL
  • sellerIdx — bigint — 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 — 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 탈퇴