Skip to main content

Constructors

[dbo.constructors]

Column nameKeyData typeAllow NULLsDefaultDescription
constructorIdPrimary KeyINT
constructorRefVARCHAR(255)Unique constructor identifier
nameVARCHAR(255)Constructor name
urlVARCHAR(2048)Constructor Wikipedia page
nationalityIDFK_constructors_NationalityID (dbo.nationalities nationalityID)INTForeign Key to nationalities

Table Relationships

Constructors

Where Used

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

[dbo.constructors]

Parent_schemaNameParent_tableNameParent_columnNameSchematablecolumnconstraint_name
dboconstructorsconstructorIddboconstructorStandingsconstructorIdFK_ConstructorStandings_ConstructorID
dboconstructorsconstructorIddboconstructorResultsconstructorIdFK_ConstructorResults_ConstructorID
dboconstructorsconstructorIddbodriverNumbersconstructorIDPK_driverNumbers_constructorID
dboconstructorsconstructorIddboresultDriverConstructorconstructorIDPK_resultDriverConstructor_constructorID
dboconstructorsconstructorIddboqualifyingconstructorIdFK_Qualifying_ConstructorID

Example Query

SELECT 
[constructorId]
,[constructorRef]
,[name]
,[url]
,n.[nationalityID]
,n.nationality
FROM
[SequelFormula].[dbo].[constructors] c

INNER JOIN [dbo].[nationalities] n
ON n.nationalityID = c.nationalityID

Example Output

constructorIdconstructorRefnameurlnationalityID
1mclarenMcLarenhttp://en.wikipedia.org/wiki/McLaren10
2bmw_sauberBMW Sauberhttp://en.wikipedia.org/wiki/BMW_Sauber21