Skip to content

Latest commit

 

History

History
35 lines (24 loc) · 1.31 KB

File metadata and controls

35 lines (24 loc) · 1.31 KB

FeatureGroupKeysLookup

Description

Columns

Name Type Default Nullable Children Parents Comment
GroupKey_Lowercase STRING(64) false
WebFeatureID STRING(36) false WebFeatures
GroupID STRING(36) false WebDXGroups
Depth INT64 false

Constraints

Name Type Definition
PRIMARY_KEY PRIMARY_KEY PRIMARY KEY(GroupKey_Lowercase, WebFeatureID)
FK_FeatureGroupKeysLookup_GroupID FOREIGN KEY FOREIGN KEY (GroupID) REFERENCES WebDXGroups (ID) ON DELETE CASCADE
FK_FeatureGroupKeysLookup_WebFeatureID FOREIGN KEY FOREIGN KEY (WebFeatureID) REFERENCES WebFeatures (ID) ON DELETE CASCADE

Indexes

Name Definition
IDX_FeatureGroupKeysLookup_GroupID_0D78392F3EC61CA8 CREATE INDEX IDX_FeatureGroupKeysLookup_GroupID_0D78392F3EC61CA8 ON FeatureGroupKeysLookup (GroupID)
IDX_FeatureGroupKeysLookup_WebFeatureID_859124609C6B5A67 CREATE INDEX IDX_FeatureGroupKeysLookup_WebFeatureID_859124609C6B5A67 ON FeatureGroupKeysLookup (WebFeatureID)

Relations

er


Generated by tbls