Role&Policy

Tables (9)

OrganizationOwned? (Untitled8)

  • Key — Primary key — NOT NULL
  • Field
  • Field2 (bindingID)

ProjectOwned (Untitled2)

  • Key — Primary key — NOT NULL
  • Field (orgID)
  • Field (bindingID)

group (Untitled7)

  • Key (groupID) — Primary key — NOT NULL

member (Untitled6)

  • Key (memberID) — Primary key — NOT NULL
  • Field

permissions (Untitled3)

  • permissionID — Primary key — NOT NULL
  • 액션 (action)
  • 리소스 (resource)

principal (Untitled5)

  • principalID — bigint(20) — Primary key — NOT NULL
  • type (principalType) — principal이 될 수 있는 type - 그룹 - 멤버 - 유저 - 조직
  • Field

role (Untitled)

  • 역할ID (roleID) — bigint(20) — Primary key — NOT NULL
  • 제목 (title)
  • 설명 (description)
  • 액션 리스트 (actionList(includedPermissions))

role_binding (binding)

  • bindingID — Primary key — NOT NULL
  • 역할ID (roleID) — bigint(20) — Foreign key → role.역할ID — NOT NULL
  • principalID — bigint(20) — Foreign key → principal.principalID — NOT NULL
  • Field (orgID)

role_permissions (Untitled4)

  • 매핑ID (mappingID) — Primary key — NOT NULL
  • 역할ID (roleID) — bigint(20) — Foreign key → role.역할ID — NOT NULL
  • 액션ID (actionID) — Foreign key → permissions.permissionID — NOT NULL