Table of Contents

User Terms And Conditions Version

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction uam.user_terms_and_condition_version User Terms And Conditions Version

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
CreatedByUserId uam.user_terms_and_condition_version created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False uam.user_terms_and_condition_version.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False uam.user_terms_and_condition_version.created_by_user_id = uam.user.user_id
CreatedOn uam.user_terms_and_condition_version created_on timestamp without time zone False
PermissionTreeId uam.user_terms_and_condition_version permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False uam.user_terms_and_condition_version.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True uam.user_terms_and_condition_version.permission_tree_id = uam.permission_tree.permission_tree_id
Id uam.user_terms_and_condition_version user_terms_and_condition_version_id bigint False True
Version uam.user_terms_and_condition_version version integer False
Accepted uam.user_terms_and_condition_version accepted boolean False
AcceptedDate uam.user_terms_and_condition_version accepted_date timestamp without time zone True
Deprecated uam.user_terms_and_condition_version deprecated boolean False
TermsAndConditionVersionId uam.user_terms_and_condition_version terms_and_condition_version_id bigint False
TermsAndConditionVersionContentVersion uam.terms_and_condition_version content_version integer False uam.user_terms_and_condition_version.terms_and_condition_version_id = uam.terms_and_condition_version.terms_and_condition_version_id
TermsAndConditionVersionLanguageId gen.language language_id bigint False True uam.user_terms_and_condition_version.terms_and_condition_version_id = uam.terms_and_condition_version.terms_and_condition_version_id Then
uam.terms_and_condition_version.language_id = gen.language.language_id
TermsAndConditionVersionLanguageCode gen.language code character varying(50) False uam.user_terms_and_condition_version.terms_and_condition_version_id = uam.terms_and_condition_version.terms_and_condition_version_id Then
uam.terms_and_condition_version.language_id = gen.language.language_id
TermsAndConditionVersionTermsAndConditionId uam.terms_and_condition terms_and_condition_id bigint False True uam.user_terms_and_condition_version.terms_and_condition_version_id = uam.terms_and_condition_version.terms_and_condition_version_id Then
uam.terms_and_condition_version.terms_and_condition_id = uam.terms_and_condition.terms_and_condition_id
TermsAndConditionVersionTermsAndConditionName uam.terms_and_condition name character varying(200) False uam.user_terms_and_condition_version.terms_and_condition_version_id = uam.terms_and_condition_version.terms_and_condition_version_id Then
uam.terms_and_condition_version.terms_and_condition_id = uam.terms_and_condition.terms_and_condition_id
UserId uam.user_terms_and_condition_version user_id bigint False
UserCode uam.user code character varying(50) False uam.user_terms_and_condition_version.user_id = uam.user.user_id
UserFullName uam.user full_name character varying(200) False uam.user_terms_and_condition_version.user_id = uam.user.user_id

Queries

The list of example User Terms And Conditions Version queries can be interpreted using the following legend:

Legend Description
Primary Table Alias The alias for the uam.user_terms_and_condition_version table in the query
Include References Include (true) or exclude (false) all lookup table joins in the query
Include Permissions Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user

Query 1

Primary Table Alias Include References Include Permissions
_utacv False False 
SELECT
    _utacv.created_by_user_id AS "CreatedByUserId",
    _utacv.created_on AS "CreatedOn",
    _utacv.permission_tree_id AS "PermissionTreeId",
    _utacv.user_terms_and_condition_version_id AS "Id",
    _utacv.version AS "Version",
    _utacv.accepted AS "Accepted",
    _utacv.accepted_date AS "AcceptedDate",
    _utacv.deprecated AS "Deprecated",
    _utacv.terms_and_condition_version_id AS "TermsAndConditionVersionId",
    _utacv.user_id AS "UserId"
FROM
    uam.user_terms_and_condition_version _utacv

Query 2

