Skills
.Work. You
Rest

houseprice-community

Community

Map HousePrice community and deal relationships

Data & Analytics#community#sql#joins#data-model#real-estate#houseprice#dealallcaselist
Authorchuangkevin
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill clarifies and documents how HousePrice community records relate to transaction and build tables so engineers and analysts can reliably join, tag, and backfill community identifiers across成屋 (existing buildings) and 新建案 (new builds).

Core Features & Use Cases

  • Canonical mapping between Community, NewBuildGroup, CmpWebCaseNewBuild, NewBuildDealCaseList, DealAllCaseList, and HouseFun.BuBuilding with clear join keys and precedence rules.
  • Query patterns & examples for retrieving GroupId, CommunityId, and performing end-to-end joins from DealAllCaseList to WebCase via bridge tables.
  • Tagging & backfill procedures showing how to populate TagBuildingHeadID, TagBuildingHeadGroupId, TagBuildingHeadName and the GetPriceWithBuildOrNewBuild unified logic.
  • Use Case: Data engineering jobs reconciling real-estate transaction records to community master records for reporting, analytics, and UI linking.

Quick Start

Ask the skill to "Show SQL to resolve a DealAllCaseList row to its Community GroupId and Tag fields using BuildingID or CaseNo+DealKind".

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: houseprice-community
Download link: https://github.com/chuangkevin/project-bridge/archive/main.zip#houseprice-community

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.