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

ticket_log Table (267)

•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
 • 1 minute to read

This table contains log entries for the tickets.

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
ticket_id The id of the ticket this entry is connected to. FK ticket
log_code An enum indicating what kind of log-entry this is. log_code ●
log_who The username/alias of the user performing the action. String(255) ●
log_when When the action occured. DateTime ●
log_description A string describing the event (or part of such) to be logged. Clob ●
log_what_value2 A reference to various tables, depending on the log_code. Int ●

ticket_log table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
ticket_id FK Index
log_code Enum Index
log_when DateTime Index
log_what_value2 Int Index

Relationships

Table Description
ticket This table contains the tickets (requests) of the system. Its purpose should be evident.

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