Object: supporter
| Name | Type | Null | Default | |
|---|---|---|---|---|
| supporter_KEY | int | YES | ||
| Last_Modified | timestamp | YES | CURRENT_TIMESTAMP | |
| Date_Created | timestamp | YES | Invalid Date | |
| Title | varchar | NO | ||
| First_Name | varchar | NO | ||
| MI | varchar | NO | ||
| Last_Name | varchar | NO | ||
| Suffix | varchar | NO | ||
| varchar | NO | |||
| Password | varchar | NO | ||
| Receive_Email | tinyint | YES | 1 | |
| Email_Preference | enum | NO | HTML Email | |
| Last_Bounce | datetime | NO | ||
| Receive_Phone_Blasts | tinyint | NO | ||
| Phone | varchar | NO | ||
| Cell_Phone | varchar | NO | ||
| Phone_Provider | varchar | NO | ||
| Work_Phone | varchar | NO | ||
| Pager | varchar | NO | ||
| Home_Fax | varchar | NO | ||
| Work_Fax | varchar | NO | ||
| Street | varchar | NO | ||
| Street_2 | varchar | NO | ||
| Street_3 | varchar | NO | ||
| City | varchar | NO | ||
| State | varchar | NO | ||
| Zip | varchar | NO | ||
| PRIVATE_Zip_Plus_4 | varchar | NO | ||
| County | varchar | NO | ||
| District | varchar | NO | ||
| Country | varchar | NO | ||
| Latitude | float | NO | ||
| Longitude | float | NO | ||
| Organization | varchar | NO | ||
| Department | varchar | NO | ||
| Occupation | varchar | NO | ||
| Instant_Messenger_Service | enum | NO | ||
| Instant_Messenger_Name | varchar | NO | ||
| Web_Page | varchar | NO | ||
| Alternative_Email | varchar | NO | ||
| Other_Data_1 | varchar | NO | ||
| Other_Data_2 | varchar | NO | ||
| Other_Data_3 | varchar | NO | ||
| Notes | blob | NO | ||
| Source | varchar | NO | ||
| Source_Details | varchar | NO | ||
| Source_Tracking_Code | varchar | NO | ||
| Tracking_Code | varchar | NO | ||
| Status | enum | NO | ||
| uid | varchar | NO | ||
| Timezone | varchar | NO | ||
| Language_Code | varchar | NO | ||
| salesforce_id | varchar | NO | ||
| append_run_date | datetime | NO | ||
| salsa_deleted | tinyint | NO |