Seasons
[dbo.seasons]
| Column name | Key | Data type | Allow NULLs | Default | Description |
|---|---|---|---|---|---|
| year | Primary Key | INT | ☐ | 0 | Primary key e.g. 1950 |
| url | VARCHAR(2048) | ☐ | Season Wikipedia page |
Table Relationships
This table has no foreign keys with any other tables
Where Used
Where is this table referenced and what columns are used? The below table shows that information.
[dbo.seasons]
| Parent_schemaName | Parent_tableName | Parent_columnName | Schema | table | column | constraint_name |
|---|---|---|---|---|---|---|
| dbo | seasons | year | dbo | driverNumbers | season | PK_driverNumbers_season |
| dbo | seasons | year | dbo | races | year | FK_Races_Year |
Example Query
SELECT
[year]
,[url]
FROM
[dbo].[seasons]
Example Output
| year | url |
|---|---|
| 1950 | http://en.wikipedia.org/wiki/1950_Formula_One_season |
| 1951 | http://en.wikipedia.org/wiki/1951_Formula_One_season |