tbl_project

-1 rows


Description

Module: Task Management
Purpose: Stores project information including timelines, estimated effort, and task allocation.
Data: One row per project, capturing project metadata, progress tracking, and employee assignment details.
Process Usage:
- Used to manage projects and track total hours spent on tasks.
- Supports assigning templates, defining priorities, and monitoring milestones.
- Stores watchers (employees monitoring the project) and applicable criteria.
Key Points:
- Tracks project status, priority, and extended deadlines.
- Aggregates task allocation hours for overall project reporting.
Business Impact: Enables project tracking, resource planning, and reporting on time and progress.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_project_id_seq'::regclass)

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each project record.
projectname varchar 150 null

Project Name
Format: VARCHAR(150)
Meaning: Title of the project.
Usage: Displayed in dashboards, project lists, and reports.
description varchar 500 √ null

Project Description
Format: VARCHAR(500)
Meaning: Optional detailed description of the project.
Usage: Helps team members understand project objectives.
startdate date 13 √ null

Start Date
Format: DATE
Meaning: Scheduled project start date.
Usage: Used for planning, scheduling, and reporting.
enddate date 13 √ null

End Date
Format: DATE
Meaning: Scheduled project completion date.
Usage: Tracks project deadlines and overdue milestones.
estimatedhours int8 19 √ null

Estimated Hours
Format: BIGINT
Meaning: Total expected hours to complete the project.
Usage: Helps in planning and resource allocation.
totalspenthours int8 19 √ null

Total Spent Hours
Format: BIGINT
Meaning: Total hours logged by employees on this project.
Usage: Aggregated from task hours for monitoring effort.
totaltaskallocatedhours int8 19 √ null

Total Task Allocated Hours
Format: BIGINT
Meaning: Sum of all task estimated hours linked to this project.
Usage: Provides insight into workload distribution and planning.
watchers text 2147483647 √ null

Watchers
Format: TEXT
Meaning: Employee IDs of watchers stored as comma-separated values.
Usage: Users who monitor project progress.
criteria text 2147483647 √ null

Applicable Criteria
Format: TEXT
Meaning: Criteria determining which employees this project applies to.
Usage: Supports dynamic assignment and eligibility checks.
status varchar 100 null

Project Status
Format: VARCHAR(100)
Possible Values: CREATED, IN_PROGRESS, ON_HOLD, COMPLETED, CLOSED
Usage: Tracks the current phase of the project.
priority varchar 100 √ null

Project Priority
Format: VARCHAR(100)
Possible Values: LOW, MEDIUM, HIGH
Usage: Helps prioritize projects for resource allocation and reporting.
templateids text 2147483647 √ null

Template IDs
Format: TEXT
Meaning: Comma-separated list of template IDs used in the project.
Usage: Supports standardized project creation using templates.
extendedenddate date 13 √ null

Extended End Date
Format: DATE
Meaning: If project deadline is extended, stores the new end date.
Usage: Monitors changes to project timelines.
overduemilestones int8 19 √ null
createddate timestamp 29,6 √ null
createdby varchar 500 null
modifieddate timestamp 29,6 √ null
modifiedby varchar 500 null

Indexes

Constraint Name Type Sort Column(s)
pk__tbl__tbl_project_id Primary key Asc id

Relationships

Close relationships within degrees of separation