The Event Programs database table is annual, meaning that Event Programs data is stored in a unique table for each year (event_programs_2025.id, event_programs_2024.id, etc.).
| Table Name | Field Name | Description | Default Value | Is Nullable | Data Type | Char Limit |
|---|---|---|---|---|---|---|
| event_programs | id | Unique ID assigned to each event | int | |||
| event_programs | organization_id | Unique ID assigned to each Enroll customer | int | |||
| event_programs | event_id | Unique ID assigned to each event | int | |||
| event_programs | previous_year_id | Unique ID assigned to the previous year for the purposes of rollover | yes | int | ||
| event_programs | created_at | Date and time the event record was created | yes | timestamp | ||
| event_programs | updated_at | Most recent date and time that the event record was updated | yes | timestamp | ||
| event_programs | legacy_id | Unique ID from the legacy system that corresponds to the same field in Enroll | yes | int | ||
| event_programs | program_id | Unique ID assigned to each program | 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.