The Event Sessions database table is annual, meaning that Event Sessions data is stored in a unique table for each year (event_sessions_2025.id, event_sessions_2024.id, etc.).
| Table Name | Field Name | Description | Default Value | Is Nullable | Data Type | Char Limit |
|---|---|---|---|---|---|---|
| event_sessions | capacity | Maximum number of students allowed to attend the session | 0 | int | ||
| event_sessions | details | Event Details | yes | text | 65535 | |
| event_sessions | event_id | Unique ID assigned to each event | int | |||
| event_sessions | end_date | End date/time of the session | yes | datetime | ||
| event_sessions | id | Unique ID assigned to each event | int | |||
| event_sessions | name | Event Name | yes | varchar | 255 | |
| event_sessions | organization_id | Unique ID assigned to each Enroll customer | int | |||
| event_sessions | start_date | Start date/time of the session | yes | datetime | ||
| event_sessions | total_attended | Total number of students that attended the session | 0 | yes | int | |
| event_sessions | total_booking | Total number of students that were booked to the session | 0 | yes | int | |
| event_sessions | created_at | Date and time the event session record was created | yes | timestamp | ||
| event_sessions | updated_at | "Most recent date and time that the event session record was updated | yes | timestamp | ||
| event_sessions | legacy_id | Unique ID from the legacy system that corresponds to the same field in Enroll | 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
Comments
0 comments
Article is closed for comments.