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"