# 表依赖关系与计算侧明细（严谨架构版）

> 依据：`src/` 目录下核心表的最新实现逻辑
> 规则：严格区分 Level 1 (空间基础), Level 2 (指标原语), Level 3 (业务聚合)

## 一、 拓扑依赖图 (Total Topology)

```mermaid
graph TD
    %% 样式定义
    classDef source fill:#f96,stroke:#333,stroke-width:2px;
    classDef level1 fill:#dfd,stroke:#333,stroke-width:2px;
    classDef level2 fill:#dff,stroke:#333,stroke-width:2px;
    classDef level3 fill:#fdf,stroke:#333,stroke-width:2px;

    %% 数据源层
    ODS_MR[ODS MR 4G/5G]:::source
    ODS_OTT[ODS OTT 4G/5G]:::source
    ODS_OTT_GRID[ODS OTT GRID]:::source
    EXT_AOI[外部楼宇/场景 AOI]:::source

    %% Level 1: 空间底座与桥接表
    ODS_OTT_GRID --> td_grid:::level1
    td_grid --> td_building_grid_m:::level1
    td_grid --> td_scene_grid_m:::level1
    EXT_AOI --> td_building:::level1
    EXT_AOI --> td_scene:::level1
    
    %% 楼宇小区关系
    td_building_grid_m --> td_building_cell_m:::level1
    ODS_MR --> td_building_cell_m

    %% Level 2: 核心指标原语层
    ODS_MR --> tm_grid_coverage_m:::level2
    ODS_OTT --> tm_grid_coverage_m
    
    %% Level 3: 业务聚合分发层
    tm_grid_coverage_m --> tm_region_coverage_m:::level3
    
    tm_grid_coverage_m --> tm_building_coverage_m:::level3
    td_building_grid_m --> tm_building_coverage_m
    td_building_cell_m --> tm_building_coverage_m
    
    tm_grid_coverage_m --> tm_scene_coverage_m:::level3
    td_scene_grid_m --> tm_scene_coverage_m
    
    tm_grid_coverage_m --> tm_scene_grid_coverage_m:::level3
    td_scene_grid_m --> tm_scene_grid_coverage_m

    tm_grid_coverage_m --> tm_cluster_area_m:::level3
```

## 二、 物理依赖与计算侧明细

| 层级 | 表名 | 依赖项 (Upstream) | 计算侧 | 核心逻辑备注 |
| :--- | :--- | :--- | :--- | :--- |
| **L1** | **td_grid** | ODS_OTT_GRID | HiveSQL | 定义全局 20x20 栅格坐标系 |
| **L1** | **td_building_grid_m** | td_building + td_grid | PG PostGIS | 楼宇-栅格点面关联桥接 |
| **L1** | **td_scene_grid_m** | td_scene + td_grid | PG PostGIS | **新增**：场景-栅格点面关联桥接 |
| **L1** | **td_building_cell_m** | td_building_grid_m + ODS_MR | HiveSQL | 楼宇-小区映射 |
| **L2** | **tm_grid_coverage_m** | ODS MR + ODS OTT | HiveSQL | **原语层**：产出 is_covered 标记 |
| **L3** | **tm_region_coverage_m** | tm_grid_coverage_m | HiveSQL | 行政区级联汇总 (Group Sets) |
| **L3** | **tm_building_coverage_m** | tm_grid_coverage_m + 桥接表 | HiveSQL | 楼宇指标归集 |
| **L3** | **tm_scene_coverage_m** | tm_grid_coverage_m + 桥接表 | HiveSQL | 场景指标归集 |
| **L3** | **tm_scene_grid_coverage_m** | tm_grid_coverage_m + 桥接表 | HiveSQL | 场景栅格明细下钻 |
| **L3** | **tm_cluster_area_m** | tm_grid_coverage_m | Hive/PG | 覆盖黑洞聚类分析 |

## 三、 执行优先级 (Execution Pipeline)

1.  **Priority 0**: `td_grid`, `td_building`, `td_scene` (环境准备)。
2.  **Priority 1**: `td_building_grid_m`, `td_scene_grid_m` (**关键桥接节点**)。
3.  **Priority 2**: `tm_grid_coverage_m` (核心底表) 与 `td_building_cell_m`。
4.  **Priority 3**: 各业务聚合报表 (Region/Building/Scene)。