Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProspectAppeal | varchar | 10 | null |
|
|
|||
| ProspectAppealDescription | varchar | 100 | √ | null |
|
|
||
| ProspectID | int | 4 | null |
|
|
|||
| ProspectActiveFlag | bit | 1 | null |
|
|
|||
| ProspectCapacity | money | 21,4 | √ | null |
|
|
||
| ProspectIndication | money | 21,4 | √ | null |
|
|
||
| ProspectInclination | varchar | 5 | null |
|
|
|||
| ProspectMailName | varchar | 100 | √ | null |
|
|
||
| ProspectName | varchar | 100 | √ | 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 |
|
|
||
| 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 |
|
|
||
| ProspectHomePhone | varchar | 15 | √ | null |
|
|
||
| ProspectHomeFax | varchar | 15 | √ | null |
|
|
||
| ProspectMobilePhone | varchar | 15 | √ | null |
|
|
||
| ProspectDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| ProspectOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| ProspectOccupPhone | varchar | 15 | √ | null |
|
|
||
| ProspectOccupFax | varchar | 15 | √ | null |
|
|
||
| ProspectOccupEmail | varchar | 100 | √ | null |
|
|
||
| ProspectHomeEmail | varchar | 100 | √ | null |
|
|
||
| ProspectorID | int | 4 | √ | null |
|
|
||
| ProspectorMailName | varchar | 100 | √ | null |
|
|
||
| ProspectorNameInternal | varchar | 100 | √ | null |
|
|
||
| ProspectorNameExternal | varchar | 100 | √ | null |
|
|
||
| ProspectorLegalFullName | varchar | 150 | √ | null |
|
|
||
| ProspectorSurname | varchar | 30 | √ | null |
|
|
||
| ProspectorPreferred | varchar | 20 | √ | null |
|
|
||
| ProspectorPreferredFormal | varchar | 20 | √ | 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 |
|
|
||
| ProspectSeq | int | 4 | √ | null |
|
|
||
| ProspectActivityPrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||
| ProspectStartDate | datetime | 16,3 | √ | null |
|
|
||
| ProspectFollowUpDate | datetime | 16,3 | √ | null |
|
|
||
| ProspectFollowUpFlag | bit | 1 | √ | null |
|
|
||
| ProspectActivity | varchar | 10 | √ | null |
|
|
||
| ProspectActivityStatus | varchar | 3 | √ | null |
|
|
||
| ProspectActivityStatusDescription | varchar | 30 | √ | null |
|
|
||
| ProspectActivityComment | varchar | 255 | √ | null |
|
|
Table contained 0 rows