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

s_link Table (336)

Some tooltip text!
• 7 minutes to read
 • 7 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(255)
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 ●
redirect_is_url 1 if url is used, 0 if custom text is used. Bool
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 ●

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.
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
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