Circuits
[dbo.circuits]
| Column name | Key | Data type | Allow NULLs | Default | Description |
|---|---|---|---|---|---|
| circuitId | Primary Key | INT | ☐ | ||
| circuitRef | VARCHAR(255) | ☐ | Unique circuit identifier | ||
| name | VARCHAR(255) | ☐ | Circuit name | ||
| alt | INT | ☑ | Altitude (metres) | ||
| url | VARCHAR(255) | ☐ | Circuit Wikipedia page | ||
| locationID | INT | ☑ | Foreign key links to locations | ||
| countryID | INT | ☑ | Foreign Key link to countries | ||
| circuitDirectionID | INT | ☑ | Foreign key link to circuitDirection | ||
| circuitTypeID | INT | ☑ | Foreign key link to circuitType |
Table Relationships
Where Used
Where is this table referenced and what columns are used? The below table shows that information.
[dbo.circuits]
| Parent_schemaName | Parent_tableName | Parent_columnName | Schema | table | column | constraint_name |
|---|---|---|---|---|---|---|
| dbo | circuits | circuitId | dbo | circuitMap | circuitId | FK_circuitMap_circuitId |
| dbo | circuits | circuitId | dbo | races | circuitId | FK_Races_CircuitID |
Example Query
SELECT
[circuitId]
,[circuitRef]
,[name]
,[location]
,[country]
,[alt]
,[url]
FROM
[dbo].[circuits]
WHERE
circuitRef ='spa'
AND active = 1
Example Output
| circuitId | circuitRef | name | alt | url | locationID | countryID | circuitDirectionID | circuitTypeID |
|---|---|---|---|---|---|---|---|---|
| 1 | albert_park | Albert Park Grand Prix Circuit | 10 | http://en.wikipedia.org/wiki/Melbourne_Grand_Prix_Circuit | 40 | 2 | 1 | 1 |
| 2 | sepang | Sepang International Circuit | 18 | http://en.wikipedia.org/wiki/Sepang_International_Circuit | 31 | 17 | 1 | 2 |