Tables [dbo].[WebARCustomersUsers]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:57 AM Thursday, March 21, 2019
Last Modified1:16:23 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Indexes IX_WebARCustomersUsers_CustomerIDForeign Keys FK_WebARCustomersUsers_CustomerID_WebARCustomerFeatures: [dbo].[WebARCustomerFeatures].CustomerIDCustomerIDint4
False
Indexes IX_WebARCustomersUsers_CustomerIDPasswordvarchar(32)32
True
Featuresint4
True
Cluster Primary Key PK_WebARCustomersUsers: WebARCustomerIDWebARCustomerIDint4
False
1 - 1
CreateDatedatetime8
False
(getdate())
EncTypeint4
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_WebARCustomersUsers: WebARCustomerIDPK_WebARCustomersUsersWebARCustomerID
True
80
IX_WebARCustomersUsers_CustomerIDCustomerID, Password
True
80
NameColumns
FK_WebARCustomersUsers_CustomerID_WebARCustomerFeaturesCustomerID->[dbo].[WebARCustomerFeatures].[CustomerID]
CREATE TABLE [dbo].[WebARCustomersUsers]
(
[CustomerID] [int] NOT NULL,
[Password] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Features] [int] NULL,
[WebARCustomerID] [int] NOT NULL IDENTITY(1, 1),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_WebARCustomersUsers_CreateDate] DEFAULT (getdate()),
[EncType] [int] NOT NULL CONSTRAINT [DF_WebARCustomersUsers_EncType] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebARCustomersUsers] ADD CONSTRAINT [PK_WebARCustomersUsers] PRIMARY KEY CLUSTERED  ([WebARCustomerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebARCustomersUsers] ADD CONSTRAINT [IX_WebARCustomersUsers_CustomerID] UNIQUE NONCLUSTERED  ([CustomerID], [Password]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebARCustomersUsers] ADD CONSTRAINT [FK_WebARCustomersUsers_CustomerID_WebARCustomerFeatures] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[WebARCustomerFeatures] ([CustomerID])
GO