Databases > WideWorldImporters > Tables > Sales.BuyingGroups

WideWorldImporters

Sales.BuyingGroups

//
Customer organizations can be part of groups that exert greater buying power

SYSTEM VERSIONED

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    BuyingGroupID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[BuyingGroupID])
  • //
    ${escapify(column.description)}
    BuyingGroupName
    [nvarchar](50) NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • ValidFrom
    [datetime2](8) NOT NULL
  • ValidTo
    [datetime2](8) NOT NULL

Indexes

  • PK_Sales_BuyingGroups
    UNIQUE CLUSTERED
    BuyingGroupID
  • UQ_Sales_BuyingGroups_BuyingGroupName
    UNIQUE NONCLUSTERED
    BuyingGroupName

Foreign Keys

  • FK_Sales_BuyingGroups_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

BuyingGroupID
BuyingGroupName
LastEditedBy
ValidFrom
ValidTo
1
Tailspin Toys
1
2
Wingtip Toys
1