[WiP][SIP-125] Proposal for Enhanced Data Access Permissions about superset HOT 4 CLOSED

@startuml Superset Data Access Models
title SIP #125 - Superset Data Access Models


' hide the spot
' hide circle

' avoid problems with angled crows feet
skinparam linetype ortho
!theme blueprint

'left to right direction
scale 4


package "FAB Security Models" #black {

    entity "User" as user {
        *id: number <<generated>>
        --
        uuid
        *name : text
    }

    entity "Group" as group {
        *id: number <<generated>>
        --
        uuid
        *name : text
    }

    entity "Role" as role {
        *id: number <<generated>>
        --
        uuid
        *name : text
    }
    entity "Permission" as fab_permission {
        *id: number <<generated>>
        --
        uuid
        *name : text
    } 
    entity "ViewMenu" as fab_viewmenu{
        *id: number <<generated>>
        --
        uuid
        *name : text
    } 
    entity "PermissionView" as fab_permission_view{
        *id: number <<generated>>
        --
        uuid
        *name : text
    } 
}
package "New Data Access Models" #black {
    entity "Verb" as verb {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }

    entity "DataAccessRole" as data_access_role {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }

    entity "DataPermission" as data_permission {
        *data_perm_id: number <<generated>>
        --
        uuid
        verb: str
        entity: str
        object_id: int
    }
}
package "Database Models" #Black {

    entity "DatabaseCatalog" as catalog {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }
    entity "Schema" as schema {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }
    entity "RLS" as rls {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }
    entity "DatabaseConnection" as database_connection {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }

    entity "Dataset" as dataset {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }
}
package "Other Models" #Black {
    entity "Dashboard" as dashboard {
        *user_id : number <<generated>>
        --
        uuid
        *name : text
    }
}


database_connection ||..|{ catalog
database_connection ||..|{ schema 
catalog ||..|{ schema 
schema ||..|{ dataset
dataset ||..|{ rls

data_access_role }|..|{ data_permission
verb ||..|{ data_permission
data_permission }|..|{ database_connection
data_permission }|..|{ dashboard

data_permission }|..|{ dataset
data_permission }|..|{ schema


user }|..|{ group
user }|..|{ role
group }|..|{ role
fab_permission ||..|{ fab_permission_view 
fab_viewmenu ||..|{ fab_permission_view 

fab_permission_view }|..|{ role 

user }|..|{ data_access_role
group }|..|{ data_access_role

@enduml