Constructor Results

[dbo.constructorResults]

Column name	Key	Data type	Allow NULLs	Default	Description
constructorResultsId	Primary Key	INT	☐
raceId	FK_ConstructorResults_RaceID (dbo.races raceId)	INT	☐	0	Foreign key link to races table
constructorId	FK_ConstructorResults_ConstructorID (dbo.constructors constructorId)	INT	☐	0	Foreign key link to constructors
points		FLOAT	☑		Constructor points for race
positionTextID	FK_ConstructorResults_positionTextID (dbo.positionText positionTextID)	INT	☑		Foreign Key link to postitionText

Table Relationships

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

constructorResultsId	raceId	constructorId	points	positionTextID
1	18	1	14	0
2	18	2	8	0