insurance_numbers

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	INT	10			0

|

| | | provider_id | INT | 10 | | | 0 |

|

| | | insurance_company_id | INT | 10 | √ | | NULL |

|

| | | provider_number | VARCHAR | 20 | √ | | NULL |

|

| | | rendering_provider_number | VARCHAR | 20 | √ | | NULL |

|

| | | group_number | VARCHAR | 20 | √ | | NULL |

|

| | | provider_number_type | VARCHAR | 4 | √ | | NULL |

|

| | | rendering_provider_number_type | VARCHAR | 4 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id

Relationships

Close relationships within degrees of separation