graph LR
subgraph USER["User/Provider Fields"]
id[id]
name[name]
email[email]
city[city]
state[state]
neighborhood[neighborhood]
phone_number[phone_number]
is_allowed[is_allowed]
accept_tcle[accept_tcle]
created_at[created_at]
updated_at[updated_at]
end
subgraph OMOP["OMOP CDM Tables"]
subgraph PROVIDER["PROVIDER"]
provider_id[provider_id]
provider_name[provider_name]
provider_source_value[provider_source_value]
end
subgraph LOCATION["LOCATION"]
loc_city[city]
loc_state[state]
address_1[address_1]
end
subgraph UNDEFINED["UNMAPPED / UNCLEAR"]
question1[? application control]
question2[? consent tracking]
question3[? audit metadata]
question4[? audit metadata]
end
end
id --> provider_id
name --> provider_name
email --> provider_source_value
phone_number --> provider_source_value
city --> loc_city
state --> loc_state
neighborhood --> address_1
is_allowed --> question1
accept_tcle --> question2
created_at --> question3
updated_at --> question4
style USER fill:#e1f5ff
style OMOP fill:#fff4e1
style PROVIDER fill:#d4edda
style LOCATION fill:#d4edda
style UNDEFINED fill:#ffeaa7