tbl_holidayemployeemapping

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single direct holiday-to-employee mapping.
holidayid int8 19 null
tbl_holidaydetails.id fk_tbl_holidayemployeemapping_holidayid R

FK: public.tbl_holidaydetails.id (Presumed Foreign Key)
Meaning: The specific holiday being allocated to the employee.
Dependency: Links the mapping to the official holiday definition.
holidayallocationid int8 19 null
tbl_holidayallocationdetails.id fk_tbl_holidayemployeemapping_holidayallocationid R

FK: public.tbl_holidayallocationdetails.id (Presumed Foreign Key)
Meaning: The parent allocation rule that led to this employee mapping.
Logic: Useful for tracing why a holiday was assigned to a specific employee.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_holidayemployeemapping_employeeid R

FK: public.tbl_employee.id or public.tbl_employee.employeeid (Presumed Foreign Key)
Meaning: The employee to whom the holiday is being explicitly mapped.
Logic: This table primarily handles individual exceptions or explicit assignments.
createdby varchar 50 null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who created this employee-holiday mapping record.
createddate timestamp 29,6 null

Timestamp of when the employee mapping was created.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this employee-holiday mapping record.
modifieddate timestamp 29,6 null

Timestamp of when the employee mapping was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ

Indexes

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

Relationships

Close relationships within degrees of separation