Purchasing.Vendor

Columns

• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  AccountNumber
  [AccountNumber] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](15) NULL
• //

  ${escapify(column.description)}
  Name
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  CreditRating
  [tinyint] NOT NULL

  //

  CONSTRAINT: Check constraint [CreditRating] BETWEEN (1) AND (5)

  ([CreditRating]>=(1) AND [CreditRating]<=(5))
• //

  ${escapify(column.description)}
  PreferredVendorStatus
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  ActiveFlag
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  PurchasingWebServiceURL
  [nvarchar](1024) NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Vendor_BusinessEntityID
  UNIQUE CLUSTERED
  BusinessEntityID
• //

  Unique nonclustered index.
  AK_Vendor_AccountNumber
  UNIQUE NONCLUSTERED
  AccountNumber

Foreign Keys

• //

  Foreign key constraint referencing BusinessEntity.BusinessEntityID
  FK_Vendor_BusinessEntity_BusinessEntityID
  Person.BusinessEntity
  BusinessEntityID ⥱ BusinessEntityID

Sample Data