View presenting relation types with translated names and reverse type references.
Definition
CREATE VIEW
[mr].[Relation_Type] AS
SELECT
[rt].[Relation_Type_Id],
[rt].[Enum_Key] [Relation_Type_Key],
[ta].[Translation] [Relation_Type],
[rt].[Is_Oriented],
[rt].[Reverse_Relation_Type_Id],
[rrt].[Enum_Key] Reverse_Relation_Type_Key,
[t].[Translation] Reverse_Relation_Type
FROM
[dbo].[C_Relation_Type] [rt]
LEFT JOIN [fw].[Translation] [ta] ON [ta].[Translation_key] = [rt].[Name_Key]
LEFT JOIN [dbo].[C_Relation_Type] rrt ON rrt.[Relation_Type_Id] = rt.[Reverse_Relation_Type_Id]
LEFT JOIN [fw].[Translation] [t] ON [t].[Translation_key] = [rrt].[Name_Key]
Columns
Is Data Source For
| View | Columns |
|---|
| Relation | Relation_Type_Key, Relation_Type |