Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| LinkedID | int | 4 | null |
|
|
|||
| ContactType | varchar | 3 | null |
|
|
|||
| Description | varchar | 30 | √ | null |
|
|
||
| ContactName | varchar | 100 | √ | null |
|
|
||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| Phone | varchar | 15 | √ | null |
|
|
||
| PhoneAlt | varchar | 15 | √ | null |
|
|
||
| Fax | varchar | 15 | √ | null |
|
|
||
| ContactID | int | 4 | √ | null |
|
|
||
| NameInternal | varchar | 100 | √ | null |
|
|
||
| NameExternal | varchar | 100 | √ | null |
|
|
||
| LegalFullName | varchar | 150 | √ | null |
|
|
||
| Given1 | varchar | 20 | √ | null |
|
|
||
| Preferred | varchar | 20 | √ | null |
|
|
||
| PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Surname | varchar | 30 | √ | null |
|
|
||
| ContactFullName | varchar | 107 | √ | null |
|
|
||
| OccupPhone | varchar | 15 | √ | null |
|
|
||
| OccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| OccupFax | varchar | 15 | √ | null |
|
|
||
| MobilePhone | varchar | 15 | √ | null |
|
|
||
| DefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| WebSite | varchar | 100 | √ | null |
|
|
||
| DefaultEmail | varchar | 201 | √ | null |
|
|
||
| ContactRelationship | varchar | 100 | √ | null |
|
|
||
| ContactSpouseID | int | 4 | √ | null |
|
|
||
| SpouseNameInternal | varchar | 100 | √ | null |
|
|
||
| SpouseNameExternal | varchar | 100 | √ | null |
|
|
||
| SpouseLegalFullName | varchar | 150 | √ | null |
|
|
||
| SpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| SpousePreferred | varchar | 20 | √ | null |
|
|
||
| SpousePreferredFormal | varchar | 20 | √ | null |
|
|
||
| SpouseSurname | varchar | 30 | √ | null |
|
|
||
| ContactSpouseFullName | varchar | 107 | √ | null |
|
|
||
| SpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| SpouseOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseOccupFax | varchar | 15 | √ | null |
|
|
||
| SpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| SpouseWebSite | varchar | 100 | √ | null |
|
|
||
| SpouseDefaultEmail | varchar | 201 | √ | null |
|
|
||
| ContactSpouseRelationship | varchar | 100 | √ | null |
|
|
Table contained 0 rows