IAM
Tables (13)
actions
- id — uuid
- name — varchar(255)
group_role
- group_id — uuid — Foreign key → groups.id
- role_id — uuid — Foreign key → roles.id
groups
- id — uuid
- name — varchar(255)
- organization_id — integer — Foreign key → organizations.id
organizations
- id — integer
- name — varchar(255)
policies
- id — uuid
- name — varchar(255)
policy_action
- policy_id — uuid — Foreign key → policies.id
- action_id — uuid — Foreign key → actions.id
project_role
- project_id — integer — Foreign key → projects.id
- role_id — uuid — Foreign key → roles.id
projects
- id — integer
- name — varchar(255)
- organization_id — integer — Foreign key → organizations.id
role_permission
- role_id — uuid — Foreign key → roles.id
- policy_id — uuid — Foreign key → policies.id
roles
- id — uuid
- name — varchar(255)
user_group
- user_id — uuid — Foreign key → users.id
- group_id — uuid — Foreign key → groups.id
user_role
- user_id — uuid — Foreign key → users.id
- role_id — uuid — Foreign key → roles.id
users
- id — uuid
- username — varchar(255)
- email — varchar(255)
- password — varchar(255)
- organization_id — integer — Foreign key → organizations.id
- created_at — timestamp