Status

[dbo.status]

Column name	Key	Data type	Allow NULLs	Default	Description
statusId	Primary Key	INT	☐
status		VARCHAR(255)	☐		Finishing status e.g. "Retired"

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.status]

Parent_schemaName	Parent_tableName	Parent_columnName	Schema	table	column	constraint_name
dbo	status	statusId	dbo	results	statusId	FK_Results_StatusID

Example Query

SELECT 
    [statusId]
    ,[status]
FROM 
    [dbo].[status]

Example Output

statusId	status
1	Finished
2	Disqualified