Chapter 50. Streams

Prev		Next

50.1. coupler

UUID	str-7ecae752-1645-4796-aab6-68ad884de163
Stream Name	coupler
Serial Number
Origin Handle	`COUPLER`
Source Type
Source Format
Properties
Description	`NONE`

50.1.1. Couples

The following are the couples in this stream in execution order.

Name	Parameters	Source	Target	Properties
entity	Handle: `database_name :: VARCHAR(63)` `real_entity_name :: TEXT`	coupler_entity_feed	entity	`WITHOUT_CHECK`
attribute	Handle: `database_name :: VARCHAR(63)` `real_entity_name :: TEXT` `attribute_name :: TEXT`	coupler_attribute_feed	attribute	`WITHOUT_CHECK`

The following are bonds for each couple in this stream.

Name Handle Bond Column Bonds

Name	Handle Bond	Column Bonds
entity	SOURCE → TARGET `database_name → pgcat_database_name` `real_entity_name → pgcat_entity_name`	SOURCE → TARGET `tag → tag` `name → name` `summary → summary` `description → description` `type → type` `realise → realise` `entity_name → pgcat_name` SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH entity_model_id ] `database_name → pgcat_name`
attribute	SOURCE → TARGET `database_name → pgcat_database_name` `real_entity_name → pgcat_entity_name` `attribute_name → pgcat_name`	SOURCE → TARGET `tag → tag` `name → name` `summary → summary` `description → description` `type → type` `content → content` `value → value` `realise → realise` `system_type → pgcat_type` `position → pgcat_position` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH attribute_entity_id ] `database_name → pgcat_database_name` `real_entity_name → pgcat_entity_name`

entity

SOURCE → TARGET database_name → pgcat_database_name real_entity_name → pgcat_entity_name

SOURCE → TARGET

tag → tag name → name summary → summary description → description type → type realise → realise entity_name → pgcat_name SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH entity_model_id ]

database_name → pgcat_name

attribute

SOURCE → TARGET database_name → pgcat_database_name real_entity_name → pgcat_entity_name attribute_name → pgcat_name

SOURCE → TARGET

tag → tag name → name summary → summary description → description type → type content → content value → value realise → realise system_type → pgcat_type position → pgcat_position SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH attribute_entity_id ]

database_name → pgcat_database_name real_entity_name → pgcat_entity_name

50.2. derived

UUID	str-52d787da-a085-4de5-a8a2-7a8aa63d28e2
Stream Name	Derived
Serial Number
Origin Handle	`DERIVED`
Source Type
Source Format
Properties
Description	`NONE`

50.2.1. Couples

The following are the couples in this stream in execution order.

Name	Parameters	Source	Target	Properties
entity	Handle: `model_id :: INTEGER` `id :: INTEGER`	derived_entity_feed	entity	`WITHOUT_CASCADE` `WITHOUT_CHECK` `WITHOUT_DELTRAP`

The following are bonds for each couple in this stream.

Name Handle Bond Column Bonds

Name	Handle Bond	Column Bonds
entity	SOURCE → TARGET `model_id → model_id` `id → id`	SOURCE → TARGET `pgcat_entity_name → pgcat_entity_name`

entity

SOURCE → TARGET model_id → model_id id → id

SOURCE → TARGET

pgcat_entity_name → pgcat_entity_name

50.3. forge

UUID	str-ddde0bf4-cbc8-46e7-94e9-e9f297a3602e
Stream Name	forge
Serial Number
Origin Handle	`FORGE`
Source Type
Source Format	CSV
Properties
Description	`NONE`

50.3.1. Couples

The following are the couples in this stream in execution order.

