Unit

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UnitID INT 10 √ null
OrganisationID INT 10 null
Organisation.OrganisationID Implied Constraint R
UnitAbbreviation VARCHAR 50 √ null
UnitDescription VARCHAR 50 √ null
created_at DATETIME 19 √ CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc UnitID
OrganisationID Performance Asc OrganisationID

Relationships

Close relationships within degrees of separation