Warehouse.Colors
Documentation | WideWorldImporters |
Schema | Warehouse |
Name | Colors |
Module | Warehouse |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ColorID | int | Default: NEXT VALUE FOR [Sequences].[ColorID] | Numeric ID used for reference to a color within the database | ||||
Numeric ID used for reference to a color within the database Default: NEXT VALUE FOR [Sequences].[ColorID] |
||||||||
2 | ColorName | nvarchar(20) | Full name of a color that can be used to describe stock items | |||||
Full name of a color that can be used to describe stock items |
||||||||
3 | LastEditedBy | int | Application.People | |||||
References: Application.People | ||||||||
4 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
5 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Warehouse.Colors | Application.People | Warehouse.Colors.LastEditedBy = Application.People.PersonID | FK_Warehouse_Colors_Application_People Foreign key constraint referencing People.PersonID |
|
Warehouse.Colors.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_Colors_Application_PeopleForeign key constraint referencing People.PersonID |
||||
Warehouse.StockItems | Warehouse.Colors | Warehouse.StockItems.ColorID = Warehouse.Colors.ColorID | FK_Warehouse_StockItems_ColorID_Warehouse_Colors Foreign key constraint referencing Colors.ColorID |
|
Warehouse.StockItems.ColorID = Warehouse.Colors.ColorID Name: FK_Warehouse_StockItems_ColorID_Warehouse_ColorsForeign key constraint referencing Colors.ColorID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Warehouse_Colors | ColorID | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. | |||
UQ_Warehouse_Colors_ColorName | ColorName | Unique nonclustered index. | |
Unique nonclustered index. |
Uses
Name |
---|
Warehouse.Colors
|
Used by
Name |
---|
Warehouse.Colors
|
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51