Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The most recent transaction ID related to the enrollment. |
|
| BEGINNINGDATE | datetime | 16,3 | √ | null |
|
|
The beginning date of this activity |
|
| ENDINGDATE | datetime | 16,3 | √ | null |
|
|
The ending date of this activity |
|
| ENROLLMENT_STATUS | varchar | 255 | √ | null |
|
|
The enrollment status of the customer (Enrolled / Withdrawn / Waitlisted / Waitlist Removed / Trial / Refunded) |
|
| QUESTION_COLUMNS_BUILT_DYNAMICALLY | varchar | 500 | √ | null |
|
|
Columns for each custom question will be dynamically generated |