ACCESS_GROUP.SYS_C0059624 |
TableName | ACCESS_GROUP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ACCESS_GROUP.SYS_C0059624 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
ACCESS_GROUP.SYS_C0059624 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
ACCESS_GROUP.SYS_C0059624 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ACCESS_GROUP.SYS_C0059624 Bound Attachments |
Name | Current Value |
ACCESS_GROUP_PERMISSIONS.SYS_C0059634 |
TableName | ACCESS_GROUP_PERMISSIONS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ACCESS_GROUP_PERMISSIONS.SYS_C0059634 Index Columns |
ColumnName | Sort Order |
ACCESS_GROUP_ID | Ascending |
PERMISSIONS_ID | Ascending |
ACCESS_GROUP_PERMISSIONS.SYS_C0059634 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
ACCESS_GROUP_PERMISSIONS.SYS_C0059634 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ACCESS_GROUP_PERMISSIONS.SYS_C0059634 Bound Attachments |
Name | Current Value |
CALIBRATION.SYS_C0059594 |
TableName | CALIBRATION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CALIBRATION.SYS_C0059594 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
CALIBRATION.SYS_C0059594 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
CALIBRATION.SYS_C0059594 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CALIBRATION.SYS_C0059594 Bound Attachments |
Name | Current Value |
CALIBRATION_DATAFILE_LIST.SYS_C0073125 |
TableName | CALIBRATION_DATAFILE_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CALIBRATION_DATAFILE_LIST.SYS_C0073125 Index Columns |
ColumnName | Sort Order |
CALIBRATION_ID | Ascending |
DATAFILE_ID | Ascending |
CALIBRATION_DATAFILE_LIST.SYS_C0073125 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
CALIBRATION_DATAFILE_LIST.SYS_C0073125 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CALIBRATION_DATAFILE_LIST.SYS_C0073125 Bound Attachments |
Name | Current Value |
CALIBRATION_LIST.SYS_C0059620 |
TableName | CALIBRATION_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CALIBRATION_LIST.SYS_C0059620 Index Columns |
ColumnName | Sort Order |
CALIBRATION_ID | Ascending |
PARAMETER_ID | Ascending |
CALIBRATION_LIST.SYS_C0059620 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
CALIBRATION_LIST.SYS_C0059620 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CALIBRATION_LIST.SYS_C0059620 Bound Attachments |
Name | Current Value |
DATAFILE.SYS_C0059609 |
TableName | DATAFILE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATAFILE.SYS_C0059609 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
DATAFILE.SYS_C0059609 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATAFILE.SYS_C0059609 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATAFILE.SYS_C0059609 Bound Attachments |
Name | Current Value |
DATAFILE_DOWNLOAD.SYS_C0059639 |
TableName | DATAFILE_DOWNLOAD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATAFILE_DOWNLOAD.SYS_C0059639 Index Columns |
ColumnName | Sort Order |
PERMISSIONS_ID | Ascending |
DATAFILE_ID | Ascending |
DATAFILE_DOWNLOAD.SYS_C0059639 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATAFILE_DOWNLOAD.SYS_C0059639 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATAFILE_DOWNLOAD.SYS_C0059639 Bound Attachments |
Name | Current Value |
DATAFILE_FORMAT.SYS_C0059576 |
TableName | DATAFILE_FORMAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATAFILE_FORMAT.SYS_C0059576 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
DATAFILE_FORMAT.SYS_C0059576 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATAFILE_FORMAT.SYS_C0059576 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATAFILE_FORMAT.SYS_C0059576 Bound Attachments |
Name | Current Value |
DATAFILE_LIST.SYS_C0059614 |
TableName | DATAFILE_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATAFILE_LIST.SYS_C0059614 Index Columns |
ColumnName | Sort Order |
DATASET_ID | Ascending |
DATAFILE_ID | Ascending |
DATAFILE_LIST.SYS_C0059614 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATAFILE_LIST.SYS_C0059614 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATAFILE_LIST.SYS_C0059614 Bound Attachments |
Name | Current Value |
DATAFILE_TYPE.SYS_C0059608 |
TableName | DATAFILE_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATAFILE_TYPE.SYS_C0059608 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
DATAFILE_TYPE.SYS_C0059608 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATAFILE_TYPE.SYS_C0059608 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATAFILE_TYPE.SYS_C0059608 Bound Attachments |
Name | Current Value |
DATASET.SYS_C0059593 |
TableName | DATASET |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATASET.SYS_C0059593 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
DATASET.SYS_C0059593 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATASET.SYS_C0059593 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATASET.SYS_C0059593 Bound Attachments |
Name | Current Value |
DATASET_LIST.SYS_C0059617 |
TableName | DATASET_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATASET_LIST.SYS_C0059617 Index Columns |
ColumnName | Sort Order |
INVESTIGATION_ID | Ascending |
DATASET_ID | Ascending |
DATASET_LIST.SYS_C0059617 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATASET_LIST.SYS_C0059617 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATASET_LIST.SYS_C0059617 Bound Attachments |
Name | Current Value |
DATASET_STATUS.SYS_C0059591 |
TableName | DATASET_STATUS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATASET_STATUS.SYS_C0059591 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
DATASET_STATUS.SYS_C0059591 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATASET_STATUS.SYS_C0059591 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATASET_STATUS.SYS_C0059591 Bound Attachments |
Name | Current Value |
DATASET_TYPE.SYS_C0059592 |
TableName | DATASET_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DATASET_TYPE.SYS_C0059592 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
DATASET_TYPE.SYS_C0059592 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
DATASET_TYPE.SYS_C0059592 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DATASET_TYPE.SYS_C0059592 Bound Attachments |
Name | Current Value |
ID_SEQUENCE_TABLE.SYS_C0059661 |
TableName | ID_SEQUENCE_TABLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ID_SEQUENCE_TABLE.SYS_C0059661 Index Columns |
ColumnName | Sort Order |
NAME | Ascending |
ID_SEQUENCE_TABLE.SYS_C0059661 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
ID_SEQUENCE_TABLE.SYS_C0059661 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ID_SEQUENCE_TABLE.SYS_C0059661 Bound Attachments |
Name | Current Value |
INVESTIGATION.SYS_C0059597 |
TableName | INVESTIGATION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVESTIGATION.SYS_C0059597 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
INVESTIGATION.SYS_C0059597 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
INVESTIGATION.SYS_C0059597 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVESTIGATION.SYS_C0059597 Bound Attachments |
Name | Current Value |
INVESTIGATION_LIST.SYS_C0059599 |
TableName | INVESTIGATION_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVESTIGATION_LIST.SYS_C0059599 Index Columns |
ColumnName | Sort Order |
STUDY_ID | Ascending |
INVESTIGATION_ID | Ascending |
INVESTIGATION_LIST.SYS_C0059599 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
INVESTIGATION_LIST.SYS_C0059599 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVESTIGATION_LIST.SYS_C0059599 Bound Attachments |
Name | Current Value |
INVESTIGATION_TYPE.SYS_C0059596 |
TableName | INVESTIGATION_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVESTIGATION_TYPE.SYS_C0059596 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
INVESTIGATION_TYPE.SYS_C0059596 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
INVESTIGATION_TYPE.SYS_C0059596 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVESTIGATION_TYPE.SYS_C0059596 Bound Attachments |
Name | Current Value |
INVESTIGATOR_LIST.SYS_C0059629 |
TableName | INVESTIGATOR_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVESTIGATOR_LIST.SYS_C0059629 Index Columns |
ColumnName | Sort Order |
PARTY_ID | Ascending |
INVESTIGATION_ID | Ascending |
INVESTIGATOR_LIST.SYS_C0059629 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
INVESTIGATOR_LIST.SYS_C0059629 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVESTIGATOR_LIST.SYS_C0059629 Bound Attachments |
Name | Current Value |
KEYWORD.SYS_C0059578 |
TableName | KEYWORD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
KEYWORD.SYS_C0059578 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
KEYWORD.SYS_C0059578 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
KEYWORD.SYS_C0059578 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
KEYWORD.SYS_C0059578 Bound Attachments |
Name | Current Value |
KEYWORD_LIST.SYS_C0059582 |
TableName | KEYWORD_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
KEYWORD_LIST.SYS_C0059582 Index Columns |
ColumnName | Sort Order |
STUDY_ID | Ascending |
KEYWORD_ID | Ascending |
KEYWORD_LIST.SYS_C0059582 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
KEYWORD_LIST.SYS_C0059582 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
KEYWORD_LIST.SYS_C0059582 Bound Attachments |
Name | Current Value |
PARAMETER.SYS_C0059607 |
TableName | PARAMETER |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PARAMETER.SYS_C0059607 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PARAMETER.SYS_C0059607 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PARAMETER.SYS_C0059607 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PARAMETER.SYS_C0059607 Bound Attachments |
Name | Current Value |
PARAMETER_LIST.SYS_C0059611 |
TableName | PARAMETER_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PARAMETER_LIST.SYS_C0059611 Index Columns |
ColumnName | Sort Order |
DATAFILE_ID | Ascending |
PARAMETER_ID | Ascending |
PARAMETER_LIST.SYS_C0059611 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PARAMETER_LIST.SYS_C0059611 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PARAMETER_LIST.SYS_C0059611 Bound Attachments |
Name | Current Value |
PARTY_ACCESS_GROUP.SYS_C0059627 |
TableName | PARTY_ACCESS_GROUP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PARTY_ACCESS_GROUP.SYS_C0059627 Index Columns |
ColumnName | Sort Order |
PARTY_ID | Ascending |
ACCESS_GROUP_ID | Ascending |
PARTY_ACCESS_GROUP.SYS_C0059627 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PARTY_ACCESS_GROUP.SYS_C0059627 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PARTY_ACCESS_GROUP.SYS_C0059627 Bound Attachments |
Name | Current Value |
PARTY_PERMISSIONS.SYS_C0059637 |
TableName | PARTY_PERMISSIONS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PARTY_PERMISSIONS.SYS_C0059637 Index Columns |
ColumnName | Sort Order |
PARTY_ID | Ascending |
PERMISSIONS_ID | Ascending |
PARTY_PERMISSIONS.SYS_C0059637 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PARTY_PERMISSIONS.SYS_C0059637 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PARTY_PERMISSIONS.SYS_C0059637 Bound Attachments |
Name | Current Value |
PERMISSIONS.SYS_C0059625 |
TableName | PERMISSIONS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERMISSIONS.SYS_C0059625 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PERMISSIONS.SYS_C0059625 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PERMISSIONS.SYS_C0059625 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERMISSIONS.SYS_C0059625 Bound Attachments |
Name | Current Value |
PLATFORM.SYS_C0059646 |
TableName | PLATFORM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PLATFORM.SYS_C0059646 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PLATFORM.SYS_C0059646 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PLATFORM.SYS_C0059646 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PLATFORM.SYS_C0059646 Bound Attachments |
Name | Current Value |
PUBLICATION.SYS_C0059580 |
TableName | PUBLICATION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUBLICATION.SYS_C0059580 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
PUBLICATION.SYS_C0059580 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PUBLICATION.SYS_C0059580 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUBLICATION.SYS_C0059580 Bound Attachments |
Name | Current Value |
PUBLICATION_LIST.SYS_C0059588 |
TableName | PUBLICATION_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUBLICATION_LIST.SYS_C0059588 Index Columns |
ColumnName | Sort Order |
STUDY_ID | Ascending |
PUBLICATION_ID | Ascending |
PUBLICATION_LIST.SYS_C0059588 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
PUBLICATION_LIST.SYS_C0059588 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUBLICATION_LIST.SYS_C0059588 Bound Attachments |
Name | Current Value |
RELATED_DATAFILES.SYS_C0059649 |
TableName | RELATED_DATAFILES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RELATED_DATAFILES.SYS_C0059649 Index Columns |
ColumnName | Sort Order |
SOURCE_DATAFILE_ID | Ascending |
DESTINATION_DATAFILE_ID | Ascending |
RELATED_DATAFILES.SYS_C0059649 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
RELATED_DATAFILES.SYS_C0059649 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RELATED_DATAFILES.SYS_C0059649 Bound Attachments |
Name | Current Value |
SAMPLE.SYS_C0059603 |
TableName | SAMPLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE.SYS_C0059603 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
SAMPLE.SYS_C0059603 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SAMPLE.SYS_C0059603 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE.SYS_C0059603 Bound Attachments |
Name | Current Value |
SAMPLE_LIST.SYS_C0063677 |
TableName | SAMPLE_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE_LIST.SYS_C0063677 Index Columns |
ColumnName | Sort Order |
DATASET_ID | Ascending |
SAMPLE_ID | Ascending |
SAMPLE_LIST.SYS_C0063677 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SAMPLE_LIST.SYS_C0063677 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE_LIST.SYS_C0063677 Bound Attachments |
Name | Current Value |
SAMPLE_PARAMETER_LIST.SYS_C0059642 |
TableName | SAMPLE_PARAMETER_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE_PARAMETER_LIST.SYS_C0059642 Index Columns |
ColumnName | Sort Order |
SAMPLE_ID | Ascending |
PARAMETER_ID | Ascending |
SAMPLE_PARAMETER_LIST.SYS_C0059642 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SAMPLE_PARAMETER_LIST.SYS_C0059642 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE_PARAMETER_LIST.SYS_C0059642 Bound Attachments |
Name | Current Value |
SAMPLE_TYPE.SYS_C0059602 |
TableName | SAMPLE_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE_TYPE.SYS_C0059602 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
SAMPLE_TYPE.SYS_C0059602 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SAMPLE_TYPE.SYS_C0059602 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE_TYPE.SYS_C0059602 Bound Attachments |
Name | Current Value |
SAMPLE_TYPE_LIST.SYS_C0059631 |
TableName | SAMPLE_TYPE_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE_TYPE_LIST.SYS_C0059631 Index Columns |
ColumnName | Sort Order |
SAMPLE_ID | Ascending |
SAMPLE_TYPE_ID | Ascending |
SAMPLE_TYPE_LIST.SYS_C0059631 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SAMPLE_TYPE_LIST.SYS_C0059631 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE_TYPE_LIST.SYS_C0059631 Bound Attachments |
Name | Current Value |
SNS_CYCLE.SYS_C0059623 |
TableName | SNS_CYCLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SNS_CYCLE.SYS_C0059623 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
SNS_CYCLE.SYS_C0059623 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SNS_CYCLE.SYS_C0059623 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SNS_CYCLE.SYS_C0059623 Bound Attachments |
Name | Current Value |
SOFTWARE.SYS_C0059645 |
TableName | SOFTWARE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SOFTWARE.SYS_C0059645 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
SOFTWARE.SYS_C0059645 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SOFTWARE.SYS_C0059645 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SOFTWARE.SYS_C0059645 Bound Attachments |
Name | Current Value |
SOFTWARE_AUTHORS.SYS_C0059653 |
TableName | SOFTWARE_AUTHORS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SOFTWARE_AUTHORS.SYS_C0059653 Index Columns |
ColumnName | Sort Order |
SOFTWARE_VERSION_ID | Ascending |
PARTY_ID | Ascending |
SOFTWARE_AUTHORS.SYS_C0059653 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SOFTWARE_AUTHORS.SYS_C0059653 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SOFTWARE_AUTHORS.SYS_C0059653 Bound Attachments |
Name | Current Value |
SOFTWARE_FORMATS.SYS_C0059658 |
TableName | SOFTWARE_FORMATS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SOFTWARE_FORMATS.SYS_C0059658 Index Columns |
ColumnName | Sort Order |
SOFTWARE_VERSION_ID | Ascending |
DATAFILE_FORMAT_ID | Ascending |
SOFTWARE_FORMATS.SYS_C0059658 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SOFTWARE_FORMATS.SYS_C0059658 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SOFTWARE_FORMATS.SYS_C0059658 Bound Attachments |
Name | Current Value |
SOFTWARE_PLATFORM.SYS_C0059655 |
TableName | SOFTWARE_PLATFORM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SOFTWARE_PLATFORM.SYS_C0059655 Index Columns |
ColumnName | Sort Order |
SOFTWARE_VERSION_ID | Ascending |
SOFTWARE_PLATFORM_ID | Ascending |
SOFTWARE_PLATFORM.SYS_C0059655 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SOFTWARE_PLATFORM.SYS_C0059655 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SOFTWARE_PLATFORM.SYS_C0059655 Bound Attachments |
Name | Current Value |
SOFTWARE_VERSION.SYS_C0059647 |
TableName | SOFTWARE_VERSION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SOFTWARE_VERSION.SYS_C0059647 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
SOFTWARE_VERSION.SYS_C0059647 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
SOFTWARE_VERSION.SYS_C0059647 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SOFTWARE_VERSION.SYS_C0059647 Bound Attachments |
Name | Current Value |
STUDY.SYS_C0059581 |
TableName | STUDY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
STUDY.SYS_C0059581 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
STUDY.SYS_C0059581 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
STUDY.SYS_C0059581 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STUDY.SYS_C0059581 Bound Attachments |
Name | Current Value |
STUDY_STATUS.SYS_C0059577 |
TableName | STUDY_STATUS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
STUDY_STATUS.SYS_C0059577 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
STUDY_STATUS.SYS_C0059577 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
STUDY_STATUS.SYS_C0059577 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STUDY_STATUS.SYS_C0059577 Bound Attachments |
Name | Current Value |
TOPIC.SYS_C0059579 |
TableName | TOPIC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
TOPIC.SYS_C0059579 Index Columns |
ColumnName | Sort Order |
ID | Ascending |
TOPIC.SYS_C0059579 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
TOPIC.SYS_C0059579 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
TOPIC.SYS_C0059579 Bound Attachments |
Name | Current Value |
TOPIC_LIST.SYS_C0059585 |
TableName | TOPIC_LIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
TOPIC_LIST.SYS_C0059585 Index Columns |
ColumnName | Sort Order |
STUDY_ID | Ascending |
TOPIC_ID | Ascending |
TOPIC_LIST.SYS_C0059585 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SICAT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
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 |
TOPIC_LIST.SYS_C0059585 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
TOPIC_LIST.SYS_C0059585 Bound Attachments |
Name | Current Value |