Arquitectura de Datos Directus

                    
            erDiagram
                DIRECTUS_ROLES {
                    uuid id PK
                    varchar name
                    varchar icon
                    text description
                    uuid parent FK
                }
            
                DIRECTUS_POLICIES {
                    uuid id PK
                    varchar name
                    varchar icon
                    text description
                    text ip_access
                    boolean enforce_tfa
                    boolean admin_access
                    boolean app_access
                }
            
                DIRECTUS_ACCESS {
                    uuid id PK
                    uuid role FK
                    uuid user FK
                    uuid policy FK
                    int sort
                }
            
                DIRECTUS_PERMISSIONS {
                    int id PK
                    varchar collection
                    varchar action
                    json permissions
                    json validation
                    json presets
                    text fields
                    uuid policy FK
                }
            
                DIRECTUS_USERS {
                    uuid id PK
                    varchar email UK
                    uuid role FK
                    text first_name
                    text last_name
                    varchar status
                    text vendedor_id
                }
            
                DIRECTUS_COLLECTIONS {
                    varchar collection PK
                    boolean singleton
                    boolean hidden
                    varchar group FK
                }
            
                DIRECTUS_FIELDS {
                    int id PK
                    varchar collection
                    varchar field
                    varchar interface
                    boolean hidden
                    boolean required
                    boolean readonly
                }
            
                DIRECTUS_RELATIONS {
                    int id PK
                    varchar many_collection
                    varchar many_field
                    varchar one_collection
                    varchar one_field
                    varchar one_collection_field
                    varchar one_deselect_action
                }
            
                DIRECTUS_ROLES ||--o{ DIRECTUS_ACCESS : "role"
                DIRECTUS_USERS ||--o{ DIRECTUS_ACCESS : "user"
                DIRECTUS_POLICIES ||--o{ DIRECTUS_ACCESS : "policy"
                DIRECTUS_POLICIES ||--o{ DIRECTUS_PERMISSIONS : "policy"
                DIRECTUS_USERS }o--|| DIRECTUS_ROLES : "role"
            
                DIRECTUS_COLLECTIONS ||--o{ DIRECTUS_FIELDS : "collection"
                DIRECTUS_COLLECTIONS ||--o{ DIRECTUS_RELATIONS : "many_collection / one_collection"
            
                DIRECTUS_ACCESS }o--|| DIRECTUS_USERS : "user"