TemporaryKey table - SuperOffice

TemporaryKey Table (514)

Temporary keys for lightweight authentications such as changing ones subscriptions

Fields

Name	Description	Type	Nullable
temporarykey_id	Primary key	PK	No
domain	The domain this is a key for	Enum TemporaryKeyDomain	No
target_id	The primary key in the table this is a key for	Int	Yes
person_id	The person this is a key for	FK person	Yes
authkey	The actual key	String(256)	No
expires	When this key expires (server localtime)	DateTime	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
payload	Optional field that may contain arbitrary data used when the key is verified, dependent on the domain	String(4000)	Yes

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
person	Persons

Replication Flags

None

Security Flags

No access control via user’s Role.