Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClearingHouseID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each clearing house |
|
| Name | varchar | 50 | null |
|
|
Clearing house name - Name of the clearing house organization |
||
| Description | varchar | 500 | √ | null |
|
|
Description - Detailed description of the clearing house services |
|
| Address | varchar | 50 | √ | null |
|
|
Street address - Physical address of the clearing house |
|
| State | varchar | 30 | √ | null |
|
|
State - State where the clearing house is located |
|
| City | varchar | 50 | √ | null |
|
|
City - City where the clearing house is located |
|
| Zip | varchar | 10 | √ | null |
|
|
ZIP code - ZIP code for the clearing house address |
|
| Telephone | varchar | 15 | √ | null |
|
|
Phone number - Primary telephone number for the clearing house |
|
| Fax | varchar | 15 | √ | null |
|
|
Fax number - Fax number for the clearing house |
|
| Website | varchar | 100 | √ | null |
|
|
Website URL - Website address for the clearing house |
|
| Modem | varchar | 15 | √ | null |
|
|
Modem number - Modem connection number for electronic transmission |
|
| Notes | varchar | 500 | √ | null |
|
|
Additional notes - Additional notes about the clearing house |
|
| Signupdate | datetime | 16,3 | √ | null |
|
|
Signup date - Date when the clearing house relationship was established |
|
| msrepl_tran_version | uniqueidentifier | 16 | null |
|
|
Replication version - Microsoft replication transaction version identifier |
Relationships
Close relationships within degrees of separation
