FEATUREGROUPFEATURE

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
FEATUREID	uniqueidentifier
FEATURETYPECODE	tinyint		Default = 0
FEATURETYPE	nvarchar(18) (Computed)	yes	CASE [FEATURETYPECODE] WHEN 0 THEN N'Batch type' WHEN 1 THEN N'Business process' WHEN 2 THEN N'Code table' WHEN 3 THEN N'Dashboard' WHEN 4 THEN N'Data form instance' WHEN 5 THEN N'KPI' WHEN 6 THEN N'Map entity' WHEN 7 THEN N'Data list' WHEN 8 THEN N'Query view' WHEN 9 THEN N'Record operation' WHEN 10 THEN N'Report' WHEN 11 THEN N'Search list' WHEN 12 THEN N'Smart query' WHEN 13 THEN N'System privilege' WHEN 14 THEN N'Task' END

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
FEATUREGROUPCATALOGID	uniqueidentifier		FEATUREGROUPCATALOG.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FEATUREGROUPFEATURE	ID	yes	yes	yes
UIX_FEATUREGROUPFEATURE_FEATURETYPECODE_FEATUREID_FEATUREGROUPCATALOGID	FEATURETYPECODE, FEATUREID, FEATUREGROUPCATALOGID	yes