Tables [dbo].[LMLS_History]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)219
Created11:24:30 AM Wednesday, May 9, 2018
Last Modified11:24:30 AM Wednesday, May 9, 2018
NameData TypeMax Length (Bytes)Allow NullsDefault
HistoryIDint4
False
LeaseIDint4
False
LeaseTypevarchar(32)32
True
Featureint4
False
CreateTimedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
DeleteTimedatetime8
True
IPvarchar(64)64
True
UniqueIDvarchar(4096)4096
False
UserIDvarchar(32)32
False
CompanyIDvarchar(255)255
False
('')
CREATE TABLE [dbo].[LMLS_History]
(
[HistoryID] [int] NOT NULL,
[LeaseID] [int] NOT NULL,
[LeaseType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Feature] [int] NOT NULL,
[CreateTime] [datetime] NOT NULL CONSTRAINT [DF_LMLS_HISTORY_CREATETIME] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_LMLS_HISTORY_LASTUPDATE] DEFAULT (getdate()),
[DeleteTime] [datetime] NULL,
[IP] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UniqueID] [varchar] (4096) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CompanyID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LMLS_HISTORY_COMPANYID] DEFAULT ('')
) ON [PRIMARY]
GO