Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | √ | null |
|
|
||
| IDType | varchar | 1 | √ | null |
|
|
||
| NameInternal | varchar | 100 | √ | null |
|
|
||
| NameExternal | varchar | 100 | √ | null |
|
|
||
| LegalFullName | varchar | 150 | √ | null |
|
|
||
| Surname | varchar | 30 | √ | null |
|
|
||
| Title | varchar | 30 | √ | null |
|
|
||
| Initials | varchar | 15 | √ | null |
|
|
||
| Suffix | varchar | 20 | √ | null |
|
|
||
| Preferred | varchar | 20 | √ | null |
|
|
||
| PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Given1 | varchar | 20 | √ | null |
|
|
||
| Given2 | varchar | 50 | √ | null |
|
|
||
| DeceasedDate | datetime | 16,3 | √ | null |
|
|
||
| DeceasedFlag | bit | 1 | √ | null |
|
|
||
| Gender | varchar | 15 | √ | null |
|
|
||
| OccupCode | varchar | 15 | √ | null |
|
|
||
| OccupDesc | varchar | 50 | √ | null |
|
|
||
| OccupCompany | varchar | 50 | √ | null |
|
|
||
| OccupPhone | varchar | 15 | √ | null |
|
|
||
| OccupFax | varchar | 15 | √ | null |
|
|
||
| MailFormat | varchar | 1 | √ | null |
|
|
||
| SalutFormat | varchar | 1 | √ | null |
|
|
||
| varchar | 100 | √ | null |
|
|
|||
| Address1 | varchar | 40 | √ | null |
|
|
||
| Address2 | varchar | 40 | √ | null |
|
|
||
| Address3 | varchar | 40 | √ | null |
|
|
||
| Suburb | varchar | 40 | √ | null |
|
|
||
| State | varchar | 5 | √ | null |
|
|
||
| CountryCode | varchar | 5 | √ | null |
|
|
||
| PostCode | varchar | 5 | √ | null |
|
|
||
| Phone | varchar | 15 | √ | null |
|
|
||
| Fax | varchar | 15 | √ | null |
|
|
||
| ValidAddressFlag | bit | 1 | √ | null |
|
|
||
| SilentPhoneFlag | bit | 1 | √ | null |
|
|
||
| SystemInstallName | varchar | 8000 | √ | null |
|
|
Table contained 0 rows