Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProspectID | int | 4 | null |
|
|
|||
| ProspectAppeal | varchar | 10 | null |
|
|
|||
| ProspectAppealDescription | varchar | 100 | √ | null |
|
|
||
| ProspectActiveFlag | bit | 1 | null |
|
|
|||
| ProspectCapacity | money | 21,4 | √ | null |
|
|
||
| ProspectIndication | money | 21,4 | √ | null |
|
|
||
| ProspectInclination | varchar | 5 | √ | null |
|
|
||
| ProspectInclinationDescription | varchar | 30 | √ | null |
|
|
||
| ProspectPrimaryOnlyFlag | bit | 1 | null |
|
|
|||
| ProspectMailNamePrimary | varchar | 100 | √ | null |
|
|
||
| ProspectNameNumber | int | 4 | null |
|
|
|||
| ProspectName | varchar | 105 | √ | null |
|
|
||
| ProspectMailSalutation | varchar | 100 | √ | null |
|
|
||
| ProspectNameInternal | varchar | 100 | √ | null |
|
|
||
| ProspectNameExternal | varchar | 100 | √ | null |
|
|
||
| ProspectLegalFullName | varchar | 150 | √ | null |
|
|
||
| ProspectSurname | varchar | 30 | √ | null |
|
|
||
| ProspectPreferred | varchar | 20 | √ | null |
|
|
||
| ProspectPreferredFormal | varchar | 20 | √ | null |
|
|
||
| ProspectSpousePreferred | varchar | 20 | √ | null |
|
|
||
| ProspectGiven1 | varchar | 20 | √ | null |
|
|
||
| ProspectGiven2 | varchar | 50 | √ | null |
|
|
||
| ProspectInitials | varchar | 15 | √ | null |
|
|
||
| ProspectAddressComma | varchar | 200 | √ | null |
|
|
||
| ProspectAddressFull | varchar | 200 | √ | null |
|
|
||
| ProspectState | varchar | 5 | √ | null |
|
|
||
| ProspectCountryCode | varchar | 5 | √ | null |
|
|
||
| ProspectPostCode | varchar | 5 | √ | null |
|
|
||
| ProspectAddressDPID | varchar | 8 | √ | null |
|
|
||
| ProspectAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| ProspectAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| ProspectAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| ProspectHomePhone | varchar | 15 | √ | null |
|
|
||
| ProspectHomeFax | varchar | 15 | √ | null |
|
|
||
| ProspectOccupPhone | varchar | 15 | √ | null |
|
|
||
| ProspectOccupFax | varchar | 15 | √ | null |
|
|
||
| ProspectOccupEmail | varchar | 100 | √ | null |
|
|
||
| ProspectHomeEmail | varchar | 100 | √ | null |
|
|
||
| ProspectStaff1ID | int | 4 | √ | null |
|
|
||
| ProspectStaff1MailName | varchar | 100 | √ | null |
|
|
||
| ProspectStaff1NameInternal | varchar | 100 | √ | null |
|
|
||
| ProspectStaff1NameExternal | varchar | 100 | √ | null |
|
|
||
| ProspectStaff1LegalFullName | varchar | 150 | √ | null |
|
|
||
| ProspectStaff1Surname | varchar | 30 | √ | null |
|
|
||
| ProspectStaff1Preferred | varchar | 20 | √ | null |
|
|
||
| ProspectStaff1PreferredFormal | varchar | 20 | √ | null |
|
|
||
| ProspectStaff1Title | varchar | 30 | √ | null |
|
|
||
| ProspectStaff2ID | int | 4 | √ | null |
|
|
||
| ProspectStaff2MailName | varchar | 100 | √ | null |
|
|
||
| ProspectStaff2NameInternal | varchar | 100 | √ | null |
|
|
||
| ProspectStaff2NameExternal | varchar | 100 | √ | null |
|
|
||
| ProspectStaff2LegalFullName | varchar | 150 | √ | null |
|
|
||
| ProspectStaff2Surname | varchar | 30 | √ | null |
|
|
||
| ProspectStaff2Preferred | varchar | 20 | √ | null |
|
|
||
| ProspectStaff2PreferredFormal | varchar | 20 | √ | null |
|
|
||
| ProspectStaff2Title | varchar | 30 | √ | null |
|
|
||
| ProspectVolunteer1ID | int | 4 | √ | null |
|
|
||
| ProspectVolunteer1MailName | varchar | 100 | √ | null |
|
|
||
| ProspectVolunteer1NameInternal | varchar | 100 | √ | null |
|
|
||
| ProspectVolunteer1NameExternal | varchar | 100 | √ | null |
|
|
||
| ProspectVolunteer1LegalFullName | varchar | 150 | √ | null |
|
|
||
| ProspectVolunteer1Surname | varchar | 30 | √ | null |
|
|
||
| ProspectVolunteer1Preferred | varchar | 20 | √ | null |
|
|
||
| ProspectVolunteer1PreferredFormal | varchar | 20 | √ | null |
|
|
||
| ProspectVolunteer1Title | varchar | 30 | √ | null |
|
|
||
| ProspectVolunteer2ID | int | 4 | √ | null |
|
|
||
| ProspectVolunteer2MailName | varchar | 100 | √ | null |
|
|
||
| ProspectVolunteer2NameInternal | varchar | 100 | √ | null |
|
|
||
| ProspectVolunteer2NameExternal | varchar | 100 | √ | null |
|
|
||
| ProspectVolunteer2LegalFullName | varchar | 150 | √ | null |
|
|
||
| ProspectVolunteer2Surname | varchar | 30 | √ | null |
|
|
||
| ProspectVolunteer2Preferred | varchar | 20 | √ | null |
|
|
||
| ProspectVolunteer2PreferredFormal | varchar | 20 | √ | null |
|
|
||
| ProspectVolunteer2Title | varchar | 30 | √ | null |
|
|
||
| ValidAddressFlag | bit | 1 | √ | null |
|
|
||
| ProspectDefaultEmail | varchar | 201 | √ | null |
|
|
||
| ProspectOccupDesc | varchar | 50 | √ | null |
|
|
||
| ProspectSpouseDefaultEmail | varchar | 201 | √ | null |
|
|
||
| ProspectSpouseOccupDesc | varchar | 50 | √ | null |
|
|
Table contained 0 rows