Click or drag to resize
Database Table Datadictionary Relation

[This is preliminary documentation and is subject to change.]

The DatadictionaryRelation table holds data about relations between tables in dynamic forms in TOPICA

Each row represent a parent child relationship between dynamic forms tables

Fields

Field name

Type

Note

Description

ParentTableName

varchar(50)

Primary key, foreign key to DatadictionaryTable

Name of the parent table in the relationship for the dynamic form.

ChildTableName

varchar(50)

Primary key, foreign key to DatadictionaryTable

Name of the child table in the relationship for the dynamic form.

Hidden

bit

Whether or not to hide ?

Cardinality

int

Foreign key to Cardinality

Enumvalue representing the cardinality of the relationship between the parent and child table:

  • 0 - Unknown

  • 1 - 1-1 Only one instance of child table per parent table instance allowed

  • 2 - 1-N More instances of child table per parent table instance allowed

  • 3 - N-1 One instance of child table can be shared between more parent table instances

  • 4 - N-M More instances of child table can be shared between more parent table instances

SequenceNumber

int

DisplayAtTop

bit

Whether or not to create an overview folder in the record tree for a collection of the table in scope.