SuggestedAppointment table

SuggestedAppointment Table (125)

Defines a suggested appointment for use in a Sale Guide or Project Guide

Name	Description	Type	Nullable
SuggestedAppointment_id	Primary key	PK	No
name	Item name, visible in Guide	String(239)	No
rank	Rank, controls rank of non-instantiated items in Guide	UShort	Yes
tooltip	Tooltip / description	String(254)	Yes
deleted	0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists	UShort	Yes
saleTypeStageLinkId	Link to saleTypeStageLink, the anchor for sale guide items. Either this OR projectAnchorId should be set, not both at the same time.	FK SaleTypeStageLink	Yes
projectTypeStatusLinkId	Link to projectTypeStatusLink, the anchor for project guide items. Either this OR saleAnchorId should be set, not both at the same time.	FK ProjectTypeStatusLink	Yes
task_id	Type of the suggested appointment	FK Task	Yes
daysFuture	How many days into the future the appointment should be scheduled	UShort	Yes
duration	Duration in minutes of suggested appointment	UShort	Yes
autoSuggest	Should this appointment be auto-suggested	Bool	Yes
text	The suggested text of the new appointment	String(2047)	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
isMilestone	Is this kind of appointment a milestone in a project	Bool	Yes
assignToMember	Should generated appointment be assigned to a project member?	Bool	Yes

Table	Description
appointment	Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.
associate	Employees, resources and other users - except for External persons
ProjectTypeStatusLink	Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items
SaleTypeStageLink	Many-many link table between sale type and stage; and an anchor point for guide items
Task	Task list table, activity types, like Phone, Meeting