Auth entities

[wasd0]

Rows:

roles:

• user
• system
• admin
• moderator
• blocked

permissions:

• user
• role
• permission
• movie

permission levels:

• 0 denied
• 1 read
• 2 create
• 4 edit
• 8 delete

Tables

permissions:

columns:

• id bigserial pk
• name varchar(50) not null
• description varchar(100)
• default_level_id fk level (id) default 1

permission level:

• id small int pk
• name

roles_permissions

• role_id bigint pk fk
• permission_id bigint pk fk
• target_level small int fk not null
• global_level small int fk not null
• check unique (role_id, permission)

users roles:

• user_id uuid pk
• role_id bigint pk
• date_active timestamptz not null

users_permissions:

• user_id uuid pk
• permission_id pk
• cause varchar(250)
• target_level fk not null
• global_level fk not null
• date_expire timestamptz

[wasd0]

SUB TASK: #16