CREATE TABLE [dbo].[Payment] (
    [PaymentID]  INT         IDENTITY (1, 1) NOT NULL,
    [CardNumber] NCHAR (16)  NOT NULL,
    [CardExpiry] NCHAR (10)  NOT NULL,
    [Name]       NCHAR (50)  NOT NULL,
    [Address]    NCHAR (100) NOT NULL,
    [Postal]     NCHAR (6)   NOT NULL,
    [Order_ID]   NCHAR (50)  NULL,
    PRIMARY KEY CLUSTERED ([PaymentID] ASC)