mmt_unitconversion

This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Holds conversion rules between units (mmt_units). One entry per source/destination unit pair with a conversion factor and an optional script for complex conversions.

1. Columns

Name Type Length Description

Name	Type	Length	Description
`ucv_ID`	`nvarchar`	36	GUID of the conversion rule (primary key).
`ucv_LastUpdatedTS`	`int`	—	Timestamp of the last change (UNIX time).
`ucv_SourceUnit_ID`	`nvarchar`	20	ID of the source unit. References mmt_units.unt_ID.
`ucv_DestUnit_ID`	`nvarchar`	20	ID of the destination unit. References mmt_units.unt_ID.
`ucv_Factor`	`real`	—	Multiplication factor for the conversion (source value * factor = destination value).
`ucv_Script`	`image`	—	Optional script for non-linear conversions (BLOB).

ucv_ID

nvarchar

GUID of the conversion rule (primary key).

ucv_LastUpdatedTS

int

—

Timestamp of the last change (UNIX time).

ucv_SourceUnit_ID

nvarchar

ID of the source unit. References mmt_units.unt_ID.

ucv_DestUnit_ID

nvarchar

ID of the destination unit. References mmt_units.unt_ID.

ucv_Factor

real

—

Multiplication factor for the conversion (source value * factor = destination value).

ucv_Script

image

—

Optional script for non-linear conversions (BLOB).