CREATE TABLE [dbo].[ARChargeAccounts]
(
[ChargeAccountID] [int] NOT NULL IDENTITY(1, 1),
[ChargeAccountTypeID] [int] NOT NULL,
[CustomerID] [int] NOT NULL,
[Name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BnCdNumber] [varbinary] (32) NOT NULL,
[CardNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ExpDate] [datetime] NOT NULL,
[SecurityCode] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_ARChargeAccounts_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ARChargeAccounts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARChargeAccounts_LastUpdate] DEFAULT (getdate()),
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccounts_Remarks] DEFAULT (''),
[BnRoutingNumber] [varbinary] (32) NOT NULL CONSTRAINT [DF_ARChargeAccounts_BnRoutingNumber] DEFAULT (CONVERT([varbinary],'',(0))),
[RoutingNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccounts_RoutingNumber] DEFAULT (''),
[BankName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccounts_BankName] DEFAULT (''),
[BnPaymentAccountID] [varbinary] (64) NOT NULL CONSTRAINT [DF_ARChargeAccounts_BnPaymentAccountID] DEFAULT ((0)),
[CCVaultID] [int] NULL,
[Phone] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccounts_Phone] DEFAULT (''),
[Nickname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccounts_Nickname] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARChargeAccounts] ADD CONSTRAINT [PK_ARChargeAccounts] PRIMARY KEY CLUSTERED ([ChargeAccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARChargeAccounts] ADD CONSTRAINT [FK_ARChargeAccounts_CCVaultID_ARCCVaults] FOREIGN KEY ([CCVaultID]) REFERENCES [dbo].[ARCCVaults] ([CCVaultID])
GO
ALTER TABLE [dbo].[ARChargeAccounts] ADD CONSTRAINT [FK_ARChargeAccounts_ChargeAccountTypeID_ARChargeAccountTypes] FOREIGN KEY ([ChargeAccountTypeID]) REFERENCES [dbo].[ARChargeAccountTypes] ([ChargeAccountTypeID])
GO
ALTER TABLE [dbo].[ARChargeAccounts] ADD CONSTRAINT [FK_ARChargeAccounts_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO