Lookup table for request handler roles, referenced by account_role.

Definition:

   Column    |       Type        | Collation | Nullable | Default

-------------+-------------------+-----------+----------+---------

 role_no     | numeric           |           | not null |

 version     | numeric           |           | not null |

 application | character varying |           | not null |

 name        | character varying |           | not null |

 parent_role | numeric           |           |          |

Indexes:

    "role_pkey" PRIMARY KEY, btree (role_no)

    "role_application_name_key" UNIQUE CONSTRAINT, btree (application, name)

Foreign-key constraints:

    "role_parent_role_fkey" FOREIGN KEY (parent_role) REFERENCES role(role_no)

Referenced by:

    TABLE "account_role" CONSTRAINT "fk_rh_role_no" FOREIGN KEY (role_no) REFERENCES role(role_no)

    TABLE "role" CONSTRAINT "role_parent_role_fkey" FOREIGN KEY (parent_role) REFERENCES role(role_no)

Columns:

role_no: primary key

version: ? values: 1, 8

application: ? values: ARCHIVE, MASTER, RH

name: role name. values: ARCHIVE_OPERATOR, FULL_ACCESS_USER, USER

parent_role: ? not populated