Purchasing.SupplierCategories
Documentation | WideWorldImporters |
Schema | Purchasing |
Name | SupplierCategories |
Module | Purchasing |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | SupplierCategoryID | int | Default: NEXT VALUE FOR [Sequences].[SupplierCategoryID] | Numeric ID used for reference to a supplier category within the database | ||||
Numeric ID used for reference to a supplier category within the database Default: NEXT VALUE FOR [Sequences].[SupplierCategoryID] |
||||||||
2 | SupplierCategoryName | nvarchar(50) | Full name of the category that suppliers can be assigned to | |||||
Full name of the category that suppliers can be assigned to |
||||||||
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 | |
---|---|---|---|---|
Purchasing.SupplierCategories | Application.People | Purchasing.SupplierCategories.LastEditedBy = Application.People.PersonID | FK_Purchasing_SupplierCategories_Application_People Foreign key constraint referencing People.PersonID |
|
Purchasing.SupplierCategories.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_SupplierCategories_Application_PeopleForeign key constraint referencing People.PersonID |
||||
Purchasing.Suppliers | Purchasing.SupplierCategories | Purchasing.Suppliers.SupplierCategoryID = Purchasing.SupplierCategories.SupplierCategoryID | FK_Purchasing_Suppliers_SupplierCategoryID_Purchasing_SupplierCategories Foreign key constraint referencing SupplierCategories.SupplierCategoryID |
|
Purchasing.Suppliers.SupplierCategoryID = Purchasing.SupplierCategories.SupplierCategoryID Name: FK_Purchasing_Suppliers_SupplierCategoryID_Purchasing_SupplierCategoriesForeign key constraint referencing SupplierCategories.SupplierCategoryID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Purchasing_SupplierCategories | SupplierCategoryID | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. | |||
UQ_Purchasing_SupplierCategories_SupplierCategoryName | SupplierCategoryName | Unique nonclustered index. | |
Unique nonclustered index. |
Uses
Name |
---|
Purchasing.SupplierCategories
|
Used by
Name |
---|
Purchasing.SupplierCategories
|
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51