Skip to main content

Constructor Results

[dbo.constructorResults]

Column nameKeyData typeAllow NULLsDefaultDescription
constructorResultsIdPrimary KeyINT
raceIdFK_ConstructorResults_RaceID (dbo.races raceId)INT0Foreign key link to races table
constructorIdFK_ConstructorResults_ConstructorID (dbo.constructors constructorId)INT0Foreign key link to constructors
pointsFLOATConstructor points for race
positionTextIDFK_ConstructorResults_positionTextID (dbo.positionText positionTextID)INTForeign Key link to postitionText

Table Relationships

Constructor Results

Where Used

Where is this table referenced and what columns are used? The below table shows that information.

Example Query

SELECT 
[constructorResultsId]
,r.[raceId]
,r.date AS [race_date]
,c.[constructorId]
,c.name AS [constructor]
,[points]
,pt.[positionTextID]
,pt.positionText
FROM
[dbo].[constructorResults] cr

INNER JOIN [dbo].[races] r
ON r.raceId = cr.raceId

INNER JOIN [dbo].[constructors] c
ON c.constructorId = cr.constructorId

LEFT OUTER JOIN [dbo].[positionText] pt
ON pt.positionTextID = cr.positionTextID

Example Output

constructorResultsIdraceIdconstructorIdpointspositionTextID
1181140
218280