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