Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID |
|
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
Customer’s first name |
|
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
Customer’s last name |
|
| CUSTOMER_EMAIL | varchar | 255 | √ | null |
|
|
Customer’s email address |
|
| CUSTOMER_PHONE | varchar | 255 | √ | null |
|
|
Customer’s phone number |
|
| ENTRY_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The customer record creation date and time |
|
| ENTRY_DATE_ONLY | date | 20 | √ | null |
|
|
The customer record creation date (date only) |
|
| QUESTION_COLUMNS_BUILT_DYNAMICALLY | varchar | 500 | √ | null |
|
|
Columns for each custom question will be dynamically generated |