Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProspectID | int | 4 | null |
|
|
|||
| Appeal | varchar | 10 | null |
|
|
|||
| PropsectCapacity | money | 21,4 | √ | null |
|
|
||
| PropsectIndication | money | 21,4 | √ | null |
|
|
||
| PropsectInclination | varchar | 5 | null |
|
|
|||
| ProspectInclinationDescription | varchar | 30 | √ | 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 |
|
|
|||
| ProspectMailNamePrimary | varchar | 100 | null |
|
|
|||
| ProspectMailNameJoint | varchar | 100 | null |
|
|
|||
| ProspectMailSalutationPrimary | varchar | 100 | null |
|
|
|||
| ProspectMailSalutationJoint | varchar | 100 | null |
|
|
|||
| ProspectAddressID | int | 4 | null |
|
|
|||
| ProspectSuburb | varchar | 40 | null |
|
|
|||
| ProspectState | varchar | 5 | null |
|
|
|||
| ProspectCountryCode | varchar | 5 | null |
|
|
|||
| ProspectPostCode | varchar | 5 | null |
|
|
|||
| ProspectPhoneActual | varchar | 15 | null |
|
|
|||
| ProspectPhoneAlt | varchar | 15 | null |
|
|
|||
| ProspectFax | varchar | 15 | null |
|
|
|||
| ProspectHomeSuburb | varchar | 40 | null |
|
|
|||
| ProspectHomeState | varchar | 5 | null |
|
|
|||
| ProspectHomeCountryCode | varchar | 5 | null |
|
|
|||
| ProspectHomePostCode | varchar | 5 | null |
|
|
|||
| ProspectSilentPhoneFlag | bit | 1 | null |
|
|
|||
| ProspectMailFlag | bit | 1 | null |
|
|
|||
| ProspectMagazineFlag | bit | 1 | null |
|
|
|||
| ProspectSolicitationFlag | bit | 1 | null |
|
|
|||
| ProspectRaffleFlag | bit | 1 | null |
|
|
|||
| ProspectAddressComma | varchar | 200 | √ | null |
|
|
||
| ProspectAddressFull | varchar | 200 | √ | null |
|
|
||
| ProspectHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| ProspectHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| ProspectPhone | varchar | 15 | √ | null |
|
|
||
| ProspectStaffID | int | 4 | √ | null |
|
|
||
| ProspectStaffName | varchar | 51 | √ | null |
|
|
||
| ProspectStaffID2 | int | 4 | √ | null |
|
|
||
| ProspectStaff2Name | varchar | 51 | √ | null |
|
|
||
| VolunteerID | int | 4 | √ | null |
|
|
||
| ProspectVolunteerName | varchar | 51 | √ | null |
|
|
||
| VolunteerID2 | int | 4 | √ | null |
|
|
||
| ProspectVolunteer2Name | varchar | 51 | √ | null |
|
|
||
| LastActivitySeq | int | 4 | √ | null |
|
|
||
| LastActivityStartDate | datetime | 16,3 | √ | null |
|
|
||
| LastActivityFollowUpDate | datetime | 16,3 | √ | null |
|
|
||
| LastActivityFollowUpFlag | bit | 1 | √ | null |
|
|
||
| LastActivity | varchar | 10 | √ | null |
|
|
||
| LastActivityDescription | varchar | 30 | √ | null |
|
|
||
| LastActivityStatus | varchar | 3 | √ | null |
|
|
||
| LastActivityStatusDescription | varchar | 30 | √ | null |
|
|
||
| LastActivityComment | varchar | 255 | √ | null |
|
|
Table contained 0 rows