```json { "names": [ { "relation": "fd_fact_a9852ac898ed", "decision": "name", "name": "clean_composite", "confidence": 0.95, "reason_code": "source_table_grain", "rationale": "Fact table with one row per source row, keyed on the combination of part, warehouse, and inventory snapshot. Retains the source table name." }, { "relation": "fd_dim_523f49a5cca3", "decision": "name", "name": "parts", "confidence": 0.96, "reason_code": "key_identifies_entity", "rationale": "One row per part SKU, with part family and label describing each part. The key is a handle for the part entity." }, { "relation": "fd_dim_8f79b264f7fa", "decision": "name", "name": "warehouses", "confidence": 0.97, "reason_code": "key_identifies_entity", "rationale": "One row per warehouse, keyed by warehouse code, with warehouse label and city reference. The key is a handle for the warehouse entity." }, { "relation": "fd_dim_baebff400535", "decision": "name", "name": "cities", "confidence": 0.96, "reason_code": "key_identifies_entity", "rationale": "One row per city, keyed by city ID, with city name and state. The key is a handle for the city entity." }, { "relation": "fd_dim_3f64fd70fe19", "decision": "name", "name": "states", "confidence": 0.97, "reason_code": "key_is_the_entity", "rationale": "One row per state, keyed by state name itself (the catalogued item), with state code as an attribute. The state name is the entity, not a handle." }, { "relation": "fd_dim_1eda3dd2882f", "decision": "name", "name": "state_regions", "confidence": 0.94, "reason_code": "key_is_the_entity", "rationale": "One row per state code, mapping to its region. State code is the catalogued item; the table bridges state to region but is keyed on the state itself." }, { "relation": "fd_dim_bc8d4f9e6b10", "decision": "name", "name": "regions", "confidence": 0.97, "reason_code": "key_is_the_entity", "rationale": "One row per region, keyed by region code (the catalogued item), with region name as description. The region code is the entity, not a handle." } ] } ```