DATABASESPACEUSEDHISTORY

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
BUSINESSPROCESSSTATUSID uniqueidentifier
ASOF datetimeoffset Default = sysdatetimeoffset()
TYPECODE tinyint Default = 0
TYPE nvarchar(24) (Computed) yes CASE [TYPECODE] WHEN 0 THEN N'Other data' WHEN 1 THEN N'Application data' WHEN 2 THEN N'Static selections' WHEN 3 THEN N'Business process history' WHEN 4 THEN N'System tables' WHEN 5 THEN N'Customization data' WHEN 6 THEN N'Audit data' END
SUBTYPECODE tinyint Default = 0
SUBTYPE nvarchar(30) (Computed) yes CASE [SUBTYPECODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Transactional data' WHEN 2 THEN N'Attribute data' WHEN 3 THEN N'Marketing effort data' WHEN 4 THEN N'Smart field calculations' WHEN 5 THEN N'Generic selections' WHEN 6 THEN N'Imported selections' WHEN 7 THEN N'Selections from query' WHEN 8 THEN N'Other output' WHEN 9 THEN N'Batch output' WHEN 10 THEN N'Export output' WHEN 11 THEN N'Marketing effort export output' END
ROWS bigint Default = ((0))
RESERVEDKB bigint Default = ((0))
DATAKB bigint Default = ((0))
INDEXKB bigint Default = ((0))
UNUSEDKB bigint Default = ((0))

Indexes

Index Name Fields Unique Primary Clustered
IX_DATABASESPACEUSEDHISTORY_BUSINESSPROCESSSTATUSID BUSINESSPROCESSSTATUSID
PK_DATABASESPACEUSEDHISTORY ID yes yes yes