| 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 |
|---|---|---|---|---|---|---|---|
| baseQuantity | baseQuantityId | int unsigned | 10 | √ | |||
| baseQuantity | baseUnit | varchar | 255 | √ | null | ||
| baseQuantity | baseUnitAbbreviation | varchar | 255 | √ | null | ||
| baseQuantity | name | varchar | 255 | √ | null | ||
| baseQuantity | symbol | varchar | 255 | √ | null | ||
| changeLog | changeLogId | int | 10 | √ | |||
| changeLog | entityId | int unsigned | 10 | √ | null | ||
| changeLog | entityType | varchar | 255 | √ | null | ||
| changeLog | signature | char | 32 | √ | null | ||
| changeLog | snapshot | text | 65535 | √ | null | ||
| changeLog | timestamp | timestamp | 19 | CURRENT_TIMESTAMP | |||
| comment | comment | text | 65535 | √ | null | ||
| comment | commentId | int unsigned | 10 | √ | |||
| comment | signature | varchar | 255 | √ | null | ||
| comment | timestamp | timestamp | 19 | CURRENT_TIMESTAMP | |||
| comment | unitId | int unsigned | 10 | ||||
| login | address | varchar | 15 | √ | null | ||
| login | name | varchar | 255 | √ | null | ||
| login | signature | char | 32 | √ | null | ||
| login | timestamp | timestamp | 19 | √ | CURRENT_TIMESTAMP | ||
| login | username | varchar | 32 | √ | null | ||
| quantity | name | varchar | 255 | √ | null | ||
| quantity | quantityId | int unsigned | 10 | √ | |||
| quantity | symbol | varchar | 255 | √ | null | ||
| quantityExpression | baseQuantityId | int unsigned | 10 | √ | null | ||
| quantityExpression | power | smallint | 5 | √ | null | ||
| quantityExpression | quantityExpressionId | int unsigned | 10 | √ | |||
| quantityExpression | quantityId | int unsigned | 10 | √ | null | ||
| scope | description | text | 65535 | √ | null | ||
| scope | name | varchar | 255 | √ | null | ||
| scope | scopeId | int unsigned | 10 | √ | |||
| unit | abbreviation | varchar | 255 | √ | null | ||
| unit | deprecatedDueTo | varchar | 255 | √ | null | ||
| unit | deprecatedTo | int unsigned | 10 | √ | null | ||
| unit | description | varchar | 255 | √ | null | ||
| unit | name | varchar | 255 | √ | null | ||
| unit | parentSI | int unsigned | 10 | √ | null | ||
| unit | quantityId | int unsigned | 10 | √ | null | ||
| unit | siConstant | varchar | 255 | √ | null | ||
| unit | siMultiplier | varchar | 255 | √ | null | ||
| unit | unitId | int unsigned | 10 | √ | |||
| unitScope | scopeId | int unsigned | 10 | √ | null | ||
| unitScope | unitId | int unsigned | 10 | √ | null | ||
| unitScope | unitScopeId | int unsigned | 10 | √ |