npi_affiliate
Information about NPI's that are related to another NPI in some way.
Primary Key:Foreign Keys:npi=>npi_provider.npi
npi_affiliate_npi_idx-npi
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | - |
affiliate_npi | bigint | No | Yes | - |
affiliate_type | npi_affiliate_type | Yes | No | - |
match_metadata | jsonb | Yes | No | Information about matches between npi and affiliate_npi record |