EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_PK |
TableName | EBA_SB_ACCESS_LEVELS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_PK Bound Attachments |
Name | Current Value |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_UK_IDX |
TableName | EBA_SB_ACCESS_LEVELS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_ACCESS_LEVELS_UK_IDX ON SURVEY.EBA_SB_ACCESS_LEVELS(ACCESS_LEVEL)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_UK_IDX Index Columns |
ColumnName | Sort Order |
ACCESS_LEVEL | Ascending |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ACCESS_LEVELS.EBA_SB_ACCESS_LEVELS_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_PK |
TableName | EBA_SB_ANSWERS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_PK Bound Attachments |
Name | Current Value |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_UK |
TableName | EBA_SB_ANSWERS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Unique Constraint |
DDL Code |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_UK Index Columns |
ColumnName | Sort Order |
QUESTION_ID | Ascending |
VALUE | Ascending |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_UK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_UK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_UK Bound Attachments |
Name | Current Value |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_IDX |
TableName | EBA_SB_ANSWERS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_ANSWERS_IDX ON SURVEY.EBA_SB_ANSWERS(QUESTION_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_IDX Index Columns |
ColumnName | Sort Order |
QUESTION_ID | Ascending |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ANSWERS.EBA_SB_ANSWERS_IDX Bound Attachments |
Name | Current Value |
EBA_SB_EMAILS.EBA_SB_EMAILS_PK |
TableName | EBA_SB_EMAILS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_EMAILS.EBA_SB_EMAILS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_EMAILS.EBA_SB_EMAILS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_EMAILS.EBA_SB_EMAILS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_EMAILS.EBA_SB_EMAILS_PK Bound Attachments |
Name | Current Value |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_PK |
TableName | EBA_SB_ERROR_LOOKUP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_PK Index Columns |
ColumnName | Sort Order |
CONSTRAINT_NAME | Ascending |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_PK Bound Attachments |
Name | Current Value |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_UK_IDX |
TableName | EBA_SB_ERROR_LOOKUP |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_ERROR_LOOKUP_UK_IDX ON SURVEY.EBA_SB_ERROR_LOOKUP(CONSTRAINT_NAME, LANGUAGE_CODE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_UK_IDX Index Columns |
ColumnName | Sort Order |
CONSTRAINT_NAME | Ascending |
LANGUAGE_CODE | Ascending |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ERROR_LOOKUP.EBA_SB_ERROR_LOOKUP_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_ERRORS.EBA_SB_ERRORS_PK |
TableName | EBA_SB_ERRORS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_ERRORS.EBA_SB_ERRORS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_ERRORS.EBA_SB_ERRORS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_ERRORS.EBA_SB_ERRORS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_ERRORS.EBA_SB_ERRORS_PK Bound Attachments |
Name | Current Value |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_PK |
TableName | EBA_SB_LANGUAGES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_PK Bound Attachments |
Name | Current Value |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_UK_IDX |
TableName | EBA_SB_LANGUAGES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_LANGUAGES_UK_IDX ON SURVEY.EBA_SB_LANGUAGES(LANG_NAME)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_UK_IDX Index Columns |
ColumnName | Sort Order |
LANG_NAME | Ascending |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_CODE_UK_IDX |
TableName | EBA_SB_LANGUAGES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_LANGUAGES_CODE_UK_IDX ON SURVEY.EBA_SB_LANGUAGES(LANG_CODE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_CODE_UK_IDX Index Columns |
ColumnName | Sort Order |
LANG_CODE | Ascending |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_CODE_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_CODE_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_LANGUAGES.EBA_SB_LANGUAGES_CODE_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_PK |
TableName | EBA_SB_NOTIFICATIONS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 0 |
MaxExtents | 0 |
Initial | 0 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_PK Bound Attachments |
Name | Current Value |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_UK_IDX |
TableName | EBA_SB_NOTIFICATIONS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_NOTE_UK_IDX ON SURVEY.EBA_SB_NOTIFICATIONS(NOTIFICATION_NAME)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_UK_IDX Index Columns |
ColumnName | Sort Order |
NOTIFICATION_NAME | Ascending |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 0 |
MaxExtents | 0 |
Initial | 0 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_NOTIFICATIONS.EBA_SB_NOTE_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_PAGES.EBA_SB_PAGES_PK |
TableName | EBA_SB_PAGES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_PAGES.EBA_SB_PAGES_PK Index Columns |
ColumnName | Sort Order |
KEY | Ascending |
EBA_SB_PAGES.EBA_SB_PAGES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_PAGES.EBA_SB_PAGES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_PAGES.EBA_SB_PAGES_PK Bound Attachments |
Name | Current Value |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_PK |
TableName | EBA_SB_PREFERENCES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_PK Bound Attachments |
Name | Current Value |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_UK_IDX |
TableName | EBA_SB_PREFERENCES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_PREFERENCES_UK_IDX ON SURVEY.EBA_SB_PREFERENCES(PREFERENCE_NAME)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_UK_IDX Index Columns |
ColumnName | Sort Order |
PREFERENCE_NAME | Ascending |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_PREFERENCES.EBA_SB_PREFERENCES_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_PK |
TableName | EBA_SB_QUESTION_RESPONSES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_PK Bound Attachments |
Name | Current Value |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_IDX |
TableName | EBA_SB_QUESTION_RESPONSES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_QUESTION_RESPONSES_IDX ON SURVEY.EBA_SB_QUESTION_RESPONSES(RESPONSE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_IDX Index Columns |
ColumnName | Sort Order |
RESPONSE_ID | Ascending |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTION_RESPONSES.EBA_SB_QUESTION_RESPONSES_IDX Bound Attachments |
Name | Current Value |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_PK |
TableName | EBA_SB_QUESTIONNAIRES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_PK Bound Attachments |
Name | Current Value |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_IDX |
TableName | EBA_SB_QUESTIONNAIRES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_QUESTIONNAIRES_IDX ON SURVEY.EBA_SB_QUESTIONNAIRES(SURVEY_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_IDX Index Columns |
ColumnName | Sort Order |
SURVEY_ID | Ascending |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTIONNAIRES.EBA_SB_QUESTIONNAIRES_IDX Bound Attachments |
Name | Current Value |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_PK |
TableName | EBA_SB_QUESTIONS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_PK Bound Attachments |
Name | Current Value |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_UK |
TableName | EBA_SB_QUESTIONS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Unique Constraint |
DDL Code |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_UK Index Columns |
ColumnName | Sort Order |
QUESTIONNAIRE_ID | Ascending |
QUESTION_NUMBER | Ascending |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_UK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_UK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_UK Bound Attachments |
Name | Current Value |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX1 |
TableName | EBA_SB_QUESTIONS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_QUESTIONS_IDX1 ON SURVEY.EBA_SB_QUESTIONS(QUESTIONNAIRE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX1 Index Columns |
ColumnName | Sort Order |
QUESTIONNAIRE_ID | Ascending |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX1 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX1 Bound Attachments |
Name | Current Value |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX2 |
TableName | EBA_SB_QUESTIONS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_QUESTIONS_IDX2 ON SURVEY.EBA_SB_QUESTIONS(SECTION_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX2 Index Columns |
ColumnName | Sort Order |
SECTION_ID | Ascending |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX2 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX2 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_QUESTIONS.EBA_SB_QUESTIONS_IDX2 Bound Attachments |
Name | Current Value |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_IDX |
TableName | EBA_SB_RESPONSES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_RESPONSES_IDX ON SURVEY.EBA_SB_RESPONSES(SURVEY_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_IDX Index Columns |
ColumnName | Sort Order |
SURVEY_ID | Ascending |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_IDX Bound Attachments |
Name | Current Value |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_PK |
TableName | EBA_SB_RESPONSES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_RESPONSES.EBA_SB_RESPONSES_PK Bound Attachments |
Name | Current Value |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_IDX |
TableName | EBA_SB_SECTIONS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_SECTIONS_IDX ON SURVEY.EBA_SB_SECTIONS(QUESTIONNAIRE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_IDX Index Columns |
ColumnName | Sort Order |
QUESTIONNAIRE_ID | Ascending |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_IDX Bound Attachments |
Name | Current Value |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_PK |
TableName | EBA_SB_SECTIONS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_SECTIONS.EBA_SB_SECTIONS_PK Bound Attachments |
Name | Current Value |
EBA_SB_STRINGS.EBA_SB_STRINGS_UK_IDX |
TableName | EBA_SB_STRINGS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_STRINGS_UK_IDX ON SURVEY.EBA_SB_STRINGS(LANG_CODE, QUESTIONNAIRE_ID, KEY)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_STRINGS.EBA_SB_STRINGS_UK_IDX Index Columns |
ColumnName | Sort Order |
LANG_CODE | Ascending |
QUESTIONNAIRE_ID | Ascending |
KEY | Ascending |
EBA_SB_STRINGS.EBA_SB_STRINGS_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_STRINGS.EBA_SB_STRINGS_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_STRINGS.EBA_SB_STRINGS_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_STRINGS.EBA_SB_STRINGS_PK |
TableName | EBA_SB_STRINGS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_STRINGS.EBA_SB_STRINGS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_STRINGS.EBA_SB_STRINGS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_STRINGS.EBA_SB_STRINGS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_STRINGS.EBA_SB_STRINGS_PK Bound Attachments |
Name | Current Value |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_PK |
TableName | EBA_SB_SURVEYS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_PK Bound Attachments |
Name | Current Value |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_UK |
TableName | EBA_SB_SURVEYS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Unique Constraint |
DDL Code |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_UK Index Columns |
ColumnName | Sort Order |
NAME | Ascending |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_UK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_UK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_SURVEYS.EBA_SB_SURVEYS_UK Bound Attachments |
Name | Current Value |
EBA_SB_TAGS.SYS_C00135447 |
TableName | EBA_SB_TAGS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_TAGS.SYS_C00135447 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_TAGS.SYS_C00135447 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_TAGS.SYS_C00135447 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_TAGS.SYS_C00135447 Bound Attachments |
Name | Current Value |
EBA_SB_TAGS_SUM.EBA_SB_TAGS_SUM_PK |
TableName | EBA_SB_TAGS_SUM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_TAGS_SUM.EBA_SB_TAGS_SUM_PK Index Columns |
ColumnName | Sort Order |
TAG | Ascending |
EBA_SB_TAGS_SUM.EBA_SB_TAGS_SUM_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_TAGS_SUM.EBA_SB_TAGS_SUM_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_TAGS_SUM.EBA_SB_TAGS_SUM_PK Bound Attachments |
Name | Current Value |
EBA_SB_TAGS_TYPE_SUM.EBA_SB_TAGS_TYPE_SUM_PK |
TableName | EBA_SB_TAGS_TYPE_SUM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_TAGS_TYPE_SUM.EBA_SB_TAGS_TYPE_SUM_PK Index Columns |
ColumnName | Sort Order |
TAG | Ascending |
CONTENT_TYPE | Ascending |
EBA_SB_TAGS_TYPE_SUM.EBA_SB_TAGS_TYPE_SUM_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_TAGS_TYPE_SUM.EBA_SB_TAGS_TYPE_SUM_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_TAGS_TYPE_SUM.EBA_SB_TAGS_TYPE_SUM_PK Bound Attachments |
Name | Current Value |
EBA_SB_TZ_PREF.EBA_SB_TZ_PREF_PK |
TableName | EBA_SB_TZ_PREF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_TZ_PREF.EBA_SB_TZ_PREF_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_TZ_PREF.EBA_SB_TZ_PREF_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_TZ_PREF.EBA_SB_TZ_PREF_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_TZ_PREF.EBA_SB_TZ_PREF_PK Bound Attachments |
Name | Current Value |
EBA_SB_USERS.EBA_SB_USERS_PK |
TableName | EBA_SB_USERS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EBA_SB_USERS.EBA_SB_USERS_PK Index Columns |
ColumnName | Sort Order |
ID | Ascending |
EBA_SB_USERS.EBA_SB_USERS_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 0 |
MaxExtents | 0 |
Initial | 0 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_USERS.EBA_SB_USERS_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_USERS.EBA_SB_USERS_PK Bound Attachments |
Name | Current Value |
EBA_SB_USERS.EBA_SB_USERS_UK_IDX |
TableName | EBA_SB_USERS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX SURVEY.EBA_SB_USERS_UK_IDX ON SURVEY.EBA_SB_USERS(USERNAME)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_USERS.EBA_SB_USERS_UK_IDX Index Columns |
ColumnName | Sort Order |
USERNAME | Ascending |
EBA_SB_USERS.EBA_SB_USERS_UK_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 0 |
MaxExtents | 0 |
Initial | 0 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_USERS.EBA_SB_USERS_UK_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_USERS.EBA_SB_USERS_UK_IDX Bound Attachments |
Name | Current Value |
EBA_SB_USERS.EBA_SB_USERS_ACC_LVL_IDX |
TableName | EBA_SB_USERS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SURVEY.EBA_SB_USERS_ACC_LVL_IDX ON SURVEY.EBA_SB_USERS(ACCESS_LEVEL_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SURVEY      LOGGING      STORAGE(PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
EBA_SB_USERS.EBA_SB_USERS_ACC_LVL_IDX Index Columns |
ColumnName | Sort Order |
ACCESS_LEVEL_ID | Ascending |
EBA_SB_USERS.EBA_SB_USERS_ACC_LVL_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SURVEY |
PctFree | 10 |
MinExtents | 0 |
MaxExtents | 0 |
Initial | 0 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
EBA_SB_USERS.EBA_SB_USERS_ACC_LVL_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EBA_SB_USERS.EBA_SB_USERS_ACC_LVL_IDX Bound Attachments |
Name | Current Value |
OL$.OL$NAME |
TableName | OL$ |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX OUTLN.OL$NAME ON OUTLN.OL$(OL_NAME)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SYSTEM      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
OL$.OL$NAME Index Columns |
ColumnName | Sort Order |
OL_NAME | Ascending |
OL$.OL$NAME Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SYSTEM |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
OL$.OL$NAME Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OL$.OL$NAME Bound Attachments |
Name | Current Value |
OL$.OL$SIGNATURE |
TableName | OL$ |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX OUTLN.OL$SIGNATURE ON OUTLN.OL$(SIGNATURE, CATEGORY)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SYSTEM      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
OL$.OL$SIGNATURE Index Columns |
ColumnName | Sort Order |
SIGNATURE | Ascending |
CATEGORY | Ascending |
OL$.OL$SIGNATURE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SYSTEM |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | DEFAULT |
Index Compression | NO |
OL$.OL$SIGNATURE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OL$.OL$SIGNATURE Bound Attachments |
Name | Current Value |