Tables [dbo].[BackupAC]
PropertyValue
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:01 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_BackupAC_AccountID: AccountIDAccountIDint4
False
IsDealerbit1
False
PrimaryContactIDint4
True
OwnerContactIDint4
True
AdminContactIDint4
True
SupportContactIDint4
True
ServiceContactIDint4
True
SuppliesContactIDint4
True
BillingContactIDint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_BackupAC_AccountID: AccountIDPK_BackupAC_AccountIDAccountID
True
CREATE TABLE [dbo].[BackupAC]
(
[AccountID] [int] NOT NULL,
[IsDealer] [bit] NOT NULL,
[PrimaryContactID] [int] NULL,
[OwnerContactID] [int] NULL,
[AdminContactID] [int] NULL,
[SupportContactID] [int] NULL,
[ServiceContactID] [int] NULL,
[SuppliesContactID] [int] NULL,
[BillingContactID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BackupAC] ADD CONSTRAINT [PK_BackupAC_AccountID] PRIMARY KEY CLUSTERED  ([AccountID]) ON [PRIMARY]
GO