> ## 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. # s_link table > Links in messages to measure success rate of a campaign. ## s\_link Table (336) Links in messages to measure success rate of a campaign. ## Fields | Name | Description | Type | Nullable | | ----------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------- | :------: | | id | Primary key | PK | No | | url | The real URL of this link ([www.vg.no](http://www.vg.no) etc) | String(4000) | No | | hits | Number of clicks on this link | Int | Yes | | description | A short description of this link | String(255) | Yes | | last\_reset | The time of last reset. | DateTime | Yes | | status | Deleted or not. Deleted links should still work. | status | Yes | | extra\_field | The name of the extra field to set if the customer clicks a link. empty if no extra field | String(255) | Yes | | value | The value of the extra field to set if the customer clicks a link. | String(255) | Yes | | folder\_id | The folder which this link belongs to. -1 indicates that the link is on the root | Int | No | | script\_id | The ejScript which will be run when the link is clicked. -1 means no script is run | FK [ejscript](./ejscript.mdx) | No | | ticket\_title | The title on the ticket if the clicks results in creating a request. | String(255) | Yes | | ticket\_category | The id of the category a ticket is in. | FK [ej\_category](./ej-category.mdx) | No | | ticket\_priority | The reference to the ticket\_priority table. | FK [ticket\_priority](./ticket-priority.mdx) | No | | ticket\_owned\_by | The id of the user who owns the ticket. 1 (system user) if the ticket is unassigned. | FK [ejuser](./ejuser.mdx) | No | | remove\_from\_selection | The id of the selection that the customer shall be removed from | FK [ejselection](./ejselection.mdx) | No | | add\_to\_selection | The id of the selection that the customer shall be added to | FK [ejselection](./ejselection.mdx) | No | | template\_text | Text to print when link is clicked. | Clob | Yes | | action\_flags | Bitmask defining what action should be taken | Enum [ShipmentLinkAction](./enums/shipmentlinkaction.mdx) | Yes | | add\_contact\_interest | Contact interest to add to recipient person | FK [ContInt](./contint.mdx) | Yes | | remove\_contact\_interest | Person interest to remove from recipient person | FK [ContInt](./contint.mdx) | Yes | | add\_person\_interest | Person interest to add to recipient person | FK [PersInt](./persint.mdx) | Yes | | remove\_person\_interest | Person interest to remove from recipient person | FK [PersInt](./persint.mdx) | Yes | | add\_contact\_selection | Static contact selection to add person to | FK [selection](./selection.mdx) | Yes | | remove\_contact\_selection | Static contact selection to remove person from | FK [selection](./selection.mdx) | Yes | | add\_project | Project to add person to, as member | FK [project](./project.mdx) | Yes | | remove\_project | Project to remove person from, as member | FK [project](./project.mdx) | Yes | | task\_text | Text of task to be created | String(2047) | Yes | | task\_idx | Task type of new task | FK [Task](./task.mdx) | Yes | | task\_flags | Flags that control how the task is created | Enum [ShipmentLinkTaskFlags](./enums/shipmentlinktaskflags.mdx) | Yes | | task\_associate\_id | Associate whose diary should receive the task or assignment (unless AssignToOurContact is specified) | FK [associate](./associate.mdx) | Yes | | task\_creating\_associate\_id | Associate who should stand as creator of task; also works as fallback if an assigned task is rejected. Usually the associate who ordered the shipment | FK [associate](./associate.mdx) | Yes | | task\_project | Project to connect task to, can be 0 | FK [project](./project.mdx) | Yes | | task\_start | Start time of task, unless UseNextAvailableTime is specified | DateTime | Yes | | task\_duration | Task duration in minutes | Int | Yes | | registered | Registered when | UtcDateTime | Yes | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | Yes | | updated | Last updated when | UtcDateTime | Yes | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | Yes | | updatedCount | Number of updates made to this record | UShort | Yes | | local\_link | If this references a shipment message, then this is a local link belonging to that message | FK [s\_message](./s-message.mdx) | Yes | | redirect\_kind | Enum defining the redirect kind (show text, url, etc) of the link | Enum [ShipmentLinkRedirectKind](./enums/shipmentlinkredirectkind.mdx) | Yes | | link\_parameters | Contains parameters that will be added to the link when it is used | Clob | Yes | | form\_id | Relation to the form this link redirects to | FK [form](./form.mdx) | Yes | | form\_parameters | Contains url parameters that will be added when link is inserted in message | String(4000) | Yes | s_link table relationship diagram ## Indexes | Fields | Types | Description | | ----------------------------- | ----- | ----------- | | script\_id | FK | Index | | ticket\_category | FK | Index | | ticket\_priority | FK | Index | | ticket\_owned\_by | FK | Index | | remove\_from\_selection | FK | Index | | add\_to\_selection | FK | Index | | add\_contact\_interest | FK | Index | | remove\_contact\_interest | FK | Index | | add\_person\_interest | FK | Index | | remove\_person\_interest | FK | Index | | add\_contact\_selection | FK | Index | | remove\_contact\_selection | FK | Index | | add\_project | FK | Index | | remove\_project | FK | Index | | task\_idx | FK | Index | | task\_associate\_id | FK | Index | | task\_creating\_associate\_id | FK | Index | | task\_project | FK | Index | ## Relationships | Table | Description | | --------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------- | | [associate](./associate) | Employees, resources and other users - except for External persons | | [ContInt](./contint) | ContInt list table. List-text of all valid contact interest types. | | [ej\_category](./ej-category) | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. | | [ejscript](./ejscript) | ejscript | | [ejselection](./ejselection) | This table stores selections, dynamic groups. | | [ejuser](./ejuser) | This table contains entries for the users of the system. | | [email\_flow\_content\_link](./email-flow-content-link) | Links content to an email workflow | | [form](./form) | A form which can be published on a webpage and submitted by visitors | | [PersInt](./persint) | PersInt list table. List of Person interests. | | [project](./project) | Projects | | [s\_link\_customer](./s-link-customer) | A connection between a customer and a link. Registered customers are identified when clicking on a link | | [s\_link\_customer\_statical](./s-link-customer-statical) | A connection between a customer and a link. Registered customers are identified when clicking on a link | | [s\_message](./s-message) | A message used in a shipment. Can be html and/or plain text | | [selection](./selection) | Selections | | [Task](./task) | Task list table, activity types, like Phone, Meeting | | [ticket\_priority](./ticket-priority) | This table contains the ticket priorities. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [SuperOffice.WebApi.Data.WorkflowStepOptionLinkClicked](/en/api/reference/webapi/SuperOffice.WebApi.Data.WorkflowStepOptionLinkClicked.md) - [s_link_customer table](/en/database/tables/s-link-customer.md) - [s_link_customer_statical table](/en/database/tables/s-link-customer-statical.md) - [email_flow_content_link table](/en/database/tables/email-flow-content-link.md) - [ejselection table](/en/database/tables/ejselection.md) - [form table](/en/database/tables/form.md)