Chapter 40. Table

40.1. akmap

UUID

ent-b188a3ce-b2a2-426e-96a6-0c385d806e5f

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

akmap

Table Signature

akmap

Explicit Cluster Membership

Dictionary

Explicit Dependencies

entity attribute key

Export Element Instance

entity:akmap

Derive Fragment Instance

relation:akmap

Description

NONE

40.1.1. Properties

There are no deviant properties associated with this table.

40.1.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(akmap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

key_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_attribute_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_key_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

40.1.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_position_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_position_changedby

TEXT

NONE

NONE

40.1.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

akmap_id

model_id entity_id attribute_id key_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

akmap_attribute_id

model_id entity_id attribute_id

NONE

NONE (USING CONSTRAINT NAME)

akmap_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

akmap_key_id

model_id entity_id key_id

NONE

40.1.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

rakmap

rakmap_akmap_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

attribute

akmap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

akmap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

key

akmap_key_id

NONE

NONE

Straight

NONE

40.1.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.1.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

akmap

pgcat

pgcat_akmap_feed

pgcat_database_name pgcat_attribute_name pgcat_key_name

position

NONE

There are no TheonCoupler couples pulling content from this table.

40.1.8. Roles

There are no roles controlling access to this table.

40.2. attribute

UUID

ent-b13b18f1-1a2e-40c7-8b22-de5fc6076b98

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

attribute

Table Signature

attribute

Explicit Cluster Membership

Reflection Dictionary

Explicit Dependencies

derived_stream_push entity attribute

Export Element Instance

entity:attribute

Derive Fragment Instance

relation:attribute

Description

NONE

40.2.1. Properties

There are no deviant properties associated with this table.

40.2.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(attribute_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

content

SET( _content_enum) The following are the only non-empty values allowed. Boolean Custom Custom/Type Date Date/Time Interval Number/Integer Number/Decimal Number/Float Number/Serial Text Time

NONE

NONE

NONE (USING COLUMN NAME)

size

FLOAT

NONE

NONE

NONE (USING COLUMN NAME)

sensitive

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

derived

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

mandatory

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

multiple

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Column Parameter Return Enumerate Property ReturnColumn Constraint

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_type

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.2.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_coupler_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_forge_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_tag_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_tag_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_name_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_summary_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_summary_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_description_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_description_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_content_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_content_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_size_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_size_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_mandatory_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_mandatory_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_multiple_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_multiple_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_value_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_value_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_type_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_type_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_position_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_position_changedby

TEXT

NONE

NONE

40.2.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

attribute_id

model_id entity_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

attribute_entity_id

model_id entity_id

NONE

40.2.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

field

field_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

domain

domain_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

eamap

eamap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

pair

pair_s_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

pair

pair_t_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

pair

pair_v_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

akmap

akmap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

rakmap

rakmap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

camap

camap_attribute_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

attribute_entity_id

NONE

NONE

Straight

NONE

40.2.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

derived_stream_push_entity

derived_stream_push()

adding new records deleting records updating records

RECORD

NONE

40.2.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

attribute

pgcat

pgcat_attribute_feed

pgcat_database_name pgcat_name

size

NONE

attribute

coupler

coupler_attribute_feed

pgcat_database_name pgcat_name

tag

NONE

attribute

forge

forge_attribute_feed

pgcat_database_name pgcat_name

size

NONE

There are no TheonCoupler couples pulling content from this table.

40.2.8. Roles

There are no roles controlling access to this table.

40.3. bond

UUID

ent-97498d38-2ca0-4e5c-8ee6-1c99c17f1d62

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

bond

Table Signature

bond

Explicit Cluster Membership

Dictionary

Explicit Dependencies

relationship coupler_stream_push bond entity couple

Export Element Instance

entity:bond

Derive Fragment Instance

relation:bond

Description

NONE

40.3.1. Properties

There are no deviant properties associated with this table.

40.3.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(bond_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

stream_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

couple_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Column Handle

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

mandatory

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_key_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

s_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

t_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

40.3.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.3.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

bond_id

model_id stream_id s_entity_id t_entity_id couple_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

bond_couple_id

model_id stream_id s_entity_id t_entity_id couple_id

NONE

NONE (USING CONSTRAINT NAME)

bond_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

bond_relationship_id

model_id entity_id relationship_key_id t_entity_id relationship_id

NONE

40.3.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

pair

pair_bond_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

couple

bond_couple_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

bond_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

bond_relationship_id

NONE

NONE

Straight

NONE

40.3.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

coupler_stream_push_bond

coupler_stream_push()

updating records

TRANSACTION

NONE

40.3.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.3.8. Roles

There are no roles controlling access to this table.

40.4. camap

UUID

ent-c96aaa9c-9ad5-45bf-80a0-da3ab6e9daf1

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

camap

Table Signature

camap

Explicit Cluster Membership

Dictionary

Explicit Dependencies

role attribute capability

Export Element Instance

entity:camap

Derive Fragment Instance

relation:camap

Description

NONE

40.4.1. Properties

There are no deviant properties associated with this table.

40.4.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(camap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

role_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

capability_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

swap_create

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

swap_read

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

swap_write

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_role_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_attribute_name

VARCHAR(63)

NONE

NONE

40.4.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

40.4.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

camap_id

model_id role_id entity_id capability_id attribute_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

camap_unq

model_id role_id entity_id attribute_id

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

camap_attribute_id

model_id entity_id attribute_id

NONE

NONE (USING CONSTRAINT NAME)

camap_capability_id

model_id role_id entity_id capability_id

NONE

NONE (USING CONSTRAINT NAME)

camap_role_id

model_id role_id

NONE

40.4.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

attribute

camap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

capability

camap_capability_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

role

camap_role_id

NONE

NONE

Through

NONE

40.4.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.4.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

camap

pgcat

pgcat_camap_feed

pgcat_database_name pgcat_attribute_name

swap_create

NONE

There are no TheonCoupler couples pulling content from this table.

40.4.8. Roles

There are no roles controlling access to this table.

40.5. capability

UUID

ent-c96e5f40-4ad4-41e3-a4ee-ad9861768171

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

capability

Table Signature

capability

Explicit Cluster Membership

Dictionary

Explicit Dependencies

role entity

Export Element Instance

entity:capability

Derive Fragment Instance

relation:capability

Description

NONE

40.5.1. Properties

There are no deviant properties associated with this table.

40.5.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(capability_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

role_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

includes_create

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

includes_delete

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

includes_read

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

includes_write

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_role_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.5.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_create_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_create_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_delete_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_delete_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_read_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_read_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_write_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_includes_write_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

40.5.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

capability_id

model_id role_id entity_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

capability_unq

model_id role_id entity_id

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

capability_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

capability_role_id

model_id role_id

NONE

40.5.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

camap

camap_capability_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

capability_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

role

capability_role_id

NONE

NONE

Straight

NONE

40.5.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.5.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

capability

pgcat

pgcat_capability_feed

pgcat_database_name pgcat_entity_name

includes_create

NONE

There are no TheonCoupler couples pulling content from this table.

40.5.8. Roles

There are no roles controlling access to this table.

40.6. cdmap

UUID

ent-0908ec0d-7796-4499-9061-64d75a126b0a

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

cdmap

Table Signature

cdmap

Explicit Cluster Membership

Reflection

Explicit Dependencies

model cluster desktop

Export Element Instance

entity:cdmap

Derive Fragment Instance

relation:cdmap

Description

NONE

40.6.1. Properties

There are no deviant properties associated with this table.

40.6.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(cdmap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

cluster_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

desktop_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

40.6.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.6.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cdmap_id

model_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cdmap_unq

model_id cluster_id desktop_id

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cdmap_cluster_id

model_id cluster_id

NONE

NONE (USING CONSTRAINT NAME)

cdmap_desktop_id

model_id desktop_id

NONE

NONE (USING CONSTRAINT NAME)

cdmap_model_id

model_id

NONE

40.6.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

cluster

cdmap_cluster_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

desktop

cdmap_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

cdmap_model_id

NONE

NONE

Straight

NONE

40.6.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.6.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.6.8. Roles

There are no roles controlling access to this table.

40.7. cemap

UUID

ent-d020de07-e24f-4001-ba48-91981cae1481

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

cemap

Table Signature

cemap

Explicit Cluster Membership

Dictionary

Explicit Dependencies

model cluster entity

Export Element Instance

entity:cemap

Derive Fragment Instance

relation:cemap

Description

NONE

40.7.1. Properties

There are no deviant properties associated with this table.

40.7.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(cemap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

cluster_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

40.7.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.7.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cemap_id

model_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cemap_unq

model_id cluster_id entity_id

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cemap_cluster_id

model_id cluster_id

NONE

NONE (USING CONSTRAINT NAME)

cemap_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

cemap_model_id

model_id

NONE

40.7.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

cluster

cemap_cluster_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

cemap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

cemap_model_id

NONE

NONE

Straight

NONE

40.7.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.7.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.7.8. Roles

There are no roles controlling access to this table.

40.8. cluster

UUID

ent-94c7eb99-b96c-463e-89db-47b53d76eead

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

cluster

Table Signature

cluster

Explicit Cluster Membership

Reflection

Explicit Dependencies

model

Export Element Instance

entity:cluster

Derive Fragment Instance

relation:cluster

Description

NONE

40.8.1. Properties

There are no deviant properties associated with this table.

40.8.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(cluster_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

cluster_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

scheme

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.8.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.8.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cluster_id

model_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

cluster_cluster_id

model_id cluster_id

NONE

NONE (USING CONSTRAINT NAME)

cluster_model_id

model_id

NONE

40.8.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

cluster

cluster_cluster_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

cdmap

cdmap_cluster_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

cemap

cemap_cluster_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

cluster

cluster_cluster_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

cluster_model_id

NONE

NONE

Straight

NONE

40.8.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.8.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.8.8. Roles

There are no roles controlling access to this table.

40.9. connector

UUID

ent-c274afd6-7982-4c6a-b1ba-3778e3e015a8

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

connector

Table Signature

connector

Explicit Cluster Membership

Reflection

Explicit Dependencies

relationship panel connector

Export Element Instance

entity:connector

Derive Fragment Instance

relation:connector

Description

NONE

40.9.1. Properties

There are no deviant properties associated with this table.

40.9.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(connector_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

relationship_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Forward ForwardNormal Reverse ReverseLookup

NONE

NONE

NONE (USING COLUMN NAME)

label

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

selector

SET( _selector_enum) The following are the only non-empty values allowed. Keyboard None Tab Scroll

NONE

NONE

NONE (USING COLUMN NAME)

without_append

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_delete

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

embedded

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

box

SET( _box_enum) The following are the only non-empty values allowed. Fixed Visible Hidden

NONE

NONE

NONE (USING COLUMN NAME)

connector_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

connector_panel_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

relationship_entity_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_key_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_f_entity_id

INTEGER

NONE

NONE

40.9.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.9.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

connector_id

model_id panel_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

connector_connector_id

model_id connector_panel_id connector_id

NONE

NONE (USING CONSTRAINT NAME)

connector_panel_id

model_id panel_id

NONE

NONE (USING CONSTRAINT NAME)

connector_relationship_id

model_id relationship_entity_id relationship_key_id relationship_f_entity_id relationship_id

NONE

40.9.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

connector

connector_connector_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

field_connector_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

connector

connector_connector_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

connector_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

connector_relationship_id

NONE

NONE

Straight

NONE

40.9.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.9.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.9.8. Roles

There are no roles controlling access to this table.

40.10. couple

UUID

ent-d13c3285-c3af-4d4c-9f16-aa20e3da484b

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

couple

Table Signature

couple

Explicit Cluster Membership

Dictionary

Explicit Dependencies

stream coupler_stream_push entity couple

Export Element Instance

entity:couple

Derive Fragment Instance

relation:couple

Description

NONE

40.10.1. Properties

There are no deviant properties associated with this table.

40.10.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(couple_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

stream_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(46)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

s_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

t_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

s_origin

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

t_origin

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

with_override

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_failsafe

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_coupling

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_preserve

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_cascade

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_check

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

with_purge

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

purge_interval

INTERVAL

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

incremental

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

reload

SET( _reload_enum) The following are the only non-empty values allowed. File Pipe

NONE

NONE

NONE (USING COLUMN NAME)

without_deltrap

BOOLEAN

NONE

NONE

40.10.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.10.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

couple_id

model_id stream_id s_entity_id t_entity_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

couple_s_entity_id

model_id s_entity_id

NONE

NONE (USING CONSTRAINT NAME)

couple_stream_id

model_id stream_id

NONE

NONE (USING CONSTRAINT NAME)

couple_t_entity_id

model_id t_entity_id

NONE

40.10.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

bond

bond_couple_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

couple_s_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

stream

couple_stream_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

couple_t_entity_id

NONE

NONE

Straight

NONE

40.10.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

coupler_stream_push_couple

coupler_stream_push()

updating records

TRANSACTION

NONE

40.10.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.10.8. Roles

There are no roles controlling access to this table.

40.11. desktop

UUID

ent-f7eb962d-c513-48d5-a574-c83949de5697

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

desktop

Table Signature

desktop

Explicit Cluster Membership

Reflection

Explicit Dependencies

model

Export Element Instance

entity:desktop

Derive Fragment Instance

relation:desktop

Description

NONE

40.11.1. Properties

There are no deviant properties associated with this table.

40.11.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(desktop_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.11.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.11.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

desktop_id

model_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

desktop_model_id

model_id

NONE

40.11.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

cdmap

cdmap_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

link

link_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

field_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

sequence

sequence_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

template

template_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

lock

lock_desktop_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

model

desktop_model_id

NONE

NONE

Straight

NONE

40.11.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.11.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.11.8. Roles

There are no roles controlling access to this table.

40.12. domain

UUID

ent-3527d82b-8392-46c9-9126-2851315f7b1b

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

domain

Table Signature

domain

Explicit Cluster Membership

Dictionary

Explicit Dependencies

attribute

Export Element Instance

entity:domain

Derive Fragment Instance

relation:domain

Description

NONE

40.12.1. Properties

There are no deviant properties associated with this table.

40.12.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(domain_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_attribute_name

VARCHAR(63)

NONE

NONE

40.12.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

40.12.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

domain_id

model_id entity_id attribute_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

domain_unq

model_id entity_id attribute_id value

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

domain_attribute_id

model_id entity_id attribute_id

NONE

40.12.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

attribute

domain_attribute_id

NONE

NONE

Straight

NONE

40.12.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.12.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

domain

pgcat

pgcat_domain_feed

pgcat_database_name value

position

NONE

There are no TheonCoupler couples pulling content from this table.

40.12.8. Roles

There are no roles controlling access to this table.

40.13. eamap

UUID

ent-4204b180-3329-47f7-9850-c8cd7781fde6

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

eamap

Table Signature

eamap

Explicit Cluster Membership

Dictionary

Explicit Dependencies

entity attribute event

Export Element Instance

entity:eamap

Derive Fragment Instance

relation:eamap

Description

NONE

40.13.1. Properties

There are no deviant properties associated with this table.

40.13.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(eamap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

event_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_event_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_attribute_name

VARCHAR(63)

NONE

NONE

40.13.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

40.13.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

eamap_id

model_id entity_id event_id attribute_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

eamap_attribute_id

model_id entity_id attribute_id

NONE

NONE (USING CONSTRAINT NAME)

eamap_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

eamap_event_id

model_id entity_id event_id

NONE

40.13.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

attribute

eamap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

eamap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

event

eamap_event_id

NONE

NONE

Straight

NONE

40.13.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.13.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

eamap

pgcat

pgcat_eamap_feed

pgcat_database_name pgcat_event_name pgcat_attribute_name

NONE

There are no TheonCoupler couples pulling content from this table.

40.13.8. Roles

There are no roles controlling access to this table.

40.14. eemap

UUID

ent-aa7898ee-9414-4e2a-ad5b-d88fe9120672

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

eemap

Table Signature

eemap

Explicit Cluster Membership

Dictionary

Explicit Dependencies

model entity

Export Element Instance

entity:eemap

Derive Fragment Instance

relation:eemap

Description

NONE

40.14.1. Properties

There are no deviant properties associated with this table.

40.14.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(eemap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

needs_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_needs_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

40.14.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_forge_changeset

TEXT

NONE

NONE

40.14.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

eemap_id

model_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

eemap_unq

model_id entity_id needs_entity_id

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

eemap_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

eemap_model_id

model_id

NONE

NONE (USING CONSTRAINT NAME)

eemap_needs_entity_id

model_id needs_entity_id

NONE

40.14.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

eemap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

eemap_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

eemap_needs_entity_id

NONE

NONE

Straight

NONE

40.14.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.14.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

eemap

pgcat

pgcat_eemap_feed

pgcat_database_name pgcat_name pgcat_needs_name

NONE

eemap

forge

forge_eemap_feed

pgcat_database_name pgcat_name pgcat_needs_name

NONE

There are no TheonCoupler couples pulling content from this table.

40.14.8. Roles

There are no roles controlling access to this table.

40.15. entity

UUID

ent-9ad0c429-2bf9-4049-9594-738bb9b33e8c

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

entity

Table Signature

entity

Explicit Cluster Membership

Reflection Dictionary

Explicit Dependencies

model derived_stream_push entity

Export Element Instance

entity:entity

Derive Fragment Instance

relation:entity

Description

NONE

40.15.1. Properties

There are no deviant properties associated with this table.

40.15.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(entity_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Function Sequence Table View EventFunction TableFunction Type Index Container Enumerate Domain

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

content

SET( _content_enum) The following are the only non-empty values allowed. SQL PLPGSQL External

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

overload

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.15.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_coupler_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_forge_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_derived_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_tag_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_tag_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_name_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_summary_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_summary_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_description_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_description_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_content_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_content_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_value_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_value_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_overload_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_overload_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_name_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_entity_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_entity_name_changedby

TEXT

NONE

NONE

40.15.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

entity_id

model_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

entity_model_id

model_id

NONE

40.15.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

panel

panel_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

key

key_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

relationship_f_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

relationship_p_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

attribute

attribute_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

event

event_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

event

event_process_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

eamap

eamap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

stream

stream_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

couple

couple_s_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

couple

couple_t_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

bond

bond_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

akmap

akmap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

eemap

eemap_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

eemap

eemap_needs_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

capability

capability_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

cemap

cemap_entity_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

model

entity_model_id

NONE

NONE

Straight

NONE

40.15.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

derived_stream_push_entity

derived_stream_push()

adding new records updating records

RECORD

NONE

40.15.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

entity

Derived

derived_entity_feed

model_id

pgcat_entity_name

NONE

entity

pgcat

pgcat_entity_feed

pgcat_database_name pgcat_entity_name

pgcat_name

NONE

entity

coupler

coupler_entity_feed

pgcat_database_name pgcat_entity_name

tag

NONE

entity

forge

forge_entity_feed

pgcat_database_name pgcat_entity_name

pgcat_name

NONE

There are no TheonCoupler couples pulling content from this table.

40.15.8. Roles

There are no roles controlling access to this table.

40.16. event

UUID

ent-b7393332-39eb-46eb-85bb-0fd7f440acc2

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

event

Table Signature

event

Explicit Cluster Membership

Dictionary

Explicit Dependencies

entity event

Export Element Instance

entity:event

Derive Fragment Instance

relation:event

Description

NONE

40.16.1. Properties

There are no deviant properties associated with this table.

40.16.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(event_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

timing

SET( _timing_enum) The following are the only non-empty values allowed. After Before

NONE

NONE

NONE (USING COLUMN NAME)

on_create

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

on_delete

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

on_modify

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

extent

SET( _extent_enum) The following are the only non-empty values allowed. Once Each

NONE

NONE

NONE (USING COLUMN NAME)

deferred

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

process_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_process_entity_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.16.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_forge_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_timing_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_timing_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_on_create_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_on_create_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_on_delete_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_on_delete_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_on_modify_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_on_modify_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_value_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_value_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_extent_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_extent_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_deferred_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deferred_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

40.16.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

event_id

model_id entity_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

event_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

event_process_entity_id

model_id process_entity_id

NONE

40.16.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

eamap

eamap_event_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

event_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

event_process_entity_id

NONE

NONE

Straight

NONE

40.16.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.16.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

event

pgcat

pgcat_event_feed

pgcat_database_name pgcat_process_entity_name pgcat_name

timing

NONE

event

forge

forge_event_feed

pgcat_database_name pgcat_name

timing

NONE

There are no TheonCoupler couples pulling content from this table.

40.16.8. Roles

There are no roles controlling access to this table.

40.17. field

UUID

ent-db8ffdcb-fcf2-4f1d-8764-657cc074d61f

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

field

Table Signature

field

Explicit Cluster Membership

Reflection

Explicit Dependencies

link panel presenter ui_panel_connector attribute connector desktop

Export Element Instance

entity:field

Derive Fragment Instance

relation:field

Description

NONE

40.17.1. Properties

There are no deviant properties associated with this table.

40.17.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(field_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

connector_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

presenter_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

hidden

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

readonly

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

preserve

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

dropdown

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

shortcut

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

bundle

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

legend

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

width

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

height

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

link

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

link_uri

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

xref_field_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

desktop_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_panel_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_field_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.17.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.17.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

field_id

model_id panel_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

field_attribute_id

model_id attribute_entity_id attribute_id

NONE

NONE (USING CONSTRAINT NAME)

field_connector_id

model_id panel_id connector_id

NONE

NONE (USING CONSTRAINT NAME)

field_desktop_id

model_id desktop_id

NONE

NONE (USING CONSTRAINT NAME)

field_link_field_id

model_id link_panel_id link_field_id

NONE

NONE (USING CONSTRAINT NAME)

field_link_id

model_id desktop_id link_panel_id link_id

NONE

NONE (USING CONSTRAINT NAME)

field_panel_id

model_id panel_id

NONE

NONE (USING CONSTRAINT NAME)

field_presenter_id

model_id panel_id presenter_id

NONE

NONE (USING CONSTRAINT NAME)

field_ui_panel_connector_id

model_id panel_id connector_id attribute_entity_id

Virtual (non-realised) relationship for use by UI desktop panel.

NONE (USING CONSTRAINT NAME)

field_xref_field_id

model_id panel_id xref_field_id

NONE

40.17.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

field

field_link_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

field_xref_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

sequence

sequence_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

template

template_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

lock

lock_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

lock

lock_link_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

lock

lock_xref_field_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

attribute

field_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

connector

field_connector_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

desktop

field_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

field_link_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

link

field_link_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

field_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

presenter

field_presenter_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

ui_panel_connector

field_ui_panel_connector_id

NONE

NONE

Straight

Virtual (non-realised) relationship for use by UI desktop panel.

NONE (USING CONSTRAINT NAME)

field

field_xref_field_id

NONE

NONE

Straight

NONE

40.17.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.17.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.17.8. Roles

There are no roles controlling access to this table.

40.18. forge_attribute_feed

UUID

ent-d940c11c-628e-4116-aa9e-70bb390f9dc5

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

forge_attribute_feed

Table Signature

forge_attribute_feed

Explicit Cluster Membership

NONE

Explicit Dependencies

attribute

Export Element Instance

entity:forge_attribute_feed

Derive Fragment Instance

relation:forge_attribute_feed

Description

NONE

40.18.1. Properties

There are no deviant properties associated with this table.

40.18.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

database_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

entity_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

size

FLOAT

NONE

NONE

NONE (USING COLUMN NAME)

mandatory

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

multiple

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

system_type

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

type

CUSTOM(_th_attribute_type_enum)

NONE

NONE

NONE (USING COLUMN NAME)

content

CUSTOM(_th_attribute_content_enum)

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

NONE

NONE

40.18.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.18.4. Keys

There are no primary keys in this table.

There are no unique keys in this table.

There are no foreign keys in this table.

40.18.5. Links

There are no forward links from this table.

There are no reverse links from this table.

40.18.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.18.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

The following are the TheonCoupler couples pulling content from this table.

Couple Name Owning Stream Target Table Handle Columns Paired Columns Description

attribute

forge

attribute

database_name name

database_name size

NONE

40.18.8. Roles

There are no roles controlling access to this table.

40.19. forge_eemap_feed

UUID

ent-1e9e5320-f95a-42d9-92e3-bc9cca8040ba

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

forge_eemap_feed

Table Signature

forge_eemap_feed

Explicit Cluster Membership

NONE

Explicit Dependencies

NONE

Export Element Instance

entity:forge_eemap_feed

Derive Fragment Instance

relation:forge_eemap_feed

Description

NONE

40.19.1. Properties

There are no deviant properties associated with this table.

40.19.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

entity_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

database_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

40.19.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.19.4. Keys

There are no primary keys in this table.

There are no unique keys in this table.

There are no foreign keys in this table.

40.19.5. Links

There are no forward links from this table.

There are no reverse links from this table.

40.19.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.19.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

The following are the TheonCoupler couples pulling content from this table.

Couple Name Owning Stream Target Table Handle Columns Paired Columns Description

eemap

forge

eemap

database_name entity_name name

database_name entity_name name

NONE

40.19.8. Roles

There are no roles controlling access to this table.

40.20. forge_entity_feed

UUID

ent-2ea72cc6-4dd7-47b1-be77-cfd27bcc126a

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

forge_entity_feed

Table Signature

forge_entity_feed

Explicit Cluster Membership

NONE

Explicit Dependencies

entity

Export Element Instance

entity:forge_entity_feed

Derive Fragment Instance

relation:forge_entity_feed

Description

NONE

40.20.1. Properties

There are no deviant properties associated with this table.

40.20.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

entity_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

database_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

type

CUSTOM(_th_entity_type_enum)

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

content

CUSTOM(_th_entity_content_enum)

NONE

NONE

NONE (USING COLUMN NAME)

overload

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

NONE

NONE

40.20.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.20.4. Keys

There are no primary keys in this table.

There are no unique keys in this table.

There are no foreign keys in this table.

40.20.5. Links

There are no forward links from this table.

There are no reverse links from this table.

40.20.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.20.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

The following are the TheonCoupler couples pulling content from this table.

Couple Name Owning Stream Target Table Handle Columns Paired Columns Description

entity

forge

entity

database_name entity_name

database_name name

NONE

40.20.8. Roles

There are no roles controlling access to this table.

40.21. forge_event_feed

UUID

ent-aaed26a7-a524-4d32-8972-6724e3dfb3cb

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

forge_event_feed

Table Signature

forge_event_feed

Explicit Cluster Membership

NONE

Explicit Dependencies

event

Export Element Instance

entity:forge_event_feed

Derive Fragment Instance

relation:forge_event_feed

Description

NONE

40.21.1. Properties

There are no deviant properties associated with this table.

40.21.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

database_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

entity_name

CUSTOM(information_schema.sql_identifier)

NONE

NONE

NONE (USING COLUMN NAME)

timing

CUSTOM(_th_event_timing_enum)

NONE

NONE

NONE (USING COLUMN NAME)

on_create

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

on_delete

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

on_modify

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

extent

CUSTOM(_th_event_extent_enum)

NONE

NONE

NONE (USING COLUMN NAME)

deferred

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

process_entity_name

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

NONE

NONE

40.21.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.21.4. Keys

There are no primary keys in this table.

There are no unique keys in this table.

There are no foreign keys in this table.

40.21.5. Links

There are no forward links from this table.

There are no reverse links from this table.

40.21.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.21.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

The following are the TheonCoupler couples pulling content from this table.

Couple Name Owning Stream Target Table Handle Columns Paired Columns Description

event

forge

event

database_name name

database_name timing database_name

NONE

40.21.8. Roles

There are no roles controlling access to this table.

40.22. key

UUID

ent-d3687776-474a-4796-b4e1-a0f7e612ed2f

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

key

Table Signature

key

Explicit Cluster Membership

Dictionary

Explicit Dependencies

entity key

Export Element Instance

entity:key

Derive Fragment Instance

relation:key

Description

NONE

40.22.1. Properties

There are no deviant properties associated with this table.

40.22.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(key_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Primary Unique Through Auxiliary

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_entity_name

VARCHAR(80)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.22.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

40.22.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

key_id

model_id entity_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

key_entity_id

model_id entity_id

NONE

40.22.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

relationship

relationship_p_key_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

akmap

akmap_key_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

key_entity_id

NONE

NONE

Straight

NONE

40.22.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.22.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

key

pgcat

pgcat_key_feed

pgcat_database_name pgcat_name

type

NONE

There are no TheonCoupler couples pulling content from this table.

40.22.8. Roles

There are no roles controlling access to this table.

40.23. link

UUID

ent-5f0d8ae7-ac06-4946-b03d-6c9238705a95

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

link

Table Signature

link

Explicit Cluster Membership

Reflection

Explicit Dependencies

model relationship panel desktop

Export Element Instance

entity:link

Derive Fragment Instance

relation:link

Description

NONE

40.23.1. Properties

There are no deviant properties associated with this table.

40.23.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(link_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

desktop_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

label

TEXT

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

link_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_panel_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

relationship_entity_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_key_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

relationship_f_entity_id

INTEGER

NONE

NONE

40.23.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.23.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

link_id

model_id desktop_id panel_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

link_label_unq

model_id desktop_id label

NONE

NONE (USING CONSTRAINT NAME)

link_position_unq

model_id desktop_id position

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

link_desktop_id

model_id desktop_id

NONE

NONE (USING CONSTRAINT NAME)

link_link_id

model_id desktop_id link_panel_id link_id

NONE

NONE (USING CONSTRAINT NAME)

link_panel_id

model_id panel_id

NONE

NONE (USING CONSTRAINT NAME)

link_relationship_id

model_id relationship_entity_id relationship_key_id relationship_f_entity_id relationship_id

NONE

40.23.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

link

link_link_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

field_link_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

lock

lock_link_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

desktop

link_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

link

link_link_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

link_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

link_relationship_id

NONE

NONE

Straight

NONE

40.23.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.23.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.23.8. Roles

There are no roles controlling access to this table.

40.24. lock

UUID

ent-df05b0df-0bd4-4c18-83e7-7396ce7f8bb1

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

lock

Table Signature

lock

Explicit Cluster Membership

Reflection

Explicit Dependencies

link panel field desktop

Export Element Instance

entity:lock

Derive Fragment Instance

relation:lock

Description

NONE

40.24.1. Properties

There are no deviant properties associated with this table.

40.24.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(lock_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

field_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

dynamic

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

lookup

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

sticky

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

xref_field_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

desktop_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_panel_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

link_field_id

INTEGER

NONE

NONE

40.24.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.24.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

lock_id

model_id panel_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

lock_desktop_id

model_id desktop_id

NONE

NONE (USING CONSTRAINT NAME)

lock_field_id

model_id panel_id field_id

NONE

NONE (USING CONSTRAINT NAME)

lock_link_field_id

model_id link_panel_id link_field_id

NONE

NONE (USING CONSTRAINT NAME)

lock_link_id

model_id desktop_id link_panel_id link_id

NONE

NONE (USING CONSTRAINT NAME)

lock_panel_id

model_id panel_id

NONE

NONE (USING CONSTRAINT NAME)

lock_xref_field_id

model_id panel_id xref_field_id

NONE

40.24.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

desktop

lock_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

lock_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

lock_link_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

link

lock_link_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

lock_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

lock_xref_field_id

NONE

NONE

Straight

NONE

40.24.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.24.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.24.8. Roles

There are no roles controlling access to this table.

40.25. model

UUID

ent-27aa6900-2c44-4c40-a71e-f7ae61747271

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

model

Table Signature

model

Explicit Cluster Membership

Reflection Dictionary

Explicit Dependencies

coupler_stream_push

Export Element Instance

entity:model

Derive Fragment Instance

relation:model

Description

NONE

40.25.1. Properties

There are no deviant properties associated with this table.

40.25.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(model_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

namespace

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

location

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

WITHOUT_EMPTY

'undefined'

NONE

NONE (USING COLUMN NAME)

pgcat_hostname

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

requires

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

prefix

TEXT

'_th_'::text

NONE

NONE (USING COLUMN NAME)

pgcat_catalog_name

TEXT

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_schema_name

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

extension_name

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

extension_version

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

extension_schema

TEXT

NONE

NONE

40.25.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_name_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_requires_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_requires_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_catalog_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_catalog_name_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_schema_name_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_schema_name_changedby

TEXT

NONE

NONE

40.25.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

model_id

id

NONE

There are no unique keys in this table.

There are no foreign keys in this table.

40.25.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

cluster

cluster_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

desktop

desktop_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

cdmap

cdmap_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

entity_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

panel_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

relationship_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

role

role_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

stream

stream_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

eemap

eemap_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

cemap

cemap_model_id

NONE

NONE

Straight

NONE

There are no reverse links from this table.

40.25.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

coupler_stream_push_model

coupler_stream_push()

updating records

RECORD

NONE

40.25.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

model

pgcat

pgcat_model_feed

tag

pgcat_name

NONE

There are no TheonCoupler couples pulling content from this table.

40.25.8. Roles

There are no roles controlling access to this table.

40.26. pair

UUID

ent-4db772d0-a868-499a-97e3-dbef06ef09e8

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

pair

Table Signature

pair

Explicit Cluster Membership

Dictionary

Explicit Dependencies

coupler_stream_push bond attribute

Export Element Instance

entity:pair

Derive Fragment Instance

relation:pair

Description

NONE

40.26.1. Properties

There are no deviant properties associated with this table.

40.26.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(pair_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

stream_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

couple_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

bond_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

s_attribute_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

s_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

s_value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

t_attribute_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

t_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

v_attribute_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

v_entity_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

l_value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

without_override

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

40.26.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.26.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

pair_id

model_id stream_id couple_id bond_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

pair_bond_id

model_id stream_id s_entity_id t_entity_id couple_id bond_id

NONE

NONE (USING CONSTRAINT NAME)

pair_s_attribute_id

model_id s_entity_id s_attribute_id

NONE

NONE (USING CONSTRAINT NAME)

pair_t_attribute_id

model_id t_entity_id t_attribute_id

NONE

NONE (USING CONSTRAINT NAME)

pair_v_attribute_id

model_id v_entity_id v_attribute_id

NONE

40.26.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

bond

pair_bond_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

attribute

pair_s_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

attribute

pair_t_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

attribute

pair_v_attribute_id

NONE

NONE

Straight

NONE

40.26.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

coupler_stream_push_all_pair

coupler_stream_push()

adding new records deleting records

STATEMENT

NONE

NONE (USING TRIGGER NAME)

coupler_stream_push_pair

coupler_stream_push()

updating records

TRANSACTION

NONE

40.26.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.26.8. Roles

There are no roles controlling access to this table.

40.27. panel

UUID

ent-7cc7f211-2f79-4b03-b06a-d29b6142ef6a

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

panel

Table Signature

panel

Explicit Cluster Membership

Reflection

Explicit Dependencies

model panel entity

Export Element Instance

entity:panel

Derive Fragment Instance

relation:panel

Description

NONE

40.27.1. Properties

There are no deviant properties associated with this table.

40.27.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(panel_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

selector

SET( _selector_enum) The following are the only non-empty values allowed. Keyboard None Tab Scroll

NONE

NONE

NONE (USING COLUMN NAME)

without_append

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

without_delete

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

with_strech

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.27.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.27.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

panel_id

model_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

panel_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

panel_model_id

model_id

NONE

40.27.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

link

link_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

presenter

presenter_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

connector

connector_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

field_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

sequence

sequence_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

template

template_panel_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

lock

lock_panel_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

panel_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

panel_model_id

NONE

NONE

Straight

NONE

40.27.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.27.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.27.8. Roles

There are no roles controlling access to this table.

40.28. presenter

UUID

ent-7e808a12-976f-4906-bc4b-7600a28c0bc6

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

presenter

Table Signature

presenter

Explicit Cluster Membership

Reflection

Explicit Dependencies

panel presenter

Export Element Instance

entity:presenter

Derive Fragment Instance

relation:presenter

Description

NONE

40.28.1. Properties

There are no deviant properties associated with this table.

40.28.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(presenter_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Field DropSelect Grid GridSelect

NONE

NONE

NONE (USING COLUMN NAME)

pivot

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

pivot_limit

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

height

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

small

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

label

TEXT

WITHOUT_EMPTY

NONE

NONE

40.28.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.28.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

presenter_id

model_id panel_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

presenter_panel_id

model_id panel_id

NONE

40.28.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

field

field_presenter_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

panel

presenter_panel_id

NONE

NONE

Straight

NONE

40.28.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.28.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.28.8. Roles

There are no roles controlling access to this table.

40.29. profile

UUID

ent-a995d2d8-d0a9-47c2-a178-bc23956ec962

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

profile

Table Signature

profile

Explicit Cluster Membership

NONE

Explicit Dependencies

NONE

Export Element Instance

entity:profile

Derive Fragment Instance

relation:profile

Description

NONE

40.29.1. Properties

There are no deviant properties associated with this table.

40.29.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(profile_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_tag

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

tree

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

uri

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

ns_uri

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

instance

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

here

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

database

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

host

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

port

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

hostaddr

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

service

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

username

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

password

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

tag

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

prefix

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

schema

TEXT

NONE

NONE

40.29.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.29.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

profile_id

id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

profile_unq

model_tag

NONE

There are no foreign keys in this table.

40.29.5. Links

There are no forward links from this table.

There are no reverse links from this table.

40.29.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.29.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.29.8. Roles

There are no roles controlling access to this table.

40.30. rakmap

UUID

ent-5cffb5c8-14e8-4131-9aca-11276797deba

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

rakmap

Table Signature

rakmap

Explicit Cluster Membership

Dictionary

Explicit Dependencies

relationship attribute akmap

Export Element Instance

entity:rakmap

Derive Fragment Instance

relation:rakmap

Description

NONE

40.30.1. Properties

There are no deviant properties associated with this table.

40.30.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(rakmap_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

relationship_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

akmap_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

relationship_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

relationship_key_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

akmap_attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

attribute_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

relationship_f_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_relationship_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_p_entity_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_p_key_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_p_attribute_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_f_entity_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_f_attribute_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

position

INTEGER

NONE

NONE

40.30.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_position_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_position_changedby

TEXT

NONE

NONE

40.30.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

rakmap_id

relationship_id model_id id

NONE

The following are the unique keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

rakmap_unq

model_id relationship_id relationship_entity_id relationship_key_id akmap_attribute_id

NONE

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

rakmap_akmap_id

model_id relationship_entity_id akmap_attribute_id relationship_key_id akmap_id

NONE

NONE (USING CONSTRAINT NAME)

rakmap_attribute_id

model_id relationship_f_entity_id attribute_id

NONE

NONE (USING CONSTRAINT NAME)

rakmap_relationship_id

model_id relationship_entity_id relationship_key_id relationship_f_entity_id relationship_id

NONE

40.30.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

akmap

rakmap_akmap_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

attribute

rakmap_attribute_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

relationship

rakmap_relationship_id

NONE

NONE

Straight

NONE

40.30.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.30.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

rakmap

pgcat

pgcat_rakmap_feed

pgcat_database_name pgcat_p_entity_name pgcat_f_entity_name

position

NONE

There are no TheonCoupler couples pulling content from this table.

40.30.8. Roles

There are no roles controlling access to this table.

40.31. relationship

UUID

ent-2c82d8bc-87a9-4183-8206-a91475ff00d7

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

relationship

Table Signature

relationship

Explicit Cluster Membership

Reflection Dictionary

Explicit Dependencies

model relationship entity key

Export Element Instance

entity:relationship

Derive Fragment Instance

relation:relationship

Description

NONE

40.31.1. Properties

There are no deviant properties associated with this table.

40.31.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(relationship_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Around Straight Through

NONE

NONE

NONE (USING COLUMN NAME)

cardinality

SET( _cardinality_enum) The following are the only non-empty values allowed. 1:1 1:N M:N

NONE

NONE

NONE (USING COLUMN NAME)

ordinality

SET( _ordinality_enum) The following are the only non-empty values allowed. 0:0 0:1 1:0 1:1

NONE

NONE

NONE (USING COLUMN NAME)

p_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

p_key_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

p_name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

p_summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

p_description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

f_entity_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

f_name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

f_summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

f_description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_p_entity_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_p_key_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_f_entity_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

ondelete

SET( _ondelete_enum) The following are the only non-empty values allowed. Cascade Restrict Set Null Set Default No Action

NONE

NONE

NONE (USING COLUMN NAME)

onupdate

SET( _onupdate_enum) The following are the only non-empty values allowed. Cascade Restrict Set Null Set Default No Action

NONE

NONE

40.31.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_type_changedby

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

40.31.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

relationship_id

model_id p_entity_id p_key_id f_entity_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

relationship_f_entity_id

model_id f_entity_id

NONE

NONE (USING CONSTRAINT NAME)

relationship_model_id

model_id

NONE

NONE (USING CONSTRAINT NAME)

relationship_p_entity_id

model_id p_entity_id

NONE

NONE (USING CONSTRAINT NAME)

relationship_p_key_id

model_id p_entity_id p_key_id

NONE

40.31.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

link

link_relationship_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

connector

connector_relationship_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

bond

bond_relationship_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

rakmap

rakmap_relationship_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

relationship_f_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

relationship_model_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

entity

relationship_p_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

key

relationship_p_key_id

NONE

NONE

Straight

NONE

40.31.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.31.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

relationship

pgcat

pgcat_relationship_feed

pgcat_database_name pgcat_name pgcat_p_entity_name pgcat_p_key_name pgcat_f_entity_name

type

NONE

There are no TheonCoupler couples pulling content from this table.

40.31.8. Roles

There are no roles controlling access to this table.

40.32. role

UUID

ent-3041de3e-1d47-42f8-a776-1dbf39578077

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

role

Table Signature

role

Explicit Cluster Membership

Dictionary

Explicit Dependencies

model

Export Element Instance

entity:role

Derive Fragment Instance

relation:role

Description

NONE

40.32.1. Properties

There are no deviant properties associated with this table.

40.32.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(role_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

supervisor

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

pgcat_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

pgcat_database_name

VARCHAR(63)

NONE

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

40.32.3. TheonCoupler Columns

The following are the automatically maintained TheonCoupler columns in this table in pseudo positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

_th_increment

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

_th_createdat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_deletedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_pgcat_changeset

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedat

TIMESTAMP

NONE

NONE

NONE (USING COLUMN NAME)

_th_realise_changedby

TEXT

NONE

NONE

40.32.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

role_id

model_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

role_model_id

model_id

NONE

40.32.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

capability

capability_role_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

camap

camap_role_id

NONE

NONE

Through

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

model

role_model_id

NONE

NONE

Straight

NONE

40.32.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.32.7. TheonCoupler Couples

The following are the TheonCoupler couples pushing content into this table.

Couple Name Owning Stream Source Entity Handle Columns Paired Columns Description

role

pgcat

pgcat_role_feed

pgcat_database_name pgcat_name

realise

NONE

There are no TheonCoupler couples pulling content from this table.

40.32.8. Roles

There are no roles controlling access to this table.

40.33. sequence

UUID

ent-29017adb-e018-4774-a7d1-1c71edffa442

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

sequence

Table Signature

sequence

Explicit Cluster Membership

Reflection

Explicit Dependencies

sequence panel field desktop

Export Element Instance

entity:sequence

Derive Fragment Instance

relation:sequence

Description

NONE

40.33.1. Properties

There are no deviant properties associated with this table.

40.33.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(sequence_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

field_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

desktop_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Order Ascending Order Descending

NONE

NONE

NONE (USING COLUMN NAME)

tier

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

lookup

BOOLEAN

NONE

NONE

40.33.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.33.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

sequence_id

model_id panel_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

sequence_desktop_id

model_id desktop_id

NONE

NONE (USING CONSTRAINT NAME)

sequence_field_id

model_id panel_id field_id

NONE

NONE (USING CONSTRAINT NAME)

sequence_panel_id

model_id panel_id

NONE

40.33.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

desktop

sequence_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

sequence_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

sequence_panel_id

NONE

NONE

Straight

NONE

40.33.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.33.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.33.8. Roles

There are no roles controlling access to this table.

40.34. stream

UUID

ent-5eb73e67-556b-4e92-b432-a33cb18bb10f

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

stream

Table Signature

stream

Explicit Cluster Membership

Dictionary

Explicit Dependencies

model stream coupler_stream_push entity

Export Element Instance

entity:stream

Derive Fragment Instance

relation:stream

Description

NONE

40.34.1. Properties

There are no deviant properties associated with this table.

40.34.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(stream_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

tag

VARCHAR(25)

NONE

NONE

NONE (USING COLUMN NAME)

name

VARCHAR(79)

NONE

NONE

NONE (USING COLUMN NAME)

summary

VARCHAR(127)

NONE

NONE

NONE (USING COLUMN NAME)

description

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

entity_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

format

SET( _format_enum) The following are the only non-empty values allowed. Copy CSV CSVinEmail Internal XLS XLSinEmail

NONE

NONE

NONE (USING COLUMN NAME)

incremental

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

skip

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

options

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

origin

VARCHAR(25)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

serial

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

realise

BOOLEAN

true

NONE

NONE (USING COLUMN NAME)

uuid

TEXT

uuid_generate_v4()

NONE

NONE (USING COLUMN NAME)

source

SET( _source_enum) The following are the only non-empty values allowed. File Pipe

NONE

NONE

40.34.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.34.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

stream_id

model_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

stream_entity_id

model_id entity_id

NONE

NONE (USING CONSTRAINT NAME)

stream_model_id

model_id

NONE

40.34.5. Links

The following are the forward links from this table.

Link Name Down to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

couple

couple_stream_id

NONE

NONE

Straight

NONE

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

entity

stream_entity_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

model

stream_model_id

NONE

NONE

Straight

NONE

40.34.6. Events

There are no events preceeding content change in this table.

The following are the events following content change in this table in processing order.

Event Name Trigger Name Processed By EventFunction On For Each Description

NONE (USING TRIGGER NAME)

coupler_stream_push_stream

coupler_stream_push()

updating records

TRANSACTION

NONE

40.34.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.34.8. Roles

There are no roles controlling access to this table.

40.35. template

UUID

ent-b1231339-38eb-4e74-a22b-d13e287ecb95

Relation Type

TABLE

Relation Name

NONE (USING TABLE NAME)

Table Name

template

Table Signature

template

Explicit Cluster Membership

Reflection

Explicit Dependencies

panel template field desktop

Export Element Instance

entity:template

Derive Fragment Instance

relation:template

Description

NONE

40.35.1. Properties

There are no deviant properties associated with this table.

40.35.2. Columns

The following are the columns in this table in positional order.

Attribute Name Column Name Type Properties Default Description

NONE (USING COLUMN NAME)

id

SERIAL(template_id_seq)

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

model_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

panel_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

field_id

INTEGER

WITHOUT_EMPTY

NONE

NONE

NONE (USING COLUMN NAME)

desktop_id

INTEGER

NONE

NONE

NONE (USING COLUMN NAME)

type

SET( _type_enum) The following are the only non-empty values allowed. Exact Match Hook Both Hook Left Hook Right No Hook

NONE

NONE

NONE (USING COLUMN NAME)

invert

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

connector

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

dynamic

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

value

TEXT

NONE

NONE

NONE (USING COLUMN NAME)

lookup

BOOLEAN

NONE

NONE

NONE (USING COLUMN NAME)

bank

INTEGER

NONE

NONE

40.35.3. TheonCoupler Columns

There are no automatically maintained TheonCoupler columns in this table.

40.35.4. Keys

The following are the primary keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

template_id

model_id panel_id id

NONE

There are no unique keys in this table.

The following are the foreign keys in this table.

Key Name Constraint Name Constituent Columns Description

NONE (USING CONSTRAINT NAME)

template_desktop_id

model_id desktop_id

NONE

NONE (USING CONSTRAINT NAME)

template_field_id

model_id panel_id field_id

NONE

NONE (USING CONSTRAINT NAME)

template_panel_id

model_id panel_id

NONE

40.35.5. Links

There are no forward links from this table.

The following are the reverse links from this table.

Link Name Up to Table With Foreign Key Constraint Cardinality Ordinality Type Description

NONE (USING CONSTRAINT NAME)

desktop

template_desktop_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

field

template_field_id

NONE

NONE

Straight

NONE

NONE (USING CONSTRAINT NAME)

panel

template_panel_id

NONE

NONE

Straight

NONE

40.35.6. Events

There are no events preceeding content change in this table.

There are no events following content change in this table.

40.35.7. TheonCoupler Couples

There are no TheonCoupler couples pushing content into this table.

There are no TheonCoupler couples pulling content from this table.

40.35.8. Roles

There are no roles controlling access to this table.