Images/MolarCheck

graph LR
    subgraph IMG["Images (Source Table)"]
        image_id["image_id"]
        extension["extension"]
        user_id["user_id"]
        created_at["created_at"]
    end

    subgraph ObsImage["OMOP: Observation (Dental Photo)"]
        oi_observation_id["observation_id 🔑"]
        oi_concept["observation_concept_id 🔑<br/>(CID_DENTAL_PHOTO)"]
        oi_value["value_as_string"]
        oi_provider["provider_id"]
        oi_date["observation_date"]
    end

    %% OBSERVATION mappings
    image_id -->|"row_observation"| oi_observation_id
    extension -->|"row_observation"| oi_value
    user_id -->|"row_observation"| oi_provider
    created_at -->|"row_observation"| oi_date

    style IMG fill:#e1f5ff
    style ObsImage fill:#f5e1ff