relationtarget table

relationtarget Table (51)

Definition of targets for a relation. Links a relation definition (RelDef) to source and target tables. In general, a relation can be created between any pair of tables. This table is used for specifying which table pairs a particular relation can be used for. A relation definition should have at least one row in this table, and can have more. Note; The 5.0 Maintenance and GUI only support contact and person as valid values for the source_table and destination_table fields, in any combination. Other relations will not be shown, and relation definitions pointing to other tables will not be editable from the Maintenance GUI; however, nothing will crash.

Fields

Name	Description	Type	Nullable
reltarget_id	Primary key	PK	No
reldef_id	Reference to definition	FK relationdefinition	No
source_table	Source table number (contact/person in 5.0)	TableNumber	No
destination_table	Target table number (contact/person in 5.0)	TableNumber	No
bidirectional	Is relation bidirectional	UShort	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
reldef_id	FK	Index
source_table	TableNumber	Index
destination_table	TableNumber	Index
bidirectional	UShort	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
relationdefinition	Definition of a relation. This table defines the relations that can exist in the database. Each relation has an active text and a passive text. The table RelationTarget specifies which pairs of tables this relation can connect. Use of the active and passive texts is dependent on which direction the relation is viewed in, e.g., active text = “Owns” and passive text = “Is owned by”.

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Overview

Getting started