Table of Contents

Change Data Trigger Notification Event Attachment

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction gen.change_data_trigger_notification_event_attachment Change Data Trigger Notification Event Attachment

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
Code gen.change_data_trigger_notification_event_attachment code character varying(50) False
IsActive gen.change_data_trigger_notification_event_attachment is_active boolean False
CreatedByUserId gen.change_data_trigger_notification_event_attachment created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False gen.change_data_trigger_notification_event_attachment.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False gen.change_data_trigger_notification_event_attachment.created_by_user_id = uam.user.user_id
CreatedOn gen.change_data_trigger_notification_event_attachment created_on timestamp without time zone False
ModifiedByUserId gen.change_data_trigger_notification_event_attachment modified_by_user_id bigint False
ModifiedByUserCode uam.user code character varying(50) False gen.change_data_trigger_notification_event_attachment.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName uam.user full_name character varying(200) False gen.change_data_trigger_notification_event_attachment.modified_by_user_id = uam.user.user_id
ModifiedOn gen.change_data_trigger_notification_event_attachment modified_on timestamp without time zone False
Version gen.change_data_trigger_notification_event_attachment version integer False
PermissionTreeId gen.change_data_trigger_notification_event_attachment permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False gen.change_data_trigger_notification_event_attachment.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True gen.change_data_trigger_notification_event_attachment.permission_tree_id = uam.permission_tree.permission_tree_id
Id gen.change_data_trigger_notification_event_attachment change_data_trigger_notification_event_attachment_id bigint False True
AttachmentType gen.change_data_trigger_notification_event_attachment attachment_type gen.attachment_type False
ChangeDataTriggerNotificationEventId gen.change_data_trigger_notification_event_attachment change_data_trigger_notification_event_id bigint False
ChangeDataTriggerNotificationEventChangeDataTriggerId gen.change_data_trigger change_data_trigger_id bigint False True gen.change_data_trigger_notification_event_attachment.change_data_trigger_notification_event_id = gen.change_data_trigger_notification_event.change_data_trigger_notification_event_id Then
gen.change_data_trigger_notification_event.change_data_trigger_id = gen.change_data_trigger.change_data_trigger_id
ChangeDataTriggerNotificationEventChangeDataTriggerCode gen.change_data_trigger code character varying(50) False gen.change_data_trigger_notification_event_attachment.change_data_trigger_notification_event_id = gen.change_data_trigger_notification_event.change_data_trigger_notification_event_id Then
gen.change_data_trigger_notification_event.change_data_trigger_id = gen.change_data_trigger.change_data_trigger_id
ChangeDataTriggerNotificationEventChangeDataTriggerDescription gen.change_data_trigger description character varying(100) False gen.change_data_trigger_notification_event_attachment.change_data_trigger_notification_event_id = gen.change_data_trigger_notification_event.change_data_trigger_notification_event_id Then
gen.change_data_trigger_notification_event.change_data_trigger_id = gen.change_data_trigger.change_data_trigger_id
Notes gen.change_data_trigger_notification_event_attachment notes text True
ReportFormat gen.change_data_trigger_notification_event_attachment report_format gen.report_format True
ReportName gen.change_data_trigger_notification_event_attachment report_name text True
ReportPassword gen.change_data_trigger_notification_event_attachment report_password character varying(100) True
ReportUserFullName gen.change_data_trigger_notification_event_attachment report_user_full_name text True
ReportUserId gen.change_data_trigger_notification_event_attachment report_user_id text True
ReportUserName gen.change_data_trigger_notification_event_attachment report_username text True
RunAsAdminUser gen.change_data_trigger_notification_event_attachment run_as_admin_user boolean False
SequenceNumber gen.change_data_trigger_notification_event_attachment sequence_number integer True

Enumerations

Mapping 1

Property Property Type Db Column Db Column Type Db Column Values
AttachmentType AttachmentType attachment_type gen.attachment_type Report

Mapping 2

Property Property Type Db Column Db Column Type Db Column Values
ReportFormat ReportFormat report_format gen.report_format Pdf
Csv
Excel
Docx
Html
Image
Json

Queries

The list of example Change Data Trigger Notification Event Attachment queries can be interpreted using the following legend:

Legend Description
Primary Table Alias The alias for the gen.change_data_trigger_notification_event_attachment 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
_cdtnea False False 
SELECT
    _cdtnea.code AS "Code",
    _cdtnea.is_active AS "IsActive",
    _cdtnea.created_by_user_id AS "CreatedByUserId",
    _cdtnea.created_on AS "CreatedOn",
    _cdtnea.modified_by_user_id AS "ModifiedByUserId",
    _cdtnea.modified_on AS "ModifiedOn",
    _cdtnea.version AS "Version",
    _cdtnea.permission_tree_id AS "PermissionTreeId",
    _cdtnea.change_data_trigger_notification_event_attachment_id AS "Id",
    _cdtnea.attachment_type AS "AttachmentType",
    _cdtnea.change_data_trigger_notification_event_id AS "ChangeDataTriggerNotificationEventId",
    _cdtnea.notes AS "Notes",
    _cdtnea.report_format AS "ReportFormat",
    _cdtnea.report_name AS "ReportName",
    _cdtnea.report_password AS "ReportPassword",
    _cdtnea.report_user_full_name AS "ReportUserFullName",
    _cdtnea.report_user_id AS "ReportUserId",
    _cdtnea.report_username AS "ReportUserName",
    _cdtnea.run_as_admin_user AS "RunAsAdminUser",
    _cdtnea.sequence_number AS "SequenceNumber"
FROM
    gen.change_data_trigger_notification_event_attachment _cdtnea

Query 2

