test

Tables (10)

AgentQuery

  • id — VARCHAR(30) — Primary key — NOT NULL
  • userId — VARCHAR(30) — Foreign key → User.id
  • query — TEXT — NOT NULL
  • criteria — JSON — NOT NULL — AI가 해석한 검색 조건. sumokFeasibility/규제 제외 조건 포함 가능
  • resultCount — INT — NOT NULL
  • summary — TEXT — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • createdAt — DATETIME — NOT NULL

Bookmark

  • id — VARCHAR(30) — Primary key — NOT NULL
  • userId — VARCHAR(30) — Foreign key → User.id — NOT NULL
  • parcelId — VARCHAR(30) — NOT NULL
  • parcelName — VARCHAR(255) — NOT NULL
  • district — VARCHAR(100) — NOT NULL
  • topRecommendation — VARCHAR(20) — NOT NULL — TREE/GARDEN/SOLAR/NONE
  • topScore — DOUBLE — NOT NULL
  • sumokScore — DOUBLE
  • sumokFeasibilityStatus — VARCHAR(20)
  • createdAt — DATETIME — NOT NULL

GeeLstSnapshot

  • id — VARCHAR(30) — Primary key — NOT NULL
  • parcelId — VARCHAR(30) — Foreign key → Parcel.id — NOT NULL
  • dataset — VARCHAR(20) — NOT NULL — modis 또는 landsat
  • radiusM — INT — NOT NULL — 분석 반경(m)
  • innerRadiusM — INT — 열섬 분석 내부 반경(m). LST 조회 시 NULL
  • periodStart — DATE — NOT NULL — 분석 시작일
  • periodEnd — DATE — NOT NULL — 분석 종료일
  • meanLstC — DOUBLE — 평균 지표면 온도(℃)
  • maxLstC — DOUBLE
  • minLstC — DOUBLE
  • heatIslandIntensityC — DOUBLE — 열섬 강도(℃)
  • sampleCount — INT — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • dataAvailable — BOOLEAN — NOT NULL — GEE 데이터 확보 여부
  • rawData — JSON — GEE 분석 원본/메타데이터
  • createdAt — DATETIME — NOT NULL

KosisStatSnapshot

  • id — VARCHAR(30) — Primary key — NOT NULL
  • parcelId — VARCHAR(30) — Foreign key → Parcel.id — NOT NULL
  • district — VARCHAR(100) — NOT NULL — 서울 자치구
  • year — INT — NOT NULL — 통계 연도
  • population — BIGINT — 총인구
  • households — BIGINT — 총가구
  • source — VARCHAR(50) — NOT NULL
  • dataAvailable — BOOLEAN — NOT NULL — KOSIS 응답 성공 여부
  • rawData — JSON — KOSIS API 원본 응답
  • createdAt — DATETIME — NOT NULL

Parcel

  • id — VARCHAR(30) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • district — VARCHAR(100) — NOT NULL
  • neighborhood — VARCHAR(100) — NOT NULL
  • lat — DOUBLE — NOT NULL
  • lng — DOUBLE — NOT NULL
  • areaSqm — DOUBLE — NOT NULL
  • parcelType — VARCHAR(50) — NOT NULL
  • ownership — VARCHAR(50) — NOT NULL
  • soilType — VARCHAR(50) — NOT NULL
  • elevationM — DOUBLE — NOT NULL
  • slopeDegree — DOUBLE — NOT NULL
  • solarIrradiance — DOUBLE — NOT NULL
  • monthlyIrradiance — JSON — NOT NULL — 월별 일사량 배열
  • sunlightHours — DOUBLE — NOT NULL
  • heatIsland — DOUBLE — NOT NULL
  • surfaceTempSummer — DOUBLE — NOT NULL
  • airQuality — DOUBLE — NOT NULL
  • nearbyHouseholds — INT — NOT NULL
  • pedestrianFlow — INT — NOT NULL
  • nearbySchools — INT — NOT NULL
  • nearbyHospitals — INT — NOT NULL
  • nearbyParks — INT — NOT NULL
  • nearbySubwayStations — INT — NOT NULL
  • roadAdjacent — BOOLEAN — NOT NULL
  • waterAccess — BOOLEAN — NOT NULL
  • electricityAccess — BOOLEAN — NOT NULL
  • regulations — JSON — 규제 정보 배열 예: {"code":"GREEN_BELT","severity":"restricted"}
  • regulationsUpdatedAt — DATETIME
  • sumokFeasibility — JSON — 수목 식재 가능성 요약 {status, score, reason}
  • sumokFeasibilityUpdatedAt — DATETIME
  • kosisPopulationSnapshot — JSON — KOSIS 인구·가구 통계 스냅샷 {district, year, population, households, source, dataAvailable, createdAt}
  • geeLstSnapshot — JSON — GEE LST/열섬 분석 스냅샷 {dataset, radiusM, period, meanLstC, heatIslandIntensityC, sampleCount, dataAvailable, createdAt}
  • estimatedAcquisitionCostWon — BIGINT — NOT NULL
  • dataSource — VARCHAR(100) — NOT NULL
  • confidence — DOUBLE — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

