Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | bigint identity | 8 | √ | null |
|
|
|||||
| QUESTION_TYPE | varchar | 255 | null |
|
|
Type of question |
|||||
| SUBSYSTEM | varchar | 255 | null |
|
|
Subsystem that generated the question |
|||||
| TRANSACTION_TYPE | varchar | 255 | null |
|
|
Type of transaction that generated the question |
|||||
| CUSTOMQUESTION_ID | int | 4 | null |
|
|
Identifier for the source custom question |
|||||
| CUSTOMQUESTIONANSWER_I_ID | int | 4 | √ | null |
|
|
Identifier for the custom question answer |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Reference to CUSTOMERS |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Reference to ACTIVITIES |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Reference to PROGRAMS |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
Reference to FACILITIES |
||||
| PERMIT_ID | int | 4 | √ | null |
|
|
Reference to FACILITY_RESERVATIONS |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
Reference to PACKAGES |
||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
Reference to MEMBERSHIPS |
||||
| QUESTION_GROUP | varchar | 255 | √ | null |
|
|
Description of the group that the question is a member of |
||||
| TITLE | varchar | 100 | √ | null |
|
|
Title of question |
||||
| QUESTION | varchar | 500 | √ | null |
|
|
Question text |
||||
| ANSWER | varchar | 500 | √ | null |
|
|
Answer given. includes blank value for questions skipped or questions not answered. |
||||
| DATESTAMP | datetime | 16,3 | √ | null |
|
|
Date and time answer was last recorded |
||||
| DATESTAMP_DATE_ONLY | date | 20 | √ | null |
|
|
Date answer was last recorded |
||||
| ACTIVE_HUB_SOURCE | varchar | 255 | null |
|
|
The source of the custom question answer data (internal use) |
|||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
||||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
|||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Reference to the transaction that generated the question, if not a customer question |
||||
| ROOT_TRANSACTION_ID | int | 4 | √ | null |
|
|
Reference to the root transaction that generated the question, if not a customer question |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| CUSTOMQUESTIONANSWER_ID | int | 4 | √ | null |
|
|
Identifier for the custom question answer |
||||
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
Reference to POS_PRODUCTS |
||||
| CHARGE_ID | int | 4 | √ | null |
|
|
charge fee id |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CUSTOM_QUESTION_ANSWERS_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| CUSTOM_QUESTION_ANSWERS_ACTIVITY_ID_CUSTOMER_ID_QUESTION_TYPE_IX | Performance | Asc/Asc/Asc/Asc | ACTIVITY_ID + CUSTOMER_ID + QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_CUSTOMER_ID_TITLE_IX | Performance | Asc/Asc | CUSTOMER_ID + TITLE |
| CUSTOM_QUESTION_ANSWERS_CUSTOMQUESTION_ID_CUSTOMER_ID_IX | Performance | Asc/Asc | CUSTOMQUESTION_ID + CUSTOMER_ID |
| CUSTOM_QUESTION_ANSWERS_CUSTOMQUESTION_ID_ORG_ID_IX | Performance | Asc/Asc | CUSTOMQUESTION_ID + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_CUSTOMQUESTIONANSWER_I_ID_ORG_ID_IX | Performance | Asc/Asc | CUSTOMQUESTIONANSWER_I_ID + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_CUSTOMQUESTIONANSWER_ID_ORG_ID_IX | Performance | Asc/Asc | CUSTOMQUESTIONANSWER_ID + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_DATESTAMP_QUESTION_TYPE_IX | Performance | Asc/Asc/Asc | DATESTAMP + QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_FACILITY_ID_PERMIT_ID_QUESTION_TYPE_IX | Performance | Asc/Asc/Asc/Asc | FACILITY_ID + PERMIT_ID + QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_MEMBERSHIP_ID_QUESTION_TYPE_IX | Performance | Asc/Asc/Asc | MEMBERSHIP_ID + QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_nc_cs_ix | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | ACTIVITY_ID + ANSWER + CUSTOMER_ID + CUSTOMQUESTION_ID + CUSTOMQUESTIONANSWER_I_ID + CUSTOMQUESTIONANSWER_ID + DATESTAMP + FACILITY_ID + MEMBERSHIP_ID + ORG_ID + PACKAGE_ID + PERMIT_ID + POSPRODUCT_ID + PROGRAM_ID + QUESTION_TYPE + ROOT_TRANSACTION_ID + TITLE + TRANSACTION_ID |
| CUSTOM_QUESTION_ANSWERS_ORG_ID_IX | Performance | Asc | ORG_ID |
| CUSTOM_QUESTION_ANSWERS_POSPRODUCT_ID_QUESTION_TYPE_IX | Performance | Asc/Asc/Asc | POSPRODUCT_ID + QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_PROGRAM_ID_CUSTOMER_ID_QUESTION_TYPE_IX | Performance | Asc/Asc/Asc/Asc | PROGRAM_ID + CUSTOMER_ID + QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_PROGRAM_ID_QUESTION_TYPE_IX | Performance | Asc/Asc | PROGRAM_ID + QUESTION_TYPE |
| CUSTOM_QUESTION_ANSWERS_QUESTION_TYPE_IX | Performance | Asc/Asc | QUESTION_TYPE + ORG_ID |
| CUSTOM_QUESTION_ANSWERS_ROOT_TRANSACTION_ID_IX | Performance | Asc | ROOT_TRANSACTION_ID |
| CUSTOM_QUESTION_ANSWERS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| CUSTOM_QUESTION_ANSWERS_TRANSACTION_ID_IX | Performance | Asc | TRANSACTION_ID |