s_link Table (336)
•
Environment: onsite, online
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 | ● |
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.