Name	Parameters	Source	Target	Properties
entity	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)`	forge_entity_feed	entity	`WITHOUT_CHECK` `WITH_FORMAT_PIPE`
eemap	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `name :: CUSTOM(information_schema.sql_identifier)`	forge_eemap_feed	eemap	`WITHOUT_CHECK` `WITH_FORMAT_PIPE`
attribute	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `type :: CUSTOM(_th_attribute_type_enum)` `name :: CUSTOM(information_schema.sql_identifier)`	forge_attribute_feed	attribute	`WITHOUT_CHECK` `WITH_FORMAT_PIPE`
event	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `name :: CUSTOM(information_schema.sql_identifier)`	forge_event_feed	event	`WITHOUT_CHECK` `WITH_FORMAT_PIPE`

The following are bonds for each couple in this stream.

Name	Handle Bond	Column Bonds
entity	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name`	SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH entity_model_id ] `database_name → pgcat_name` SOURCE → TARGET `name → pgcat_name` `type{ @::_th_entity_type_enum } → type` `value → value` `content{ @::_th_entity_content_enum } → content` `overload → overload` `realise → realise`
eemap	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_name` `name → pgcat_needs_name`	SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH eemap_model_id ] `database_name → pgcat_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH eemap_entity_id ] `entity_name → pgcat_entity_name` `database_name → pgcat_database_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH eemap_needs_entity_id ] `name → pgcat_entity_name` `database_name → pgcat_database_name`
attribute	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `type{ @::_th_attribute_type_enum } → type` `name → pgcat_name`	SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH attribute_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` SOURCE → TARGET `size → size` `mandatory → mandatory` `multiple → multiple` `value → value` `system_type → pgcat_type` `position → pgcat_position` `content{ @::_th_attribute_content_enum } → content` `realise → realise`
event	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `name → pgcat_name`	SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH event_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` SOURCE → TARGET `timing{ @::_th_event_timing_enum } → timing` `on_create → on_create` `on_delete → on_delete` `on_modify → on_modify` `value → value` `extent{ @::_th_event_extent_enum } → extent` `deferred → deferred` `realise → realise` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH event_process_entity_id ] `database_name → pgcat_database_name` `process_entity_name → pgcat_entity_name`

50.4. pgcat

UUID	str-6b564f0e-3508-4516-ae52-7a4b2be9c6b9
Stream Name	pgcat
Serial Number
Origin Handle	`PGCAT`
Source Type
Source Format
Properties
Description	`NONE`

50.4.1. Couples

The following are the couples in this stream in execution order.

Name	Parameters	Source	Target	Properties
model	Handle: `model :: TEXT` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_model_feed	model	`WITHOUT_CHECK`
entity	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_entity_feed	entity	`WITHOUT_CHECK`
eemap	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `name :: CUSTOM(information_schema.sql_identifier)` `needs_entity_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_eemap_feed	eemap	`WITHOUT_CHECK`
attribute	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `type :: CUSTOM(_th_attribute_type_enum)` `name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_attribute_feed	attribute	`WITHOUT_CHECK`
key	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_key_feed	key	`WITHOUT_CHECK`
akmap	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `attribute_name :: CUSTOM(information_schema.sql_identifier)` `key_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_akmap_feed	akmap	`WITHOUT_CHECK`
domain	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `attribute_name :: CUSTOM(information_schema.sql_identifier)` `value :: TEXT` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_domain_feed	domain	`WITHOUT_CHECK`
relationship	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `name :: CUSTOM(information_schema.sql_identifier)` `p_entity_name :: CUSTOM(information_schema.sql_identifier)` `p_key_name :: CUSTOM(information_schema.sql_identifier)` `f_entity_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_relationship_feed	relationship	`WITHOUT_CHECK`
rakmap	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `relationship_name :: CUSTOM(information_schema.sql_identifier)` `p_entity_name :: CUSTOM(information_schema.sql_identifier)` `p_key_name :: CUSTOM(information_schema.sql_identifier)` `p_attribute_name :: CUSTOM(information_schema.sql_identifier)` `f_entity_name :: CUSTOM(information_schema.sql_identifier)` `f_attribute_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_rakmap_feed	rakmap	`WITHOUT_CHECK`
event	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `process_entity_name :: TEXT` `name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_event_feed	event	`WITHOUT_CHECK`
eamap	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `event_name :: CUSTOM(information_schema.sql_identifier)` `attribute_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_eamap_feed	eamap	`WITHOUT_CHECK`
role	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_role_feed	role	`WITHOUT_CHECK`
capability	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `role_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_capability_feed	capability	`WITHOUT_CHECK`
camap	Handle: `database_name :: CUSTOM(information_schema.sql_identifier)` `role_name :: CUSTOM(information_schema.sql_identifier)` `entity_name :: CUSTOM(information_schema.sql_identifier)` `attribute_name :: CUSTOM(information_schema.sql_identifier)` Source: `this :: TEXT` `connstr :: TEXT`	pgcat_camap_feed	camap	`WITHOUT_CHECK`

The following are bonds for each couple in this stream.

Name	Handle Bond	Column Bonds
model	SOURCE → TARGET `model → tag`	SOURCE → TARGET `name → pgcat_name` `catalog_name → pgcat_catalog_name` `schema_name → pgcat_schema_name` `requires → requires` `realise → realise`
entity	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name`	SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH entity_model_id ] `database_name → pgcat_name` SOURCE → TARGET `name → pgcat_name` `type{ @::_th_entity_type_enum } → type` `value → value` `content{ @::_th_entity_content_enum } → content` `realise → realise`
eemap	SOURCE → TARGET `database_name → pgcat_database_name` `name → pgcat_name` `needs_entity_name → pgcat_needs_name`	SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH eemap_model_id ] `database_name → pgcat_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH eemap_entity_id ] `name → pgcat_entity_name` `database_name → pgcat_database_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH eemap_needs_entity_id ] `needs_entity_name → pgcat_entity_name` `database_name → pgcat_database_name`
attribute	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `type{ @::_th_attribute_type_enum } → type` `name → pgcat_name`	SOURCE → TARGET `size → size` `mandatory → mandatory` `multiple → multiple` `value → value` `system_type → pgcat_type` `position → pgcat_position` `content{ @::_th_attribute_content_enum } → content` `realise → realise` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH attribute_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name`
key	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `name → pgcat_name`	SOURCE → TARGET `type{ @::_th_key_type_enum } → type` `realise → realise` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH key_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_name`
akmap	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_attribute_name` `key_name → pgcat_key_name`	SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH akmap_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_name` SOURCE → TARGET `position → position` SOURCE → attribute (MANDATORY FKEY LOOKUP) [ → TARGET WITH akmap_attribute_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_name` SOURCE → key (MANDATORY FKEY LOOKUP) [ → TARGET WITH akmap_key_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `key_name → pgcat_name`
domain	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_attribute_name` `value → value`	SOURCE → TARGET `position → position` SOURCE → attribute (MANDATORY FKEY LOOKUP) [ → TARGET WITH domain_attribute_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_name`
relationship	SOURCE → TARGET `database_name → pgcat_database_name` `name → pgcat_name` `p_entity_name → pgcat_p_entity_name` `p_key_name → pgcat_p_key_name` `f_entity_name → pgcat_f_entity_name`	SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH relationship_model_id ] `database_name → pgcat_name` SOURCE → TARGET `type{ @::_th_relationship_type_enum } → type` `realise → realise` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH relationship_p_entity_id ] `database_name → pgcat_database_name` `p_entity_name → pgcat_name` SOURCE → key (MANDATORY FKEY LOOKUP) [ → TARGET WITH relationship_p_key_id ] `database_name → pgcat_database_name` `p_entity_name → pgcat_entity_name` `p_key_name → pgcat_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH relationship_f_entity_id ] `database_name → pgcat_database_name` `f_entity_name → pgcat_name`
rakmap	SOURCE → TARGET `database_name → pgcat_database_name` `relationship_name → pgcat_relationship_name` `p_entity_name → pgcat_p_entity_name` `p_key_name → pgcat_p_key_name` `p_attribute_name → pgcat_p_attribute_name` `f_entity_name → pgcat_f_entity_name` `f_attribute_name → pgcat_f_attribute_name`	SOURCE → TARGET `position → position` SOURCE → relationship (MANDATORY FKEY LOOKUP) [ → TARGET WITH rakmap_relationship_id ] `database_name → pgcat_database_name` `relationship_name → pgcat_name` SOURCE → akmap (MANDATORY FKEY LOOKUP) [ → TARGET WITH rakmap_akmap_id ] `database_name → pgcat_database_name` `p_entity_name → pgcat_entity_name` `p_key_name → pgcat_key_name` `p_attribute_name → pgcat_attribute_name` SOURCE → attribute (MANDATORY FKEY LOOKUP) [ → TARGET WITH rakmap_attribute_id ] `database_name → pgcat_database_name` `f_entity_name → pgcat_entity_name` `f_attribute_name → pgcat_name`
event	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `process_entity_name → pgcat_process_entity_name` `name → pgcat_name`	SOURCE → TARGET `timing{ @::_th_event_timing_enum } → timing` `on_create → on_create` `on_delete → on_delete` `on_modify → on_modify` `value → value` `extent{ @::_th_event_extent_enum } → extent` `deferred → deferred` `realise → realise` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH event_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH event_process_entity_id ] `database_name → pgcat_database_name` `process_entity_name → pgcat_entity_name`
eamap	SOURCE → TARGET `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `event_name → pgcat_event_name` `attribute_name → pgcat_attribute_name`	SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH eamap_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_name` SOURCE → event (MANDATORY FKEY LOOKUP) [ → TARGET WITH eamap_event_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `event_name → pgcat_name` SOURCE → attribute (MANDATORY FKEY LOOKUP) [ → TARGET WITH eamap_attribute_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_name`
role	SOURCE → TARGET `database_name → pgcat_database_name` `name → pgcat_name`	SOURCE → TARGET `realise → realise` SOURCE → model (MANDATORY FKEY LOOKUP) [ → TARGET WITH role_model_id ] `database_name → pgcat_name`
capability	SOURCE → TARGET `database_name → pgcat_database_name` `role_name → pgcat_role_name` `entity_name → pgcat_entity_name`	SOURCE → TARGET `includes_create → includes_create` `includes_delete → includes_delete` `includes_read → includes_read` `includes_write → includes_write` `realise → realise` SOURCE → role (MANDATORY FKEY LOOKUP) [ → TARGET WITH capability_role_id ] `database_name → pgcat_database_name` `role_name → pgcat_name` SOURCE → entity (MANDATORY FKEY LOOKUP) [ → TARGET WITH capability_entity_id ] `database_name → pgcat_database_name` `entity_name → pgcat_name`
camap	SOURCE → TARGET `database_name → pgcat_database_name` `role_name → pgcat_role_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_attribute_name`	SOURCE → TARGET `swap_create → swap_create` `swap_read → swap_read` `swap_write → swap_write` SOURCE → capability (MANDATORY FKEY LOOKUP) [ → TARGET WITH camap_capability_id ] `database_name → pgcat_database_name` `role_name → pgcat_role_name` `entity_name → pgcat_entity_name` SOURCE → attribute (MANDATORY FKEY LOOKUP) [ → TARGET WITH camap_attribute_id ] `database_name → pgcat_database_name` `entity_name → pgcat_entity_name` `attribute_name → pgcat_name`