AudienceLayoutLink table - SuperOffice

AudienceLayoutLink Table (235)

Link between an audience layout and some target grouping table - might be Role or Category

Fields

Name	Description	Type	Nullable
AudienceLayoutLink_id	Primary key	PK	No
audienceLayoutId	The name of the installed instance of Audience - must match the web.config file	FK AudienceLayout	No
targetTable	Table number of target table - entity that the layout is valid for	TableNumber	No
targetRecord	ID of record in target table that this layout is valid for	RecordId	No
comment	A possible user comment when making this link	String(254)	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
audienceLayoutId	FK	Index
targetTable, targetRecord	TableNumber, RecordId	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
AudienceLayout	One layout (of webparts and other stuff) for an audience instance

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

AudienceLayout table AudienceConfig table AudienceVisibility table Task table associate table Database table listing

⌘I