Application.TransactionTypes
Documentation | WideWorldImporters |
Schema | Application |
Name | TransactionTypes |
Module | Application |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | TransactionTypeID | int | Default: NEXT VALUE FOR [Sequences].[TransactionTypeID] | Numeric ID used for reference to a transaction type within the database | ||||
Numeric ID used for reference to a transaction type within the database Default: NEXT VALUE FOR [Sequences].[TransactionTypeID] |
||||||||
2 | TransactionTypeName | nvarchar(50) | Full name of the transaction type | |||||
Full name of the transaction type |
||||||||
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 | |
---|---|---|---|---|
Application.TransactionTypes | Application.People | Application.TransactionTypes.LastEditedBy = Application.People.PersonID | FK_Application_TransactionTypes_Application_People Foreign key constraint referencing People.PersonID |
|
Application.TransactionTypes.LastEditedBy = Application.People.PersonID Name: FK_Application_TransactionTypes_Application_PeopleForeign key constraint referencing People.PersonID |
||||
Sales.CustomerTransactions | Application.TransactionTypes | Sales.CustomerTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID | FK_Sales_CustomerTransactions_TransactionTypeID_Application_TransactionTypes Foreign key constraint referencing TransactionTypes.TransactionTypeID |
|
Sales.CustomerTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID Name: FK_Sales_CustomerTransactions_TransactionTypeID_Application_TransactionTypesForeign key constraint referencing TransactionTypes.TransactionTypeID |
||||
Warehouse.StockItemTransactions | Application.TransactionTypes | Warehouse.StockItemTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID | FK_Warehouse_StockItemTransactions_TransactionTypeID_Application_TransactionTypes Foreign key constraint referencing TransactionTypes.TransactionTypeID |
|
Warehouse.StockItemTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID Name: FK_Warehouse_StockItemTransactions_TransactionTypeID_Application_TransactionTypesForeign key constraint referencing TransactionTypes.TransactionTypeID |
||||
Purchasing.SupplierTransactions | Application.TransactionTypes | Purchasing.SupplierTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID | FK_Purchasing_SupplierTransactions_TransactionTypeID_Application_TransactionTypes Foreign key constraint referencing TransactionTypes.TransactionTypeID |
|
Purchasing.SupplierTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID Name: FK_Purchasing_SupplierTransactions_TransactionTypeID_Application_TransactionTypesForeign key constraint referencing TransactionTypes.TransactionTypeID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Application_TransactionTypes | TransactionTypeID | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. | |||
UQ_Application_TransactionTypes_TransactionTypeName | TransactionTypeName | Unique nonclustered index. | |
Unique nonclustered index. |
Uses
Name |
---|
Application.TransactionTypes
|
Used by
Name |
---|
Application.TransactionTypes
|
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51