tbl_ticket

-1 rows


Description

Module: HRMS Helpdesk & Ticketing System
Purpose: Stores the master record for every support ticket or query raised by an employee or administrator regarding HR processes, system issues, or service requests.
Data: Contains ticket metadata, status, priority, resolution details, and organizational context.
Process Usage:
- Used by the support team to manage the assignment, tracking, and resolution of all incoming employee queries.
- Provides metrics for service level agreement (SLA) compliance and common issue reporting.
Key Points:
- Essential for managing internal service delivery and ensuring timely support for employees.
- Tracks the full lifecycle of a service request from creation to resolution.
Business Impact: Improves employee experience by centralizing and standardizing the process for getting assistance.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ticketid bigserial 19 √ nextval('tbl_ticket_ticketid_seq'::regclass)
tbl_tickethistory.ticketid fk_tbl_tickethistory_ticketid R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single ticket record.
ticketcategoryid int8 19 null
tbl_ticketcategory.ticketcategoryid fk_tbl_ticket_ticketcategoryid R

FK: Reference to a ticket category master table
Meaning: The category or topic of the ticket (e.g., “Payroll Issue,” “Leave Request Problem,” “System Bug”).
subject varchar 200 null

A concise, one-line summary of the issue or request.
Format: Varchar/Text.
description varchar 1000 null

The detailed explanation of the issue, including steps to reproduce or required service details.
Format: Text.
assigneeid varchar 500 √ null
tbl_employee.employeeid fk_tbl_ticket_assigneeid R

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The ID of the support staff member currently responsible for resolving the ticket.
ticketstatusid int8 19 null
tbl_ticketstatus.ticketstatusid fk_tbl_ticket_ticketstatusid R

FK: Reference to a ticket status master table
Meaning: The current status of the ticket (e.g., New, In Progress, On Hold, Resolved, Closed).
priorityid int8 19 null
tbl_lookupmaster.lookupid fk_tbl_ticket_priorityid R

FK: Reference to a priority master table
Meaning: The urgency level of the ticket (e.g., Low, Medium, High, Critical).
ratingid int8 19 √ null
tbl_lookupmaster.lookupid fk_tbl_ticket_ratingid R

FK: Reference to a rating master table
Meaning: The rating or satisfaction score provided by the requester upon resolution.
Usage: Measures service quality.
resolveddate timestamp 29,6 √ null

The timestamp when the ticket was marked as resolved.
Format: Timestamp with timezone.
companyid int4 10 null
tbl_companymaster.companyid fk_tbl_ticket_companyid R

FK: Reference to a company master table
Meaning: The company ID of the employee who raised the ticket.
createdby varchar 50 √ null

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The ID of the user who created the ticket.
createddate timestamp 29,6 √ null

Timestamp of when the ticket record was created.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The ID of the last user (support staff or requester) who modified the ticket.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the ticket record.
Format: Timestamp with timezone.
stage varchar 100 null

The current step (closed New )
Format: Varchar/Text.

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_ticket_ticketid Primary key Asc ticketid

Relationships

Close relationships within degrees of separation