ToolTypes

322 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id uuid 2147483647 null
Equipments.ToolTypeId FK_Equipments_ToolTypes_ToolTypeId N
Name text 2147483647 null
TAId uuid 2147483647 √ null
ToolTypeTAs.Id FK_ToolTypes_ToolTypeTAs_TAId R
GroupId uuid 2147483647 √ null
ToolTypeGroups.Id FK_ToolTypes_ToolTypeGroups_GroupId R
ServiceId uuid 2147483647 √ null
ToolTypeServices.Id FK_ToolTypes_ToolTypeServices_ServiceId R
SizeId uuid 2147483647 √ null
ToolTypeSizes.Id FK_ToolTypes_ToolTypeSizes_SizeId R
SubGroupId uuid 2147483647 √ null
ToolTypeSubGroups.Id FK_ToolTypes_ToolTypeSubGroups_SubGroupId R
IsDeleted bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_ToolTypes Primary key Asc Id
IX_ToolTypes_GroupId Performance Asc GroupId
IX_ToolTypes_ServiceId Performance Asc ServiceId
IX_ToolTypes_SizeId Performance Asc SizeId
IX_ToolTypes_SubGroupId Performance Asc SubGroupId
IX_ToolTypes_TAId Performance Asc TAId

Relationships

Close relationships within degrees of separation