vzAclResource:
  tableName: vz_acl_resources
  columns:
    identifier: string(255)
  indexes:
    identifier_index:
      fields: [identifier]
      type: unique
  relations:
    Privileges:
      class: vzAclPrivilege
      local: resource_id
      foreign: privilege_id
      refClass: vzAclResources2Privileges
      
vzAclResources2Privileges:
  tableName: vz_acl_resources_to_privileges
  columns:
    resource_id:
      type: integer
      primary: true
    privilege_id:
      type: integer
      primary: true
  relations:
    Resource:
      class: vzAclResource
      local: resource_id
      foreign: id
      type: one
      onDelete: CASCADE
    Privilege:
      class: vzAclPrivilege
      local: privilege_id
      foreign: id
      type: one
      onDelete: CASCADE
      
vzAclPrivilege:
  tableName: vz_acl_privileges
  columns:
    name: string(255)
    description: clob
  indexes:
    name_index:
      fields: [name]
      type: unique
  relations:
    Roles:
      class: vzAclRole
      local: privilege_id
      foreign: role_id
      refClass: vzAclPrivileges2Roles
      
vzAclPrivileges2Roles:
  tableName: vz_acl_privileges_to_roles
  columns:
    privilege_id:
      type: integer
      primary: true
    role_id:
      type: integer
      primary: true
  relations:
    Privilege:
      class: vzAclPrivilege
      local: privilege_id
      foreign: id
      type: one
      onDelete: CASCADE
    Role:
      class: vzAclRole
      local: role_id
      foreign: id
      type: one
      onDelete: CASCADE
    
vzAclRole:
  tableName: vz_acl_role
  columns:
    name: string(255)
  indexes:
    name_index:
      fields: [name]
      type: unique
  relations:
    Privileges:
      class: vzAclPrivilege
      local: role_id
      foreign: privilege_id
      refClass: vzAclPrivileges2Roles