| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 FEATUREID |
uniqueidentifier | |||
| FEATURETYPECODE |
tinyint | Default = 0 | ||
 FEATURETYPE |
nvarchar(18) (Computed) |  |
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 Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 FEATUREGROUPCATALOGID |
uniqueidentifier | FEATUREGROUPCATALOG.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_FEATUREGROUPFEATURE |
ID | |
|
|
 UIX_FEATUREGROUPFEATURE_FEATURETYPECODE_FEATUREID_FEATUREGROUPCATALOGID |
FEATURETYPECODE, FEATUREID, FEATUREGROUPCATALOGID | |