Constructor Standings

[dbo.constructorStandings]

Column name	Key	Data type	Allow NULLs	Default	Description
constructorStandingsId	Primary Key	INT	☐
raceId	FK_ConstructorStandings_RaceID (dbo.races raceId)	INT	☐	0	Foreign key link to races table
constructorId	FK_ConstructorStandings_ConstructorID (dbo.constructors constructorId)	INT	☐	0	Foreign key link to constructors
points		FLOAT	☐	0	Constructor points for season
position		INT	☑		Constructor standings position
wins		INT	☐	0	Season win count
positionTextID	FK_ConstructorStandings_PositionTextID (dbo.positionText positionTextID)	INT	☑

Table Relationships

Where Used

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

Example Query

SELECT 
    [constructorStandingsId]
    ,r.[raceId]
    ,r.date AS [race_date]
    ,c.[constructorId]
    ,c.name AS [constructor]
    ,[points]
    ,points, 
    position, 
    positionText, 
    wins
FROM 
    [dbo].[constructorStandings] cs

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

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

Example Output

constructorStandingsId	raceId	constructorId	points	position	wins	positionTextID
1	18	1	14	1	1	1
2	18	2	8	3	0	3