DATABASESPACEUSED

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
SCHEMANAME	nvarchar(128)		Default = ''
NAME	nvarchar(128)		Default = ''
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 tables' 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	int		Default = 0
RESERVEDKB	int		Default = 0
DATAKB	int		Default = 0
INDEXKB	int		Default = 0
UNUSEDKB	int		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
TABLECATALOGID	uniqueidentifier	yes	TABLECATALOG.ID
BUSINESSPROCESSOUTPUTID	uniqueidentifier	yes	BUSINESSPROCESSOUTPUT.ID
IDSETREGISTERID	uniqueidentifier	yes	IDSETREGISTER.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DATABASESPACEUSED	ID	yes	yes	yes
UIX_DATABASESPACEUSED_BUSINESSPROCESSOUTPUTID	BUSINESSPROCESSOUTPUTID	yes
UIX_DATABASESPACEUSED_IDSETREGISTERID	IDSETREGISTERID	yes
UIX_DATABASESPACEUSED_SCHEMANAME_NAME	SCHEMANAME, NAME	yes