• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

s_link Table (336)

Some tooltip text!
• 8 minutes to read
 • 8 minutes to read

Links in messages to measure success rate of a campaign.

Fields

Name Description Type Null
id Primary key PK
url The real URL of this link (www.vg.no etc) String(4000)
hits Number of clicks on this link Int ●
description A short description of this link String(255) ●
last_reset The time of last reset. DateTime ●
status Deleted or not. Deleted links should still work. status ●
extra_field The name of the extra field to set if the customer clicks a link. empty if no extra field String(255) ●
value The value of the extra field to set if the customer clicks a link. String(255) ●
folder_id The folder which this link belongs to. -1 indicates that the link is on the root Int
script_id The ejScript which will be run when the link is clicked. -1 means no script is run FK ejscript
ticket_title The title on the ticket if the clicks results in creating a request. String(255) ●
ticket_category The id of the category a ticket is in. FK ej_category
ticket_priority The reference to the ticket_priority table. FK ticket_priority
ticket_owned_by The id of the user who owns the ticket. 1 (system user) if the ticket is unassigned. FK ejuser
remove_from_selection The id of the selection that the customer shall be removed from FK ejselection
add_to_selection The id of the selection that the customer shall be added to FK ejselection
template_text Text to print when link is clicked. Clob ●
action_flags Bitmask defining what action should be taken Enum ShipmentLinkAction ●
add_contact_interest Contact interest to add to recipient person FK ContInt ●
remove_contact_interest Person interest to remove from recipient person FK ContInt ●
add_person_interest Person interest to add to recipient person FK PersInt ●
remove_person_interest Person interest to remove from recipient person FK PersInt ●
add_contact_selection Static contact selection to add person to FK selection ●
remove_contact_selection Static contact selection to remove person from FK selection ●
add_project Project to add person to, as member FK project ●
remove_project Project to remove person from, as member FK project ●
task_text Text of task to be created String(2047) ●
task_idx Task type of new task FK Task ●
task_flags Flags that control how the task is created Enum ShipmentLinkTaskFlags ●
task_associate_id Associate whose diary should receive the task or assignment (unless AssignToOurContact is specified) FK associate ●
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 ●
task_project Project to connect task to, can be 0 FK project ●
task_start Start time of task, unless UseNextAvailableTime is specified DateTime ●
task_duration Task duration in minutes Int ●
registered Registered when UtcDateTime ●
registered_associate_id Registered by whom FK associate ●
updated Last updated when UtcDateTime ●
updated_associate_id Last updated by whom FK associate ●
updatedCount Number of updates made to this record UShort ●
local_link If this references a shipment message, then this is a local link belonging to that message FK s_message ●
redirect_kind Enum defining the redirect kind (show text, url, etc) of the link Enum ShipmentLinkRedirectKind ●
link_parameters Contains parameters that will be added to the link when it is used Clob ●
form_id Relation to the form this link redirects to FK form ●
form_parameters Contains url parameters that will be added when link is inserted in message String(4000) ●

s_link table relationship diagram

Bitmask defininig what action should be taken. This enumeration consists of flag values that can be combined.

action_flags Comment
0 No action
1 Set an interest on the recipient-who-is-a-person
2 Remove an interest from the recipient-who-is-a-person
4 Set an interest on the recipient-who-is-a-contact
8 Remove an interest from the recipient-who-is-a-contact
16 Add person ID of recipient to a static S&M selection
32 Remove person ID of recipient from a static S&M selection
64 Add person ID of recipient as a member of an S&M project
128 Remove person ID of recipient as a member of an S&M project
254 Add a task in an S&M diary
512 Add a request (ticket) in CS
1024 Add person to a Customer Support selection
2048 Remove person from a Customer Service selection
4096 Execute an ejScript

Flags that control how the task is created. This enumeration consists of flag values that can be combined.

task_flags Comment
0 No special options, values taken from other fields
1 Assign task to contact owner
2 Use the soonest-available working time slot (after the task-creation event is triggered)
4 Create as an assignment (shown in Invitation dialog)

Indexes

Fields Types Description
id PK Clustered, Unique
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 Employees, resources and other users - except for External persons
ContInt ContInt list table. List-text of all valid contact interest types.
ej_category This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.
ejscript ejscript
ejselection This table stores selections, dynamic groups.
ejuser This table contains entries for the users of the system.
email_flow_content_link Links content to an email workflow
form A form which can be published on a webpage and submitted by visitors
PersInt PersInt list table. List of Person interests.
project Projects
s_link_customer A connection between a customer and a link. Registered customers are identified when clicking on a link
s_link_customer_statical A connection between a customer and a link. Registered customers are identified when clicking on a link
s_message A message used in a shipment. Can be html and/or plain text
selection Selections
Task Task list table, activity types, like Phone, Meeting
ticket_priority This table contains the ticket priorities.

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top