Databases > WideWorldImporters > Tables > Application.PaymentMethods

WideWorldImporters

Application.PaymentMethods

//
Ways that payments can be made (ie: cash, check, EFT, etc.

SYSTEM VERSIONED

Created: Modified:

Columns

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

Indexes

  • PK_Application_PaymentMethods
    UNIQUE CLUSTERED
    PaymentMethodID
  • UQ_Application_PaymentMethods_PaymentMethodName
    UNIQUE NONCLUSTERED
    PaymentMethodName

Foreign Keys

  • FK_Application_PaymentMethods_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

PaymentMethodID
PaymentMethodName
LastEditedBy
ValidFrom
ValidTo
1
Cash
1
2
Check
1
3
Credit-Card
9
4
EFT
1