Table of Contents

Trade

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction res.trade Trade

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
Code res.trade code character varying(50) False
IsActive res.trade is_active boolean False
CreatedByUserId res.trade created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False res.trade.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False res.trade.created_by_user_id = uam.user.user_id
CreatedOn res.trade created_on timestamp without time zone False
ModifiedByUserId res.trade modified_by_user_id bigint False
ModifiedByUserCode uam.user code character varying(50) False res.trade.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName uam.user full_name character varying(200) False res.trade.modified_by_user_id = uam.user.user_id
ModifiedOn res.trade modified_on timestamp without time zone False
Version res.trade version integer False
PermissionTreeId res.trade permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False res.trade.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True res.trade.permission_tree_id = uam.permission_tree.permission_tree_id
Id res.trade trade_id bigint False True
DefaultTradeFinancialRateId res.trade default_trade_financial_rate_id bigint True
DefaultTradeFinancialRateFinancialRateId res.financial_rate financial_rate_id bigint False True res.trade.default_trade_financial_rate_id = res.trade_financial_rate.trade_financial_rate_id Then
res.trade_financial_rate.financial_rate_id = res.financial_rate.financial_rate_id
DefaultTradeFinancialRateFinancialRateDescription res.financial_rate description character varying(100) False res.trade.default_trade_financial_rate_id = res.trade_financial_rate.trade_financial_rate_id Then
res.trade_financial_rate.financial_rate_id = res.financial_rate.financial_rate_id
Description res.trade description character varying(100) False
Notes res.trade notes text True
SequenceNumber res.trade sequence_number integer True

Queries

The list of example Trade queries can be interpreted using the following legend:

Legend Description
Primary Table Alias The alias for the res.trade 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
_t False False 
SELECT
    _t.code AS "Code",
    _t.is_active AS "IsActive",
    _t.created_by_user_id AS "CreatedByUserId",
    _t.created_on AS "CreatedOn",
    _t.modified_by_user_id AS "ModifiedByUserId",
    _t.modified_on AS "ModifiedOn",
    _t.version AS "Version",
    _t.permission_tree_id AS "PermissionTreeId",
    _t.trade_id AS "Id",
    _t.default_trade_financial_rate_id AS "DefaultTradeFinancialRateId",
    _t.description AS "Description",
    _t.notes AS "Notes",
    _t.sequence_number AS "SequenceNumber"
FROM
    res.trade _t

Query 2

Primary Table Alias Include References Include Permissions
_t True False 
SELECT
    _t.code AS "Code",
    _t.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _t.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _t.modified_on AS "ModifiedOn",
    _t.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _t.trade_id AS "Id",
    _tfr.trade_financial_rate_id AS "DefaultTradeFinancialRateId",
    _tfr.financial_rate_id AS "DefaultTradeFinancialRateFinancialRate",
    _fr.financial_rate_id AS "DefaultTradeFinancialRateFinancialRateId",
    _fr.description AS "DefaultTradeFinancialRateFinancialRateDescription",
    _t.description AS "Description",
    _t.notes AS "Notes",
    _t.sequence_number AS "SequenceNumber"
FROM
    res.trade _t
    JOIN uam.user _u ON _t.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _t.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _t.permission_tree_id = _pt.permission_tree_id
    LEFT JOIN res.trade_financial_rate _tfr ON _t.default_trade_financial_rate_id = _tfr.trade_financial_rate_id
    LEFT JOIN res.financial_rate _fr ON _tfr.financial_rate_id = _fr.financial_rate_id

Query 3

Primary Table Alias Include References Include Permissions
_t False True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 70100 
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
    _t.code AS "Code",
    _t.is_active AS "IsActive",
    _t.created_by_user_id AS "CreatedByUserId",
    _t.created_on AS "CreatedOn",
    _t.modified_by_user_id AS "ModifiedByUserId",
    _t.modified_on AS "ModifiedOn",
    _t.version AS "Version",
    _t.permission_tree_id AS "PermissionTreeId",
    _t.trade_id AS "Id",
    _t.default_trade_financial_rate_id AS "DefaultTradeFinancialRateId",
    _t.description AS "Description",
    _t.notes AS "Notes",
    _t.sequence_number AS "SequenceNumber",
    _t.permission_tree_id AS "_t_permission_tree_id"
FROM
    res.trade _t
    JOIN permission_tree_ids permission_join ON _t.permission_tree_id = permission_join.permission_tree_id

Query 4

Primary Table Alias Include References Include Permissions
_t True True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 70100 
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
    _t.code AS "Code",
    _t.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _t.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _t.modified_on AS "ModifiedOn",
    _t.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _t.trade_id AS "Id",
    _tfr.trade_financial_rate_id AS "DefaultTradeFinancialRateId",
    _tfr.financial_rate_id AS "DefaultTradeFinancialRateFinancialRate",
    _fr.financial_rate_id AS "DefaultTradeFinancialRateFinancialRateId",
    _fr.description AS "DefaultTradeFinancialRateFinancialRateDescription",
    _t.description AS "Description",
    _t.notes AS "Notes",
    _t.sequence_number AS "SequenceNumber",
    _t.permission_tree_id AS "_t_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id",
    _tfr.permission_tree_id AS "_tfr_permission_tree_id"
FROM
    res.trade _t
    JOIN permission_tree_ids permission_join ON _t.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _t.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _t.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _t.permission_tree_id = _pt.permission_tree_id
    LEFT JOIN res.trade_financial_rate _tfr ON _t.default_trade_financial_rate_id = _tfr.trade_financial_rate_id
    LEFT JOIN res.financial_rate _fr ON _tfr.financial_rate_id = _fr.financial_rate_id