Object: event
Name | Type | Null | Default | |
---|---|---|---|---|
event_KEY | int | YES | ||
national_event_KEY | int | NO | ||
distributed_event_KEY | int | NO | ||
supporter_KEY | int | NO | ||
Reference_Name | varchar | NO | ||
Event_Name | varchar | NO | ||
Last_Modified | timestamp | YES | CURRENT_TIMESTAMP | |
Date_Created | timestamp | YES | Invalid Date | |
Description | mediumtext | NO | ||
Address | mediumtext | NO | ||
City | varchar | NO | ||
State | varchar | NO | ||
Zip | varchar | NO | ||
Country | varchar | NO | ||
Directions | mediumtext | NO | ||
Header | mediumtext | NO | ||
Footer | mediumtext | NO | ||
PRIVATE_Zip_Plus_4 | varchar | NO | ||
Start | datetime | NO | ||
End | datetime | NO | ||
Deadline | datetime | NO | ||
Recurrence_Frequency | enum | NO | ||
Recurrence_Interval | varchar | NO | ||
Contact_Email | varchar | NO | ||
No_Registration | tinyint | NO | ||
Guests_allowed | tinyint | NO | ||
Maximum_Attendees | int | NO | ||
Maximum_Waiting_List_Size | int | NO | ||
Hide_Standard_Map | tinyint | NO | ||
Map_URL | mediumtext | NO | ||
Status | enum | NO | ||
This_Event_Costs_Money | tinyint | NO | ||
Ticket_Price | float | NO | ||
merchant_account_KEY | int | NO | ||
Default_Tracking_Code | varchar | NO | ||
redirect_path | varchar | NO | ||
Request | mediumtext | NO | ||
Required | mediumtext | NO | ||
groups_KEYS | mediumtext | NO | ||
required$groups_KEYS | text | NO | ||
Automatically_add_to_Groups | tinyint | NO | ||
Display_to_Chapters | tinyint | NO | ||
Request_Additional_Attendees | tinyint | NO | ||
One_Column_Layout | tinyint | NO | ||
Reminder_Status | enum | NO | ||
Reminder_Hours | int | NO | ||
Latitude | double | NO | ||
Longitude | double | NO | ||
address_md5sum | varchar | NO | ||
Template | varchar | NO | ||
Allow_Guest_Signup | tinyint | NO | ||
Maximum_Donation_Amount | float | NO | ||
Confirmation_Text | text | NO | ||
event$email_trigger_KEYS | text | NO | ||
waiting_list$email_trigger_KEYS | text | NO | ||
upgrade_$email_trigger_KEYS | text | NO | ||
reminder_$email_trigger_KEYS | text | NO | ||
supporter_picture_KEY | int | NO | ||
supporter_my_donate_page_KEY | int | NO | ||
Location_Common_Name | varchar | NO | ||
Facebook_Connect | tinyint | YES | 0 | |
zoom_level | int | NO | ||
Invoice_Option | tinyint | NO | 0 | |
Facebook_ID | varchar | NO | ||
Disable_sent_highest_attendee_wait_list | tinyint | NO | 0 | |
linkRequest | text | NO | ||
linkRequired | text | NO | ||
Publish_To_Commons | tinyint | NO |