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