Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ContactID | INT | 10 | 0 |
|
|
|||||
| ClientID | INT | 10 | null |
|
|
|||||
| LocationID | INT | 10 | null |
|
|
|||||
| ContactName | VARCHAR | 101 | √ | null |
|
|
||||
| ContactAssetCount | BIGINT | 19 | 0 |
|
|
|||||
| ContactEmail | VARCHAR | 500 | null |
|
|
|||||
| ContactPhone | VARCHAR | 30 | null |
|
|
|||||
| ContactCell | VARCHAR | 30 | null |
|
|
|||||
| ContactAddress | VARCHAR | 102 | √ | null |
|
|
||||
| ContactCity | VARCHAR | 30 | null |
|
|
|||||
| ContactState | VARCHAR | 30 | null |
|
|
|||||
| ContactZip | VARCHAR | 10 | null |
|
|
|||||
| ContactFax | VARCHAR | 30 | null |
|
|
|||||
| ContactPager | VARCHAR | 30 | null |
|
|
|||||
| ContactIMMSN | VARCHAR | 40 | null |
|
|
|||||
| ContactIMAIM | VARCHAR | 40 | null |
|
|
|||||
| ContactIMICQ | VARCHAR | 40 | null |
|
|
|||||
| ContactIMNetBios | VARCHAR | 50 | null |
|
|
Relationships
Close relationships within degrees of separation
