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)