> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # SuggestedAppointment table > Defines a suggested appointment for use in a Sale Guide or Project Guide ## SuggestedAppointment Table (125) Defines a suggested appointment for use in a Sale Guide or Project Guide ## Fields | 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](./saletypestagelink.mdx) | 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](./projecttypestatuslink.mdx) | Yes | | task\_id | Type of the suggested appointment | FK [Task](./task.mdx) | 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](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | 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 | SuggestedAppointment table relationship diagram ## Indexes | Fields | Types | Description | | ----------------------- | ----------- | ----------- | | name | String(239) | Index | | saleTypeStageLinkId | FK | Index | | projectTypeStatusLinkId | FK | Index | ## Relationships | Table | Description | | ------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [appointment](./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](./associate) | Employees, resources and other users - except for External persons | | [ProjectTypeStatusLink](./projecttypestatuslink) | Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items | | [SaleTypeStageLink](./saletypestagelink) | Many-many link table between sale type and stage; and an anchor point for guide items | | [Task](./task) | Task list table, activity types, like Phone, Meeting | ## 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 - [SuperOffice.WebApi.Data.SuggestedAppointment](/en/api/reference/webapi/SuperOffice.WebApi.Data.SuggestedAppointment.md) - [Guides](/en/automation/crmscript/howto/sale/guides.md) - [Project guides](/en/automation/crmscript/howto/project/guides.md) - [suggestedappointment](/en/api/mdo-providers/reference/suggestedappointment.md) - [Get Suggested Appointment](/en/api/reference/restful/agent/appointment_agent/get-suggested-appointment.md) - [SuperOffice.WebApi.Data.SuggestedAppointmentEntity](/en/api/reference/webapi/SuperOffice.WebApi.Data.SuggestedAppointmentEntity.md)