Payment

CREATE TABLE [dbo].[Payment]

([payment_id] [varchar](18) NOT NULL, [amount] [int] NULL, [payment_date] [date] NULL, [payment_method_id] [varchar](18) NULL, [payment_status] [varchar](18) NULL, [order_id] [varchar](18) NULL)

CREATE TABLE [dbo].[PaymentMethods]

([payment_method_id] [varchar](18) NOT NULL, [cardholder_name] [text] NULL, [card_number] [varchar](25) NULL, [card_type] [varchar](18) NULL,[expiration_date] [date] NULL,[three_digit_code] [int] NULL, [holder_addr1] [varchar](255) NULL, [holder_addr2] [varchar](255) NULL, [holder_city] [varchar](50) NULL, [holder_state] [varchar](50) NULL, [holder_zipcode] [int] NULL, [holder_email] [varchar](255) NULL, [method_status] [varchar](18) NULL, [contact_id] [varchar](18) NULL)