accounts

Tables (7)

ACTIONS

  • SERVICE_ID — STRING — Primary key — NOT NULL
  • ACTIONS — JSON ARRAY

GRANTED_ROLE

  • USER_ID — STRING — Primary key — NOT NULL
  • SERVICE_ID — STRING — Primary key — NOT NULL
  • ROLES — ARRAY

ORG_GRANTEND_ROLE

  • ID — VARCHAR — Primary key — NOT NULL
  • ORG_ID — VARCHAR
  • TARGET_TYPE — VARCHAR
  • TARGET_VALUE — VARCHAR
  • ROLE_IDS — VARCHAR

ORG_ROLES

  • ORG_ID — VARCHAR — Primary key — NOT NULL
  • ROLE_ID — VARCHAR — Primary key — NOT NULL

ROLES

  • ID — STRING — Primary key — NOT NULL
  • SERVICE_ID — STRING
  • POLICY — JSON
  • TYPE — STRING
  • NAME — STRING

SERVICES

  • ORG_ID — VARCHAR — Primary key — NOT NULL
  • SERVICE_ID — VARCHAR — Primary key — NOT NULL

USERS

  • ID — VARCHAR — Primary key — NOT NULL
  • ORGANIZATION_ID — VARCHAR — Primary key — NOT NULL