Table unitregistry.unitregistry.unit Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
unitId int unsigned 10  √ 
comment.unitId fk_comment_unit R
unit.deprecatedTo fk_unit_deprecated R
unit.parentSI fk_unit_parent R
unitScope.unitId fk_unitScope_unit R
quantityId int unsigned 10  √  null
quantity.quantityId fk_unit_quantity R
parentSI int unsigned 10  √  null
unit.unitId fk_unit_parent R
siMultiplier varchar 255  √  null
siConstant varchar 255  √  null
deprecatedTo int unsigned 10  √  null
unit.unitId fk_unit_deprecated R
deprecatedDueTo varchar 255  √  null
name varchar 255  √  null
abbreviation varchar 255  √  null
description varchar 255  √  null

Table contained 1,286 rows at Fri Mar 02 16:48 PST 2018

Indexes:
Column(s) Type Sort Constraint Name
unitId Primary key Asc PRIMARY
deprecatedTo Performance Asc deprecatedTo
quantityId Performance Asc fk_unit_quantity
parentSI Performance Asc fk_unit_unit

Close relationships  within of separation: