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.10.2 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_role one or zero--0+ ab_group_role : has ab_group 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_role one or zero--0+ ab_user_role : has ab_user 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_permission 1--0+ ab_permission_view : has ab_view_menu 1--0+ ab_permission_view : has ab_user one or zero--0+ ab_user : has ab_user one or zero--0+ ab_user : has

Was this entry helpful?