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