Events Data Dictionary

The Events database table is annual, meaning that Events data is stored in a unique table for each year (events_2025.id, events_2024.id, etc.).

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
events	allow_reschedule	Allow guardians to reschedule an event (Yes = 1, No = 0)	0		tinyint
events	description	Event description entered by admins		yes	text	65535
events	id	Unique ID assigned to each event			int
events	max_num_reschedule	Maximum number of times guardian can reschedule an event		yes	int
events	min_num_reschedule	Reschedule deadline (# of hours before the event session)		yes	int
events	name	Name assigned to each event by the admin		yes	varchar	255
events	organization_id	Unique ID assigned to each Enroll customer			int
events	previous_year_id	Unique ID assigned to the previous year for the purposes of rollover		yes	int
events	rsvp_confirmation	Send a confirmation email and/or text message after RSVP (Yes = 1, No = 0)		yes	tinyint
events	rsvp_deadline	RVSP deadline (# of hours before the event session)		yes	int
events	rsvp_reminder	Send a session reminder email and/or text message (Yes = 1, No = 0)		yes	tinyint
events	rsvp_reminder_days	Reminder sent to guardians X days before event session		yes	int
events	rsvp_reminder_time	Reminder sent to guardians X time of day before event session (HH:MM AM/PM)		yes	time
events	status	Event Status (enabled = 1, disabled = 0)	0		tinyint
events	created_at	Date and time the event record was created		yes	timestamp
events	updated_at	Most recent date and time that the event record was updated		yes	timestamp
events	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
events	user_id	Unique ID assigned to admin who created the event		yes	int

Column Header Definitions

• Table Name: Name of database table displayed in Enroll when selecting fields
• Field Name: Name of field displayed in Enroll when selecting fields
• Description: What data is stored in the field
• Default Value: Value automatically assigned by the system as a starting value
• Is Nullable: Field is permitted to have a NULL value
• Data Type:
  • datetime: stores date and time as YYYY-MM-DD HH:MM:SS using 24 hour clock
  • double: a way to store decimal numbers with a higher degree of precision
  • enum: enumerated, a set of named values (ex: offered, waiting)
  • int: integer, whole numbers like 155, 0, -20, supports a large range
  • json: text based format that stores/transmits data to be displayed on a web page
  • text: variable length data that supports a large maximum length
  • time: stores time of day as HH:MM:SS using 24 hour clock 
  • timestamp: stores date and time as YYYY-MM-DD HH:MM:SS using 24 hour clock
  • tinyint: small range of integers
  • varchar: variable length character that supports alphanumeric values
• Char Limit: Character limit on the field that cannot be exceeded