Tables [dbo].[ARQFinChargeDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:59 AM Thursday, March 21, 2019
Last Modified1:10:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ARQFinChargeDetails: CustomerIDForeign Keys FK_ARQFinChargeDetails_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
AverageDailymoney8
False
CalcAmountmoney8
False
Amountmoney8
False
Forgivenbit1
False
DoFinChargesbit1
False
Notesvarchar(4096)4096
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ARQFinChargeDetails: CustomerIDPK_ARQFinChargeDetailsCustomerID
True
80
NameNo CheckColumns
FK_ARQFinChargeDetails_CustomerID_ARCustomers
True
CustomerID->[dbo].[ARCustomers].[CustomerID]
CREATE TABLE [dbo].[ARQFinChargeDetails]
(
[CustomerID] [int] NOT NULL,
[AverageDaily] [money] NOT NULL,
[CalcAmount] [money] NOT NULL,
[Amount] [money] NOT NULL,
[Forgiven] [bit] NOT NULL,
[DoFinCharges] [bit] NOT NULL,
[Notes] [varchar] (4096) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARQFinChargeDetails_Notes] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARQFinChargeDetails] ADD CONSTRAINT [PK_ARQFinChargeDetails] PRIMARY KEY CLUSTERED  ([CustomerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARQFinChargeDetails] WITH NOCHECK ADD CONSTRAINT [FK_ARQFinChargeDetails_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO