tbl_holidayallocationdetailshistory

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single historical event.
holidayid int8 19 null
tbl_holidaydetails.id fk_tbl_holidayallocationdetailshistory_holidayid R

FK: public.tbl_holiday.id (Presumed Foreign Key)
Meaning: The parent holiday configuration to which this historical allocation detail event belongs.
Dependency: Allows for efficient querying of all historical events for a specific holiday.
holidayallocationdetailsid int8 19 null
tbl_holidayallocationdetails.id fk_tbl_holidayallocationdetailshistory_holidayallocationdetails R

FK: public.tbl_holidayallocationdetails.id
Meaning: The primary key of the parent allocation detail record that was changed.
Dependency: Used to track the history specific to a single holiday allocation detail item.
status varchar 50 null

The status of the allocation detail at the time of the change.
Format: Varies (e.g., String, SmallInt)
Meaning: Records the state (e.g., Active, Inactive, Approved) of the allocation detail when the history event was captured.
criteriavalue text 2147483647 √ null

The criteria value of the allocation detail at the time of the change.
Example: The specific employee ID, department name, or location code that was configured.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user (or system process) who performed the action that triggered this history record.
Usage: Identifies who made the change to the allocation detail.
createddate timestamp 29,6 √ null

Timestamp of when the historical event occurred (i.e., when the change to the parent table was made).
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

Meaning: Not typically used in history tables as createdby and createddate capture the event.
Note: If present, it often duplicates createdby or is left NULL.
modifieddate timestamp 29,6 √ null

Meaning: Not typically used in history tables as createddate captures the event timestamp.
Note: If present, it often duplicates createddate or is left NULL.

Indexes

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

Relationships

Close relationships within degrees of separation