docs.ForeignKey_RelationScript - V

CREATE View docs.ForeignKey_RelationScript
As
--
Select
    --
    DbmlRelation = Concat (
                              'Ref '
                            , ForeignKey_name
                            , ': '
                            , QuoteName ( referencing_RepoObject_fullname, '"' )
                            , '.('
                            , referencing_IndexPatternColumnName
                            , ')'
                            --<: one-to-many. E.g: users.id < posts.user_id
                            -->: many-to-one. E.g: posts.user_id > users.id
                            ---: one-to-one. E.g: users.id - user_infos.user_id
                            , ' > '
                            , QuoteName ( referenced_RepoObject_fullname, '"' )
                            , '.('
                            , referenced_IndexPatternColumnName
                            , ')'
                            , '[delete: '
                            , Case delete_referential_action
                                  When 0
                                      Then
                                      'no action'
                                  When 1
                                      Then
                                      'Cascade'
                                  When 2
                                      Then
                                      'Set null'
                                  When 3
                                      Then
                                      'Set default'
                              End
                            , ', update: '
                            , Case update_referential_action
                                  When 0
                                      Then
                                      'no action'
                                  When 1
                                      Then
                                      'Cascade'
                                  When 2
                                      Then
                                      'Set null'
                                  When 3
                                      Then
                                      'Set default'
                              End
                            , ']'
                          )
  , referenced_RepoObject_fullname
  , referenced_RepoObject_guid
  , referencing_RepoObject_fullname
  , referencing_RepoObject_guid
--, [ForeignKey_guid]
--, [is_MatchingDatatypePattern]
--, [ForeignKey_name]
--, [ForeignKey_fullname]
--, [referenced_index_guid]
--, [referenced_IndexPatternColumnDatatype]
--, [referenced_IndexPatternColumnName]
--, [referencing_index_guid]
--, [referencing_IndexPatternColumnDatatype]
--, [referencing_IndexPatternColumnName]
--, [delete_referential_action]
--, [update_referential_action]
From
    repo.ForeignKey_Indexes_union_T
Where
    Not referenced_index_guid Is Null
    And Not referencing_index_guid Is Null