ERD Schema of the FAB Database¶

Here is the current database schema diagram for the FAB auth manager provider tables.

Warning

The ER diagram shows the snapshot of the database structure valid for version 3.9.0 and it should be treated as an internal detail. It might be changed at any time and you should not directly access the database to retrieve information from it or modify the data. The main purpose of this diagram is to help with troubleshooting and understanding of the internal FAB DB architecture in case you have any problems with the database — for example when dealing with problems with migrations. See also Reference for Database Migrations for list of detailed database migrations.

        erDiagram
ab_group_role {
 INTEGER id PK
   INTEGER group_id FK
   INTEGER role_id FK
}
ab_permission_view_role {
 INTEGER id PK
   INTEGER permission_view_id FK
   INTEGER role_id FK
}
ab_user_role {
 INTEGER id PK
   INTEGER role_id FK
   INTEGER user_id FK
}
ab_user_group {
 INTEGER id PK
   INTEGER group_id FK
   INTEGER user_id FK
}
ab_permission {
 INTEGER id PK
   VARCHAR(100) name 
}
ab_view_menu {
 INTEGER id PK
   VARCHAR(250) name 
}
ab_role {
 INTEGER id PK
   VARCHAR(64) name 
}
ab_permission_view {
 INTEGER id PK
   INTEGER permission_id FK
   INTEGER view_menu_id FK
}
ab_group {
 INTEGER id PK
   VARCHAR(512) description 
   VARCHAR(150) label 
   VARCHAR(100) name 
}
ab_user {
 INTEGER id PK
   BOOLEAN active 
   INTEGER changed_by_fk FK
   DATETIME changed_on 
   INTEGER created_by_fk FK
   DATETIME created_on 
   VARCHAR(512) email 
   INTEGER fail_login_count 
   VARCHAR(256) first_name 
   DATETIME last_login 
   VARCHAR(256) last_name 
   INTEGER login_count 
   VARCHAR(256) password 
   VARCHAR(512) username 
}
ab_register_user {
 INTEGER id PK
   VARCHAR(512) email 
   VARCHAR(256) first_name 
   VARCHAR(256) last_name 
   VARCHAR(256) password 
   DATETIME registration_date 
   VARCHAR(256) registration_hash 
   VARCHAR(512) username 
}
ab_group one or zero--0+ ab_group_role : has
ab_role one or zero--0+ ab_group_role : has
ab_role one or zero--0+ ab_permission_view_role : has
ab_permission_view one or zero--0+ ab_permission_view_role : has
ab_user one or zero--0+ ab_user_role : has
ab_role one or zero--0+ ab_user_role : has
ab_group one or zero--0+ ab_user_group : has
ab_user one or zero--0+ ab_user_group : has
ab_view_menu 1--0+ ab_permission_view : has
ab_permission 1--0+ ab_permission_view : has
ab_user one or zero--0+ ab_user : has
ab_user one or zero--0+ ab_user : has