Tables [dbo].[RTLeases]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created11:24:48 AM Wednesday, May 9, 2018
Last Modified11:24:48 AM Wednesday, May 9, 2018
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_RTLeases: UserID\FeatureIDUserIDvarchar(32)32
False
Cluster Primary Key PK_RTLeases: UserID\FeatureIDFeatureIDint4
False
IssueTimedatetime8
False
ExpirationTimedatetime8
False
LastUpdatedatetime8
False
UniqueIDvarchar(4096)4096
False
CompanyIDvarchar(255)255
False
ClientTypechar(3)3
False
Activebit1
False
RowHashvarchar(32)32
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_RTLeases: UserID\FeatureIDPK_RTLeasesUserID, FeatureID
True
CREATE TABLE [dbo].[RTLeases]
(
[UserID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FeatureID] [int] NOT NULL,
[IssueTime] [datetime] NOT NULL,
[ExpirationTime] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[UniqueID] [varchar] (4096) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CompanyID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ClientType] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[RowHash] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTLeases] ADD CONSTRAINT [PK_RTLeases] PRIMARY KEY CLUSTERED  ([UserID], [FeatureID]) ON [PRIMARY]
GO