rpc_permission

37 rows


Description

Which permission a generic RPC route requires. Read by the ERP gateway (newsoft-erp cmd/server). A function with no row here is not gated.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
route_prefix text 2147483647 null
schema_name text 2147483647 null
function_name text 2147483647 null
permission_code text 2147483647 null
permission.code fk_rpc_permission_code R
enabled bool 1 true
note text 2147483647 √ null
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
pk_rpc_permission Primary key Asc/Asc/Asc route_prefix + schema_name + function_name
idx_rpc_permission_enabled Performance Asc/Asc/Asc route_prefix + schema_name + function_name

Relationships