foreignkey table - SuperOffice

foreignkey Table (183)

Foreign Key - enables storage of arbitrary extra key information for every table/row in SuperOffice. You may use this table to store your extra information instead of using the dictionary SDK to create your own tables.

Fields

Name	Description	Type	Nullable
foreignkey_id	Primary key	PK	No
foreigndevice_id	Reference to device definition	FK foreigndevice	No
table_id	SuperOffice table reference	TableNumber	No
record_id	Record in the referenced table	RecordId	No
seqno	Sequence number, order of subkeys within one key	Id	No
subkey	Subkey (optional)	String(239)	Yes
subvalue	Key value	String(239)	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
foreigndevice_id	FK	Index
record_id	RecordId	Index
seqno	Id	Index
subkey	String(239)	Index
subvalue	String(239)	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
foreigndevice	Middle level of Foreign Key system

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.

Related topics

Foreign keys What's new in version 11.5.755.0 What's new in version 11.6.943.0 What's new in version 11.7.727.0 What's new in version 11.8.788.0 What's new in version 11.9.1204.0

⌘I