Equipments

52138 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int8 19 null
ToolTypeId uuid 2147483647 √ null
ToolTypes.Id FK_Equipments_ToolTypes_ToolTypeId N
InventoryGroupId uuid 2147483647 √ null
InventoryGroups.Id FK_Equipments_InventoryGroups_InventoryGroupId N
InventoryDate text 2147483647 √ null
EquipmentModelId uuid 2147483647 √ null
EquipmentModels.Id FK_Equipments_EquipmentModels_EquipmentModelId N
AcquisitionDate date 13 √ null
IsDeleted bool 1 √ null
EquipmentSn text 2147483647 √ null
EquipmentClassId uuid 2147483647 √ null
EquipmentClasses.Id FK_Equipments_EquipmentClasses_EquipmentClassId N
EquipmentLocationId uuid 2147483647 √ null
EquipmentLocations.Id FK_Equipments_EquipmentLocations_EquipmentLocationId N
Description text 2147483647 √ null
Location1C text 2147483647 √ null
EquipmentStatusId uuid 2147483647 √ null
EquipmentStatuses.Id FK_Equipments_EquipmentStatuses_EquipmentStatusId R
ParentId int8 19 √ null
Status1C text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_Equipments Primary key Asc Id
IX_Equipments_EquipmentClassId Performance Asc EquipmentClassId
IX_Equipments_EquipmentLocationId Performance Asc EquipmentLocationId
IX_Equipments_EquipmentModelId Performance Asc EquipmentModelId
IX_Equipments_EquipmentStatusId Performance Asc EquipmentStatusId
IX_Equipments_InventoryGroupId Performance Asc InventoryGroupId
IX_Equipments_ToolTypeId Performance Asc ToolTypeId

Relationships

Close relationships within degrees of separation