Primary Table Alias Include References Include Permissions
_utacv True False 
SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _utacv.created_on AS "CreatedOn",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _utacv.user_terms_and_condition_version_id AS "Id",
    _utacv.version AS "Version",
    _utacv.accepted AS "Accepted",
    _utacv.accepted_date AS "AcceptedDate",
    _utacv.deprecated AS "Deprecated",
    _tacv.terms_and_condition_version_id AS "TermsAndConditionVersionId",
    _tacv.content_version AS "TermsAndConditionVersionContentVersion",
    _tacv.language_id AS "TermsAndConditionVersionLanguage",
    _l.language_id AS "TermsAndConditionVersionLanguageId",
    _l.code AS "TermsAndConditionVersionLanguageCode",
    _tacv.terms_and_condition_id AS "TermsAndConditionVersionTermsAndCondition",
    _tac.terms_and_condition_id AS "TermsAndConditionVersionTermsAndConditionId",
    _tac.name AS "TermsAndConditionVersionTermsAndConditionName",
    _u1.user_id AS "UserId",
    _u1.code AS "UserCode",
    _u1.full_name AS "UserFullName"
FROM
    uam.user_terms_and_condition_version _utacv
    JOIN uam.user _u ON _utacv.created_by_user_id = _u.user_id
    JOIN uam.permission_tree _pt ON _utacv.permission_tree_id = _pt.permission_tree_id
    JOIN uam.terms_and_condition_version _tacv ON _utacv.terms_and_condition_version_id = _tacv.terms_and_condition_version_id
    LEFT JOIN gen.language _l ON _tacv.language_id = _l.language_id
    LEFT JOIN uam.terms_and_condition _tac ON _tacv.terms_and_condition_id = _tac.terms_and_condition_id
    JOIN uam.user _u1 ON _utacv.user_id = _u1.user_id

Query 3

Primary Table Alias Include References Include Permissions
_utacv False True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 110717400 
WITH permission_tree_ids AS
(
    SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
    _utacv.created_by_user_id AS "CreatedByUserId",
    _utacv.created_on AS "CreatedOn",
    _utacv.permission_tree_id AS "PermissionTreeId",
    _utacv.user_terms_and_condition_version_id AS "Id",
    _utacv.version AS "Version",
    _utacv.accepted AS "Accepted",
    _utacv.accepted_date AS "AcceptedDate",
    _utacv.deprecated AS "Deprecated",
    _utacv.terms_and_condition_version_id AS "TermsAndConditionVersionId",
    _utacv.user_id AS "UserId",
    _utacv.permission_tree_id AS "_utacv_permission_tree_id"
FROM
    uam.user_terms_and_condition_version _utacv
    JOIN permission_tree_ids permission_join ON _utacv.permission_tree_id = permission_join.permission_tree_id

Query 4

Primary Table Alias Include References Include Permissions
_utacv True True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 110717400 
WITH permission_tree_ids AS
(
    SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _utacv.created_on AS "CreatedOn",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _utacv.user_terms_and_condition_version_id AS "Id",
    _utacv.version AS "Version",
    _utacv.accepted AS "Accepted",
    _utacv.accepted_date AS "AcceptedDate",
    _utacv.deprecated AS "Deprecated",
    _tacv.terms_and_condition_version_id AS "TermsAndConditionVersionId",
    _tacv.content_version AS "TermsAndConditionVersionContentVersion",
    _tacv.language_id AS "TermsAndConditionVersionLanguage",
    _l.language_id AS "TermsAndConditionVersionLanguageId",
    _l.code AS "TermsAndConditionVersionLanguageCode",
    _tacv.terms_and_condition_id AS "TermsAndConditionVersionTermsAndCondition",
    _tac.terms_and_condition_id AS "TermsAndConditionVersionTermsAndConditionId",
    _tac.name AS "TermsAndConditionVersionTermsAndConditionName",
    _u1.user_id AS "UserId",
    _u1.code AS "UserCode",
    _u1.full_name AS "UserFullName",
    _utacv.permission_tree_id AS "_utacv_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _tacv.permission_tree_id AS "_tacv_permission_tree_id",
    _l.permission_tree_id AS "_l_permission_tree_id",
    _tac.permission_tree_id AS "_tac_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id"
FROM
    uam.user_terms_and_condition_version _utacv
    JOIN permission_tree_ids permission_join ON _utacv.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _utacv.created_by_user_id = _u.user_id
    JOIN uam.permission_tree _pt ON _utacv.permission_tree_id = _pt.permission_tree_id
    JOIN uam.terms_and_condition_version _tacv ON _utacv.terms_and_condition_version_id = _tacv.terms_and_condition_version_id
    LEFT JOIN gen.language _l ON _tacv.language_id = _l.language_id
    LEFT JOIN uam.terms_and_condition _tac ON _tacv.terms_and_condition_id = _tac.terms_and_condition_id
    JOIN uam.user _u1 ON _utacv.user_id = _u1.user_id