SchemaSpy Analysis of unitregistry.unitregistry - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Mar 02 16:48 PST 2018
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

unitregistry.unitregistry contains 44 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
changeLog timestamp timestamp 19 CURRENT_TIMESTAMP
comment timestamp timestamp 19 CURRENT_TIMESTAMP
login timestamp timestamp 19  √  CURRENT_TIMESTAMP
unit abbreviation varchar 255  √  null
login address varchar 15  √  null
baseQuantity baseQuantityId int unsigned 10  √ 
quantityExpression baseQuantityId int unsigned 10  √  null
baseQuantity baseUnit varchar 255  √  null
baseQuantity baseUnitAbbreviation varchar 255  √  null
changeLog changeLogId int 10  √ 
comment comment text 65535  √  null
comment commentId int unsigned 10  √ 
unit deprecatedDueTo varchar 255  √  null
unit deprecatedTo int unsigned 10  √  null
scope description text 65535  √  null
unit description varchar 255  √  null
changeLog entityId int unsigned 10  √  null
changeLog entityType varchar 255  √  null
baseQuantity name varchar 255  √  null
login name varchar 255  √  null
quantity name varchar 255  √  null
scope name varchar 255  √  null
unit name varchar 255  √  null
unit parentSI int unsigned 10  √  null
quantityExpression power smallint 5  √  null
quantityExpression quantityExpressionId int unsigned 10  √ 
quantity quantityId int unsigned 10  √ 
quantityExpression quantityId int unsigned 10  √  null
unit quantityId int unsigned 10  √  null
scope scopeId int unsigned 10  √ 
unitScope scopeId int unsigned 10  √  null
unit siConstant varchar 255  √  null
changeLog signature char 32  √  null
comment signature varchar 255  √  null
login signature char 32  √  null
unit siMultiplier varchar 255  √  null
changeLog snapshot text 65535  √  null
baseQuantity symbol varchar 255  √  null
quantity symbol varchar 255  √  null
comment unitId int unsigned 10
unit unitId int unsigned 10  √ 
unitScope unitId int unsigned 10  √  null
unitScope unitScopeId int unsigned 10  √ 
login username varchar 32  √  null