tt
Tables (8)
Favorite (즐겨찾기)
- Favorite (Key) — Primary key — NOT NULL
- user (uuid) — Foreign key → user.user — NOT NULL
- recommendation (Key2) — Foreign key → recommendation.recommendation — NOT NULL
- data (Key22) — Foreign key → recommendation.data — NOT NULL
- request (Key4) — Foreign key → recommendation.request — NOT NULL
- user (Key23) — Foreign key → recommendation.user — NOT NULL
- 생성일 (created_at) — Field
Photo (사진)
- photo (Key) — Primary key — NOT NULL
- request (Key2) — Foreign key → request.request — NOT NULL
- user (Key22) — Foreign key → request.user — NOT NULL
- 사진 (image)
- 업로드 시간 (uploaded_at) — Field
Tag (태그)
- Tag (Key) — Primary key — NOT NULL
- Field
data (더미데이터)
- data (Key) — Primary key — NOT NULL
- 상가업소번호 (Field2)
- 상권업종소분류코드 (Field3)
- 상권업종소분류명 (Field4)
- 법정동코드 (Field5)
- 법정동명 (Field6)
- 도로명주소ch (Field7)
- 층정보 (Field8) — null
- 경도 (Field9)
- 위도 (Field10)
- 예상보증금 (Field11)
- 예상월세 (Field12)
- 유동인구 (daily_footfall_avg)
- Tag (Key2) — Foreign key → Tag.Tag — NOT NULL
recommendation (추천 결과)
- recommendation (Key) — Primary key — NOT NULL
- data (Key2) — Foreign key → data.data — NOT NULL
- request (Key4) — Foreign key → request.request — NOT NULL
- user (Key23) — Foreign key → request.user — NOT NULL
- 추천 점수 (score)
- 추천 사유 (description)
- 생성일자 (created_at)
recommendationTag (추천태그)
- recommendationTag (Key) — Primary key — NOT NULL
- Tag (Key2) — Foreign key → Tag.Tag — NOT NULL
- recommendation (Key3) — Foreign key → recommendation.recommendation — NOT NULL
- data (Key22) — Foreign key → recommendation.data — NOT NULL
- request (Key4) — Foreign key → recommendation.request — NOT NULL
- user (Key23) — Foreign key → recommendation.user — NOT NULL
- Field
request (요청기록)
- request (Key) — Primary key — NOT NULL
- user (Key2) — Foreign key → user.user — NOT NULL
- 플랜 (plan)
- 좌표 (point) — NULL
- 주소 (address) — NULL
- 요청시각 (created_at)
- 업종명 (Field) — NULL
user (사용자)
- user (uuid) — Primary key — NOT NULL
- 생성시각 (created_at)