Themis Topic: Location Table: Non U.S. address/locations

[rtmill (Robert Miller)]

@SCYou @Jaehyeong_Cho

I misunderstood, I had thought you wanted to maintain references to regions within the location table itself.

@SCYou

Currently, we’re using fact_relationship table to link location information in person table and GADM system. We’ve already linked air pollution and CDM on the basis of GADM in Korea. And this model can work worldwide.

I’m hoping you can elaborate on this a little more. I understand it as using the FACT_RELATIONSHIP table to store relationships between records in the person table and region identifiers.

• I don’t see any date fields in FACT_RELATIONSHIP. How is the temporal nature of the relationship maintained?
• Is there a relationship record for every record type or do they roll up? (n = # person * # region type VS. n = #person)
• How is GADM referenced within FACT_RELATIONSHIP? Are you storing the GADM identifiers as concepts or putting them directly into the domain_concept_id_2 field or something else?