ParcelRegulation

  • id — VARCHAR(30) — Primary key — NOT NULL
  • parcelId — VARCHAR(30) — Foreign key → Parcel.id — NOT NULL
  • regulationType — VARCHAR(50) — NOT NULL — GREEN_BELT, URBAN_NATURE_PARK, NATURAL_CONSERVATION, PROTECTION_DISTRICT 등
  • regulationName — VARCHAR(100)
  • severity — VARCHAR(20) — NOT NULL — info, warning, restricted, prohibited
  • affectedUses — JSON — 예: "sumok", "garden", "solar" 또는 "all"
  • penaltyType — VARCHAR(20) — NOT NULL — none, subtract, multiplier, zero
  • penaltyValue — DOUBLE — subtract 점수 차감값 또는 multiplier 배율
  • legalBasis — TEXT
  • description — TEXT
  • source — VARCHAR(50) — VWorld 등
  • sourceLayer — VARCHAR(100) — 개발제한구역, 도시자연공원구역 등
  • typename — VARCHAR(50) — lt_c_ud801 등
  • rawData — JSON — VWorld 원본 속성
  • effectiveDate — DATE
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

ParcelScore

  • id — VARCHAR(30) — Primary key — NOT NULL
  • parcelId — VARCHAR(30) — Foreign key → Parcel.id — NOT NULL
  • sumokScore — DOUBLE — NOT NULL — 수목 식재 적합도 점수 (= treeScore)
  • gardenScore — DOUBLE — NOT NULL
  • solarScore — DOUBLE — NOT NULL
  • topRecommendation — VARCHAR(20) — NOT NULL — TREE(SUMOK), GARDEN, SOLAR, MIXED, RESTRICTED
  • uncertainty — DOUBLE — NOT NULL
  • scoreBreakdown — JSON — NOT NULL — 규제 적용 전/후 점수 및 페널티 내역
  • sumokFeasibilitySnapshot — JSON — {status, score, reason, blockingRegulations, warningRegulations, requiredChecks, confidence}
  • isLatest — BOOLEAN — NOT NULL — 최신 점수 여부
  • algorithmVersion — VARCHAR(50) — 점수 계산 알고리즘 버전
  • regulationRulesetVersion — VARCHAR(50) — 규제 페널티 룰셋 버전
  • regulationsSnapshot — JSON — 계산 당시 규제 정보 스냅샷
  • inputSnapshot — JSON — 계산에 사용된 입력 데이터 스냅샷
  • latestParcelId — VARCHAR(30)
  • computedAt — DATETIME — NOT NULL

Scenario

  • id — VARCHAR(30) — Primary key — NOT NULL
  • parcelId — VARCHAR(30) — Foreign key → Parcel.id — NOT NULL
  • scenarioType — VARCHAR(50) — NOT NULL — PLANT_TREES / CREATE_GARDEN / INSTALL_SOLAR
  • quantity — INT — NOT NULL
  • effects — JSON — NOT NULL — 시나리오 효과 JSON
  • aiExplanation — TEXT
  • createdAt — DATETIME — NOT NULL

Share

  • id — VARCHAR(30) — Primary key — NOT NULL
  • shareId — VARCHAR(50) — NOT NULL — 공개 토큰
  • parcelId — VARCHAR(30) — NOT NULL — 시드 ID 또는 VW-{pnu}
  • createdAt — DATETIME — NOT NULL

User

  • id — VARCHAR(30) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • passwordHash — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL