Chapter 51. Desktops

51.1. Clustering

UUID

des-77fdfab8-38b8-4d82-b113-d2d443d27e20

Desktop Name

Clustering

Explicit Cluster Membership

NONE

Description

NONE

51.1.1. Panels

The following are the panels on this desktop in presentational order.

Name Parent Related By Description

Choose Model

NONE

NONE

The "Choose Model" Panel is for selection of the parent model against which all other panels on the owning desktop operate.

Cluster & Entities

Choose Model

cluster_model_id

The Cluster & Entities panel allows clusters to be added and updated and each cluster’s entities to be maintained (new ones added and existing ones removed).

Cluster & Desktops

Choose Model

cluster_model_id

The Cluster & Desktops panel allows clusters to be added and updated and each cluster’s desktops to be maintained (new ones added and existing ones removed).

51.1.2. Templates

There are no templates used on this desktop.

51.1.3. Sequences

The following are the sequences used on this desktop.

Desktop Panel Type Field Slice Tier

Cluster & Desktops

UP ORDERING OF

3 - Cluster-Label

AT ALL TIMES

1

Cluster & Desktops

UP ORDERING OF

12 - ? Parent

IN LOOKUP

NONE

Cluster & Desktops

UP ORDERING OF

18 - ? Desktop

IN LOOKUP

NONE

Cluster & Desktops

UP ORDERING OF

19 - [desktop.name]

AT ALL TIMES

2

Cluster & Entities

UP ORDERING OF

3 - Cluster-Label

AT ALL TIMES

1

Cluster & Entities

UP ORDERING OF

12 - ? Parent

IN LOOKUP

NONE

Cluster & Entities

UP ORDERING OF

18 - ? Entity

IN LOOKUP

NONE

Cluster & Entities

UP ORDERING OF

19 - [entity.pgcat_name]

AT ALL TIMES

2

Choose Model

UP ORDERING OF

3 - Model-Label

AT ALL TIMES

1

Choose Model

UP ORDERING OF

7 - Cluster-Label

AT ALL TIMES

2

Choose Model

UP ORDERING OF

12 - ? Parent

IN LOOKUP

NONE

51.1.4. Locks

The following are the locks used on this desktop.

Desktop Panel Field Source Value Reference Panel Reference Field Slice Properties

Cluster & Desktops

14 - [cdmap.model_id]

SET FROM REFERENCE

8 - [cluster.model_id]

AT ALL TIMES

Cluster & Entities

14 - [cemap.model_id]

SET FROM REFERENCE

8 - [cluster.model_id]

AT ALL TIMES

Choose Model

8 - [cluster.model_id]

SET FROM REFERENCE

1 - Model-ID

AT ALL TIMES

51.2. Dictionary

UUID

des-5cd85c5f-bf9a-4ae2-b6ae-10900e5feb59

Desktop Name

Dictionary

Explicit Cluster Membership

NONE

Description

The Dictionary Desktop is for the configuration of those parts of the model that will result in structure in a PostgreSQL physical database.

51.2.1. Panels

The following are the panels on this desktop in presentational order.

Name Parent Related By Description

Model

NONE

NONE

The Model panel allows selection, creation and update of the model against which all other panels operate. Also lists and allows maintenance of the very basic details of) all the entities, roles and streams associated with the model.

Entity

Model

entity_model_id

The Entity panel allows new entities to be added and existing entities modified (or deleted) for the currently selected model.

Attribute

Entity

attribute_entity_id

The Attribute panel allows new attributes to be added and existing attributes modified (or deleted) for the currently selected entity.

Key

Entity

key_entity_id

The Key panel allows new keys to be added and existing keys modified (or deleted) for the currently selected entity.

Relationship

Entity

relationship_f_entity_id

The Relationship panel allows new relationships to be added and existing relationships modified (or deleted) for the currently selected entity (as the foreign entity in a constraint).

Event

Entity

event_entity_id

The Event panel allows new events to be added and existing events modified (or deleted) for the currently selected entity.

Requires

Entity

eemap_entity_id

The Requires panel allows new entity requirements (dependencies on other entities) to be added and existing requirements modified (or deleted) for the currently selected entity.

51.2.2. Templates

The following are the templates used on this desktop.

Desktop Panel Type Field Rule Value Slice Properties

Key

COMPARISON OF

20 - [attribute.type]

IS EQ TO

Column

IN LOOKUP

Event

COMPARISON OF

20 - [entity.type]

IS EQ TO

EventFunction

IN LOOKUP

Relationship

COMPARISON OF

45 - [attribute.type]

IS EQ TO

Column

AT ALL TIMES

Relationship

COMPARISON OF

52 - [attribute.type]

IS EQ TO

Column

AT ALL TIMES

51.2.3. Sequences

The following are the sequences used on this desktop.

Desktop Panel Type Field Slice Tier

Model

UP ORDERING OF

14 - Import Handle

AT ALL TIMES

1

Model

UP ORDERING OF

16 - Name[Realised]

AT ALL TIMES

2

Key

UP ORDERING OF

5 - Name[Realised]

AT ALL TIMES

1

Key

UP ORDERING OF

12 - Position

AT ALL TIMES

2

Key

UP ORDERING OF

19 - ? Column

IN LOOKUP

NONE

Event

UP ORDERING OF

5 - Name[Realised]

AT ALL TIMES

1

Event

UP ORDERING OF

19 - ? Processing Entity

IN LOOKUP

NONE

Event

UP ORDERING OF

29 - ? Column

IN LOOKUP

NONE

Event

UP ORDERING OF

30 - [attribute.pgcat_name]

AT ALL TIMES

2

Entity

UP ORDERING OF

4 - Name[Realised]

AT ALL TIMES

1

Entity

UP ORDERING OF

15 - Position

AT ALL TIMES

2

Attribute

UP ORDERING OF

3 - Name[Realised]

AT ALL TIMES

1

Attribute

UP ORDERING OF

15 - Placement[Realised]

AT ALL TIMES

2

Attribute

UP ORDERING OF

18 - Position

AT ALL TIMES

3

Attribute

UP ORDERING OF

19 - Value

AT ALL TIMES

4

Relationship

UP ORDERING OF

7 - Name[Realised]

AT ALL TIMES

1

Relationship

UP ORDERING OF

17 - ? Reference Entity

IN LOOKUP

NONE

Relationship

UP ORDERING OF

22 - ? Reference Key

IN LOOKUP

NONE

Relationship

UP ORDERING OF

33 - Position

AT ALL TIMES

2

Relationship

UP ORDERING OF

44 - ? Reference Column

IN LOOKUP

NONE

Relationship

UP ORDERING OF

51 - ? Column

IN LOOKUP

NONE

Requires

UP ORDERING OF

6 - ? Entity

IN LOOKUP

NONE

Requires

UP ORDERING OF

7 - [entity.pgcat_name]

AT ALL TIMES

1

51.2.4. Locks

The following are the locks used on this desktop.

Desktop Panel Field Source Value Reference Panel Reference Field Slice Properties

Key

13 - [akmap.model_id]

SET FROM REFERENCE

1 - [key.model_id]

AT ALL TIMES

Key

14 - [akmap.entity_id]

SET FROM REFERENCE

2 - [key.entity_id]

AT ALL TIMES

Event

23 - [eamap.model_id]

SET FROM REFERENCE

1 - [event.model_id]

AT ALL TIMES

Event

24 - [eamap.entity_id]

SET FROM REFERENCE

2 - [event.entity_id]

AT ALL TIMES

Relationship

1 - [relationship.model_id]

SET FROM REFERENCE

1 - Model-ID

AT ALL TIMES

Relationship

34 - [rakmap.model_id]

SET FROM REFERENCE

1 - [relationship.model_id]

AT ALL TIMES

Relationship

35 - [rakmap.relationship_entity_id]

SET FROM REFERENCE

2 - [relationship.p_entity_id]

AT ALL TIMES

Relationship

37 - [rakmap.relationship_key_id]

SET FROM REFERENCE

3 - [relationship.p_key_id]

AT ALL TIMES

Relationship

46 - [rakmap.relationship_f_entity_id]

SET FROM REFERENCE

4 - [relationship.f_entity_id]

AT ALL TIMES

Requires

2 - [eemap.model_id]

SET FROM REFERENCE

1 - [entity.model_id]

AT ALL TIMES

51.3. Permission

UUID

des-81f29c83-e48c-4d80-9569-043a13860d53

Desktop Name

Permission

Explicit Cluster Membership

NONE

Description

The Permission Desktop is for the configuration of those parts of the model that will result in access control structure in a PostgreSQL installation and physical database.

51.3.1. Panels

The following are the panels on this desktop in presentational order.

Name Parent Related By Description

Choose Model

NONE

NONE

The "Choose Model" Panel is for selection of the parent model against which all other panels on the owning desktop operate.

Role

Choose Model

role_model_id

The Role panel allows new roles to be added and existing roles modified (or deleted) for the currently selected model.

51.3.2. Templates

There are no templates used on this desktop.

51.3.3. Sequences

The following are the sequences used on this desktop.

Desktop Panel Type Field Slice Tier

Role

UP ORDERING OF

4 - Name[Realised]

AT ALL TIMES

1

Role

UP ORDERING OF

15 - ? Entity

IN LOOKUP

NONE

Role

UP ORDERING OF

21 - [entity.pgcat_name]

AT ALL TIMES

2

Role

UP ORDERING OF

31 - ? Capability

IN LOOKUP

NONE

Role

UP ORDERING OF

36 - ? Attribute

IN LOOKUP

NONE

Choose Model

UP ORDERING OF

3 - Model-Label

AT ALL TIMES

1

Choose Model

UP ORDERING OF

7 - Name[Realised]

AT ALL TIMES

2

51.3.4. Locks

The following are the locks used on this desktop.

Desktop Panel Field Source Value Reference Panel Reference Field Slice Properties

Role

11 - [capability.model_id]

SET FROM REFERENCE

1 - [role.model_id]

AT ALL TIMES

Role

23 - [camap.model_id]

SET FROM REFERENCE

1 - [role.model_id]

AT ALL TIMES

Role

24 - [camap.role_id]

SET FROM REFERENCE

2 - Role-ID

AT ALL TIMES

51.4. Reflection

UUID

des-e09d1a12-a782-4694-a8a5-d89b09a9ff42

Desktop Name

Reflection

Explicit Cluster Membership

NONE

Description

The Reflection Desktop is for the management of TheonUI desktop and panel configuration.

51.4.1. Panels

The following are the panels on this desktop in presentational order.

Name Parent Related By Description

Choose Model

NONE

NONE

The "Choose Model" Panel is for selection of the parent model against which all other panels on the owning desktop operate.

Desktop

Choose Model

desktop_model_id

The Desktop Panel is for new desktops to be added and existing desktops modified (or deleted) for the currently selected model.

Panel

Choose Model

panel_model_id

The Panel Panel is for new panels to be added and existing panels modified (or deleted) for the currently selected model.

Constraint

Panel

TIE

The Constraint Panel is for new panel live data to to be added and existing live data modified (or deleted) for the currently selected panel. Live data defines panel locks, sequences and templates which are then applied to each owning desktop.

51.4.2. Templates

There are no templates used on this desktop.

51.4.3. Sequences

The following are the sequences used on this desktop.

Desktop Panel Type Field Slice Tier

Constraint

UP ORDERING OF

10 - ? Field

IN LOOKUP

NONE

Constraint

UP ORDERING OF

14 - ? Desktop

IN LOOKUP

NONE

Constraint

UP ORDERING OF

29 - ? Field

IN LOOKUP

NONE

Constraint

UP ORDERING OF

33 - ? Desktop

IN LOOKUP

NONE

Constraint

UP ORDERING OF

44 - ? Field

IN LOOKUP

NONE

Constraint

UP ORDERING OF

53 - ? CrossRef Field

IN LOOKUP

NONE

Constraint

UP ORDERING OF

57 - ? Desktop

IN LOOKUP

NONE

Constraint

UP ORDERING OF

62 - ? LinkPanel

IN LOOKUP

NONE

Constraint

UP ORDERING OF

69 - ? LinkPanelField

IN LOOKUP

NONE

Panel

UP ORDERING OF

4 - Panel-Label

AT ALL TIMES

1

Panel

UP ORDERING OF

11 - ? Base Entity

IN LOOKUP

NONE

Panel

UP ORDERING OF

18 - Position

AT ALL TIMES

2

Panel

UP ORDERING OF

29 - ? Joining Relationship

IN LOOKUP

NONE

Panel

UP ORDERING OF

42 - ? Parent Connector

IN LOOKUP

NONE

Panel

UP ORDERING OF

51 - Position

AT ALL TIMES

3

Panel

UP ORDERING OF

60 - ? Connector

IN LOOKUP

NONE

Panel

UP ORDERING OF

65 - ? Attribute

IN LOOKUP

NONE

Panel

UP ORDERING OF

70 - ? Presenter

IN LOOKUP

NONE

Panel

UP ORDERING OF

84 - ? Desktop

IN LOOKUP

NONE

Panel

UP ORDERING OF

91 - ? X-Link

IN LOOKUP

NONE

Panel

UP ORDERING OF

96 - ? X-Link Field

IN LOOKUP

NONE

Desktop

UP ORDERING OF

4 - Desktop-Label

AT ALL TIMES

1

Desktop

UP ORDERING OF

9 - Position

AT ALL TIMES

2

Desktop

UP ORDERING OF

14 - ? Panel

AT ALL TIMES

3

Desktop

UP ORDERING OF

22 - ? Parent Link

AT ALL TIMES

4

Desktop

UP ORDERING OF

32 - ? Relationship

AT ALL TIMES

5

51.4.4. Locks

The following are the locks used on this desktop.

Desktop Panel Field Source Value Reference Panel Reference Field Slice Properties

Constraint

4 - [template.model_id]

SET FROM REFERENCE

1 - [panel.model_id]

AT ALL TIMES

Constraint

5 - [template.panel_id]

SET FROM REFERENCE

2 - [panel.id]

AT ALL TIMES

Constraint

23 - [sequence.model_id]

SET FROM REFERENCE

1 - [panel.model_id]

AT ALL TIMES

Constraint

24 - [sequence.panel_id]

SET FROM REFERENCE

2 - [panel.id]

AT ALL TIMES

Constraint

38 - [lock.model_id]

SET FROM REFERENCE

1 - [panel.model_id]

AT ALL TIMES

Constraint

39 - [lock.panel_id]

SET FROM REFERENCE

2 - [panel.id]

AT ALL TIMES

Panel

19 - [connector.model_id]

SET FROM REFERENCE

1 - [panel.model_id]

AT ALL TIMES

Panel

37 - [connector.connector_panel_id]

SET FROM REFERENCE

2 - Panel-ID

AT ALL TIMES

WITH_STICKY

Panel

52 - [field.model_id]

SET FROM REFERENCE

1 - [panel.model_id]

AT ALL TIMES

Panel

53 - [field.panel_id]

SET FROM REFERENCE

2 - Panel-ID

AT ALL TIMES

Panel

55 - [field.attribute_entity_id]

SET FROM REFERENCE

8 - [panel.entity_id]

AT ALL TIMES

WITH_STICKY

Desktop

10 - [link.model_id]

SET FROM REFERENCE

1 - [model.id]

AT ALL TIMES

Desktop

15 - [link.desktop_id]

SET FROM REFERENCE

2 - Desktop-ID

AT ALL TIMES

51.5. Streaming

UUID

des-740f8ec5-73ec-463e-b0bc-0004de234d10

Desktop Name

Streaming

Explicit Cluster Membership

NONE

Description

NONE

51.5.1. Panels

The following are the panels on this desktop in presentational order.

Name Parent Related By Description

Choose Model

NONE

NONE

The "Choose Model" Panel is for selection of the parent model against which all other panels on the owning desktop operate.

Stream

Choose Model

stream_model_id

The Stream panel allows new streams to be added and existing streams modified (or deleted) for the currently selected model.

Couple

Stream

couple_stream_id

The Couple panel allows new couples to be added and existing couples modified (or deleted) for the currently selected stream.

Bond

Couple

bond_couple_id

The Bond panel allows new bonds to be added and existing bonds modified (or deleted) for the currently selected couple.

51.5.2. Templates

The following are the templates used on this desktop.

Desktop Panel Type Field Rule Value Slice Properties

Couple

COMPARISON OF

16 - [entity.type]

IS EQ TO

Table

AT ALL TIMES

Stream

COMPARISON OF

32 - [entity.type]

IS EQ TO

Table

AT ALL TIMES

51.5.3. Sequences

The following are the sequences used on this desktop.

Desktop Panel Type Field Slice Tier

Couple

UP ORDERING OF

3 - Name[Realised]

AT ALL TIMES

1

Couple

UP ORDERING OF

11 - ? Source Entity

IN LOOKUP

NONE

Couple

UP ORDERING OF

15 - ? Target Entity

IN LOOKUP

NONE

Couple

UP ORDERING OF

33 - Position

AT ALL TIMES

2

Couple

UP ORDERING OF

34 - Type

AT ALL TIMES

3

Couple

UP ORDERING OF

46 - ? Via Relationship

IN LOOKUP

NONE

Choose Model

UP ORDERING OF

3 - Model-Label

AT ALL TIMES

1

Choose Model

UP ORDERING OF

7 - Stream-Label

AT ALL TIMES

2

Choose Model

UP ORDERING OF

13 - ? Feed Entity

IN LOOKUP

NONE

Stream

UP ORDERING OF

3 - Stream-Label

AT ALL TIMES

1

Stream

UP ORDERING OF

11 - ? Feed Entity

IN LOOKUP

NONE

Stream

UP ORDERING OF

21 - Position

AT ALL TIMES

2

Stream

UP ORDERING OF

27 - ? Source Entity

IN LOOKUP

NONE

Stream

UP ORDERING OF

31 - ? Target Entity

IN LOOKUP

NONE

Bond

UP ORDERING OF

3 - Position

AT ALL TIMES

1

Bond

UP ORDERING OF

17 - ? Via Relationship

IN LOOKUP

NONE

Bond

UP ORDERING OF

20 - Position

AT ALL TIMES

2

Bond

UP ORDERING OF

28 - ? Source Column

IN LOOKUP

NONE

Bond

UP ORDERING OF

35 - ? Target Column

IN LOOKUP

NONE

Bond

UP ORDERING OF

41 - ? Lookup Column

IN LOOKUP

NONE

51.5.4. Locks

The following are the locks used on this desktop.

Desktop Panel Field Source Value Reference Panel Reference Field Slice Properties

Couple

7 - [couple.model_id]

SET FROM REFERENCE

7 - [stream.model_id]

AT ALL TIMES

Couple

36 - [bond.model_id]

SET FROM REFERENCE

7 - [couple.model_id]

AT ALL TIMES

Couple

39 - [bond.t_entity_id]

SET FROM REFERENCE

12 - [couple.t_entity_id]

AT ALL TIMES

Choose Model

9 - [stream.model_id]

SET FROM REFERENCE

1 - Model-Name

AT ALL TIMES

Stream

7 - [stream.model_id]

SET FROM REFERENCE

1 - Model-Name

AT ALL TIMES

Stream

23 - [couple.model_id]

SET FROM REFERENCE

7 - [stream.model_id]

AT ALL TIMES

Bond

7 - [bond.model_id]

SET FROM REFERENCE

7 - [couple.model_id]

AT ALL TIMES

Bond

10 - [bond.t_entity_id]

SET FROM REFERENCE

12 - [couple.t_entity_id]

AT ALL TIMES

Bond

22 - [pair.model_id]

SET FROM REFERENCE

7 - [bond.model_id]

AT ALL TIMES

Bond

23 - [pair.s_entity_id]

SET FROM REFERENCE

6 - [bond.s_entity_id]

AT ALL TIMES

Bond

30 - [pair.t_entity_id]

SET FROM REFERENCE

10 - [bond.t_entity_id]

AT ALL TIMES

Bond

36 - [pair.v_entity_id]

SET FROM REFERENCE

8 - [bond.entity_id]

AT ALL TIMES

WITH_STICKY