os_specimen_arrays

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_specimen_array_cores.ARRAY_ID FK_OS_SPMN_ARRAY_CORES_ARRAYR
os_specimen_array_events.ARRAY_ID FK_OS_SPMN_ARR_EVENT_ARR_IDR
NAME VARCHAR 64 null
LENGTH DOUBLE 22 √ null
WIDTH DOUBLE 22 √ null
THICKNESS DOUBLE 22 √ null
NUMBER_OF_ROWS SMALLINT 5 null
NUMBER_OF_COLUMNS SMALLINT 5 null
ROW_LABELING_SCHEME VARCHAR 32 null
COLUMN_LABELING_SCHEME VARCHAR 32 null
CORE_DIAMETER DOUBLE 22 null
QUALITY_CONTROL VARCHAR 512 √ null
COMMENTS VARCHAR 512 √ null
CREATION_DATE TIMESTAMP 19 null
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_SPMN_ARRAY_CREATORR
CHECKED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_OS_SPMN_ARRAY_VERIFIERR
STATUS VARCHAR 16 null
ACTIVITY_STATUS VARCHAR 16 null
QUALITY_CONTROL_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_ARRAY_QUALITY_CTRLR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_ARRAY_QUALITY_CTRL Performance Asc QUALITY_CONTROL_ID
FK_OS_SPMN_ARRAY_CREATOR Performance Asc CREATED_BY
FK_OS_SPMN_ARRAY_VERIFIER Performance Asc CHECKED_BY
OS_SPMN_ARRAYS_NAME_UQ Must be unique Asc NAME

Relationships

Close relationships within degrees of separation