tbl_schedulemaster

-1 rows


Description

Module: Timesheet
Purpose: Stores project/task details for employees.
Data: One row per project or task assigned to employee(s).
Process Usage:
- Tracks projects or tasks, including descriptions, priorities, stages, and estimated hours.
- Can assign specific employees or entire departments.
- Supports watchers to monitor task progress.
Key Points:
- Stores both recurring and non-recurring projects.
- Includes S3 attachment references.
- Allows tracking of task stage and priority.
Business Impact: Enables detailed project planning, timesheet tracking, and resource management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
taskid bigserial 19 √ nextval('tbl_schedulemaster_taskid_seq'::regclass)
tbl_dailyreport.taskid Implied Constraint R
tbl_task_hours.taskid Implied Constraint R

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each project/task record.
employeeid varchar 2000 √ null

Assigned Employees
Format: VARCHAR(2000)
Meaning: Employee IDs assigned to the task, stored as a comma-separated string.
Usage: Specifies which employees are responsible for the task.
description varchar 500 √ null

Project/Task Description
Format: VARCHAR(500)
Meaning: Brief description of the task or project.
Usage: Provides context for the task.
startdate timestamp 29,6 √ null

Start Date
Format: TIMESTAMP
Meaning: Planned start date of the task/project.
enddate timestamp 29,6 √ null

End Date
Format: TIMESTAMP
Meaning: Planned end date of the task/project.
hours int8 19 √ null

Estimated/Planned Hours
Format: BIGINT
Usage: Not used in current logic.
targeteddate timestamp 29,6 √ null

Targeted Date
Format: TIMESTAMP
Usage: Not used in current logic.
createddate timestamp 29,6 √ null

Record Creation Date
Format: TIMESTAMP
Usage: Not used in current logic.
remarks varchar 300 √ null

Remarks
Format: VARCHAR(300)
Usage: Not used in current logic.
taskname varchar 60 √ null

Project/Task Name
Format: VARCHAR(60)
Meaning: Name of the project/task.
Usage: Displayed in UI and reports.
status varchar 50 √ '''Pending'''::character varying

Status
Format: VARCHAR(50)
Default: ‘Pending’
Usage: Not used in current logic.
companyid int8 19 √ null

Company ID
Format: INT8
Usage: Not used in current logic.
estimatedhours numeric 0 √ null

Estimated Hours
Format: NUMERIC
Meaning: Total planned hours for the task/project.
taskpriority varchar 30 √ null

Task Priority
Format: VARCHAR(30)
Possible Values: Highest, High, Medium, Low, Lowest
Usage: Used to track importance of the task.
comm1 varchar 50 √ null

Attachment File Name
Format: VARCHAR(50)
Meaning: Name of uploaded S3 attachment related to task.
comm2 varchar 2000 √ null

Task Type IDs
Format: VARCHAR(2000)
Meaning: Comma-separated IDs of task types.
comm3 varchar 500 √ null

Reserved Column
Usage: Not used in current logic.
comm4 varchar 5000 √ null

Reserved Column
Usage: Not used in current logic.
comm5 varchar 5000 √ null

Reserved Column
Usage: Not used in current logic.
projecttype varchar 100 √ null

Project Type
Format: VARCHAR(100)
Possible Values: Non Re-Occurring, Re-Occurring
Usage: Indicates if project/task repeats.
stage varchar 100 √ null

Project Stage
Format: VARCHAR(100)
Possible Values: Created, In Process, On Hold, Closed
Usage: Tracks current stage of project/task.
department varchar 2000 √ null

Assigned Departments
Format: VARCHAR(2000)
Meaning: Comma-separated department IDs assigned to task.
watchers varchar 2000 √ null

Watchers
Format: VARCHAR(2000)
Meaning: Employee IDs who are monitoring the task/project, comma-separated.
createdby varchar 50 '''Admin'''::character varying
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
company_insert_allowed bool 1 √ false

Add Company Details?
Format: BOOLEAN
Default: false
Usage: Indicates if company details can be added.
billable_flag_allowed bool 1 √ null

Billable Flag Allowed?
Format: BOOLEAN
Usage: Indicates if billable details can be recorded.
is_imported bool 1 √ null

Imported Flag
Format: BOOLEAN
Meaning: Indicates whether this record was added via import from UI.

Indexes

Constraint Name Type Sort Column(s)
tbl_schedulemaster_pk_tbl_schedulemaster Primary key Asc taskid

Relationships

Close relationships within degrees of separation