Primary Table Alias Include References Include Permissions
_cdtnea True False 
SELECT
    _cdtnea.code AS "Code",
    _cdtnea.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _cdtnea.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _cdtnea.modified_on AS "ModifiedOn",
    _cdtnea.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _cdtnea.change_data_trigger_notification_event_attachment_id AS "Id",
    _cdtnea.attachment_type AS "AttachmentType",
    _cdtne.change_data_trigger_notification_event_id AS "ChangeDataTriggerNotificationEventId",
    _cdtne.change_data_trigger_id AS "ChangeDataTriggerNotificationEventChangeDataTrigger",
    _cdt.change_data_trigger_id AS "ChangeDataTriggerNotificationEventChangeDataTriggerId",
    _cdt.code AS "ChangeDataTriggerNotificationEventChangeDataTriggerCode",
    _cdt.description AS "CDataTriggerNotificationEventChangeDataTriggerDescription",
    _cdtnea.notes AS "Notes",
    _cdtnea.report_format AS "ReportFormat",
    _cdtnea.report_name AS "ReportName",
    _cdtnea.report_password AS "ReportPassword",
    _cdtnea.report_user_full_name AS "ReportUserFullName",
    _cdtnea.report_user_id AS "ReportUserId",
    _cdtnea.report_username AS "ReportUserName",
    _cdtnea.run_as_admin_user AS "RunAsAdminUser",
    _cdtnea.sequence_number AS "SequenceNumber"
FROM
    gen.change_data_trigger_notification_event_attachment _cdtnea
    JOIN uam.user _u ON _cdtnea.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _cdtnea.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _cdtnea.permission_tree_id = _pt.permission_tree_id
    JOIN gen.change_data_trigger_notification_event _cdtne ON _cdtnea.change_data_trigger_notification_event_id = _cdtne.change_data_trigger_notification_event_id
    JOIN gen.change_data_trigger _cdt ON _cdtne.change_data_trigger_id = _cdt.change_data_trigger_id

Query 3

Primary Table Alias Include References Include Permissions
_cdtnea False True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 100122300 
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
    _cdtnea.code AS "Code",
    _cdtnea.is_active AS "IsActive",
    _cdtnea.created_by_user_id AS "CreatedByUserId",
    _cdtnea.created_on AS "CreatedOn",
    _cdtnea.modified_by_user_id AS "ModifiedByUserId",
    _cdtnea.modified_on AS "ModifiedOn",
    _cdtnea.version AS "Version",
    _cdtnea.permission_tree_id AS "PermissionTreeId",
    _cdtnea.change_data_trigger_notification_event_attachment_id AS "Id",
    _cdtnea.attachment_type AS "AttachmentType",
    _cdtnea.change_data_trigger_notification_event_id AS "ChangeDataTriggerNotificationEventId",
    _cdtnea.notes AS "Notes",
    _cdtnea.report_format AS "ReportFormat",
    _cdtnea.report_name AS "ReportName",
    _cdtnea.report_password AS "ReportPassword",
    _cdtnea.report_user_full_name AS "ReportUserFullName",
    _cdtnea.report_user_id AS "ReportUserId",
    _cdtnea.report_username AS "ReportUserName",
    _cdtnea.run_as_admin_user AS "RunAsAdminUser",
    _cdtnea.sequence_number AS "SequenceNumber",
    _cdtnea.permission_tree_id AS "_cdtnea_permission_tree_id"
FROM
    gen.change_data_trigger_notification_event_attachment _cdtnea
    JOIN permission_tree_ids permission_join ON _cdtnea.permission_tree_id = permission_join.permission_tree_id

Query 4

Primary Table Alias Include References Include Permissions
_cdtnea True True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 100122300 
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
    _cdtnea.code AS "Code",
    _cdtnea.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _cdtnea.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _cdtnea.modified_on AS "ModifiedOn",
    _cdtnea.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _cdtnea.change_data_trigger_notification_event_attachment_id AS "Id",
    _cdtnea.attachment_type AS "AttachmentType",
    _cdtne.change_data_trigger_notification_event_id AS "ChangeDataTriggerNotificationEventId",
    _cdtne.change_data_trigger_id AS "ChangeDataTriggerNotificationEventChangeDataTrigger",
    _cdt.change_data_trigger_id AS "ChangeDataTriggerNotificationEventChangeDataTriggerId",
    _cdt.code AS "ChangeDataTriggerNotificationEventChangeDataTriggerCode",
    _cdt.description AS "CDataTriggerNotificationEventChangeDataTriggerDescription",
    _cdtnea.notes AS "Notes",
    _cdtnea.report_format AS "ReportFormat",
    _cdtnea.report_name AS "ReportName",
    _cdtnea.report_password AS "ReportPassword",
    _cdtnea.report_user_full_name AS "ReportUserFullName",
    _cdtnea.report_user_id AS "ReportUserId",
    _cdtnea.report_username AS "ReportUserName",
    _cdtnea.run_as_admin_user AS "RunAsAdminUser",
    _cdtnea.sequence_number AS "SequenceNumber",
    _cdtnea.permission_tree_id AS "_cdtnea_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id",
    _cdtne.permission_tree_id AS "_cdtne_permission_tree_id",
    _cdt.permission_tree_id AS "_cdt_permission_tree_id"
FROM
    gen.change_data_trigger_notification_event_attachment _cdtnea
    JOIN permission_tree_ids permission_join ON _cdtnea.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _cdtnea.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _cdtnea.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _cdtnea.permission_tree_id = _pt.permission_tree_id
    JOIN gen.change_data_trigger_notification_event _cdtne ON _cdtnea.change_data_trigger_notification_event_id = _cdtne.change_data_trigger_notification_event_id
    JOIN gen.change_data_trigger _cdt ON _cdtne.change_data_trigger_id = _cdt.change_data_trigger_id