tbl_recurringtask

-1 rows


Description

Module: Task Management
Purpose: Stores details of recurring (automatically repeating) tasks created by employees.
Data: Each record defines one recurring task configuration for an employee.
Process Usage:
- When a user creates a daily task and enables the recurring option, the system stores configuration details here.
- Based on the configuration, new tasks are automatically generated periodically (daily, weekly, or monthly) until the recurring end date.
Key Points:
- Supports flexible recurring patterns (Daily, Weekly, Monthly).
- Enables task automation and reduces manual effort in creating repetitive tasks.
Business Impact:
- Ensures continuity of repeated activities such as daily reporting, routine checks, or status updates.
- Improves user productivity by automating task creation cycles.

Columns

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

Meaning: Primary key.
Format: BIGSERIAL (auto-increment).
Usage: Unique identifier for each recurring task configuration.
employeeid varchar 100 null

Meaning: Employee identifier.
Usage: Specifies which employee the recurring task belongs to.
Reference: Links to tbl_employee.employeeid.
taskname varchar 200 null

Meaning: Name of the recurring task.
Usage: Descriptive name entered by the employee during task creation.
status varchar 50 null

Meaning: Recurring task activation status.
Usage: Indicates whether the recurring configuration is active or inactive.
Note: No specific logical use in code — informational only.
recurringtype varchar 50 null

Meaning: Defines the type of recurrence pattern.
Possible Values:
- DAY: Task is created daily until the recurring end date.
- DAILY: Task is created weekly on selected weekdays (1–7).
- MONTH: Task is created monthly on specific dates.
Usage: Determines the frequency and recurrence logic for task generation.
recurringschedule varchar 50 null

Meaning: Schedule configuration for the recurrence.
Usage:
- For DAY, remains NULL (created daily).
- For DAILY, stores comma-separated weekday numbers (e.g., "1,2,5,6,7") to specify days of the week.
- For MONTH, stores comma-separated day numbers (e.g., "2,21") to specify dates in each month.
Purpose: Controls when recurring tasks should be auto-created based on the recurrence type.
recurringenddate date 13 √ null

Meaning: Recurrence end date.
Usage: Specifies the date until which recurring tasks will continue to be automatically created.
Format: DATE (YYYY-MM-DD).
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation