tbl_template_assign_mapping

-1 rows


Description

Module: Task Management
Purpose: Maps template assignments to specific employees.
Data: One row is created for each mapping between a template assignment and an employee.
Process Usage:
- tbl_template_assign stores search criteria and template IDs.
- This table links those templates and assignments to employee IDs.
- Facilitates tracking and connection between templates and employees for task management.
Key Points:
- Each mapping links a single template assignment to one employee.
- Supports reporting and search functionality for task assignments.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each template-employee mapping record.
templateid int8 19 √ null

Template ID
Format: BIGINT
FK: public.tbl_project_template.id
Meaning: References the template used in the assignment.
Usage: Links mapping to the relevant project template.
assignid int8 19 √ null
tbl_formassign.assignid Implied Constraint R

Assignment ID
Format: BIGINT
FK: public.tbl_template_assign.id
Meaning: References the assignment that contains search criteria and template information.
Usage: Connects the mapping to a specific template assignment.
employeeid varchar 100 null

Employee ID
Format: VARCHAR(100)
Meaning: Identifier of the employee associated with this template assignment.
Usage: Enables mapping templates and assignments to specific employees for tracking.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null

Indexes

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

Relationships

Close relationships within degrees of separation