| id | Primary key | PK | No |
| url | The real URL of this link (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 | 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 | No |
| ticket_priority | The reference to the ticket_priority table. | FK ticket_priority | No |
| ticket_owned_by | The id of the user who owns the ticket. 1 (system user) if the ticket is unassigned. | FK ejuser | No |
| remove_from_selection | The id of the selection that the customer shall be removed from | FK ejselection | No |
| add_to_selection | The id of the selection that the customer shall be added to | FK ejselection | No |
| template_text | Text to print when link is clicked. | Clob | Yes |
| action_flags | Bitmask defining what action should be taken | Enum ShipmentLinkAction | Yes |
| add_contact_interest | Contact interest to add to recipient person | FK ContInt | Yes |
| remove_contact_interest | Person interest to remove from recipient person | FK ContInt | Yes |
| add_person_interest | Person interest to add to recipient person | FK PersInt | Yes |
| remove_person_interest | Person interest to remove from recipient person | FK PersInt | Yes |
| add_contact_selection | Static contact selection to add person to | FK selection | Yes |
| remove_contact_selection | Static contact selection to remove person from | FK selection | Yes |
| add_project | Project to add person to, as member | FK project | Yes |
| remove_project | Project to remove person from, as member | FK project | Yes |
| task_text | Text of task to be created | String(2047) | Yes |
| task_idx | Task type of new task | FK Task | Yes |
| task_flags | Flags that control how the task is created | Enum ShipmentLinkTaskFlags | Yes |
| task_associate_id | Associate whose diary should receive the task or assignment (unless AssignToOurContact is specified) | FK associate | 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 | Yes |
| task_project | Project to connect task to, can be 0 | FK project | 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 | Yes |
| updated | Last updated when | UtcDateTime | Yes |
| updated_associate_id | Last updated by whom | FK associate | 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 | Yes |
| redirect_kind | Enum defining the redirect kind (show text, url, etc) of the link | Enum ShipmentLinkRedirectKind | 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 | Yes |
| form_parameters | Contains url parameters that will be added when link is inserted in message | String(4000) | Yes |
