SchemaSpy Analysis of unitregistry.unitregistry - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Fri Mar 02 16:48 PST 2018 |
| ||||||
|
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 |