role_permission_entity Struct Reference

Represents a role-permission assignment in the database. More...

#include <role_permission_entity.hpp>

Collaboration diagram for role_permission_entity:

Public Attributes
std::string	role_id
std::string	permission_id
sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">	valid_from = "9999-12-31 23:59:59"
sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">	valid_to = "9999-12-31 23:59:59"

Static Public Attributes
static constexpr const char *	schema = "oresdb"
static constexpr const char *	tablename = "role_permissions"

Detailed Description

Represents a role-permission assignment in the database.

This is a junction table linking roles to permissions in a many-to-many relationship. A role can have multiple permissions, and a permission can be assigned to multiple roles.

Note: The actual primary key is a composite key (role_id, permission_id, valid_from) defined at the database schema level. sqlgen does not support composite primary keys, so this entity omits the PrimaryKey wrapper.