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' 탈퇴