tbl_holidayallocationdetails

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_holidayallocationdetails_id_seq'::regclass)
tbl_holidayallocationdetailshistory.holidayallocationdetailsid fk_tbl_holidayallocationdetailshistory_holidayallocationdetails R
tbl_holidayemployeemapping.holidayallocationid fk_tbl_holidayemployeemapping_holidayallocationid R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single holiday allocation detail record.
holidayid int8 19 null
tbl_holidaydetails.id fk_tbl_holidayallocationdetails_holidayid R

FK: public.tbl_holiday.id (Presumed Foreign Key)
Meaning: Links the detail record to the main holiday configuration/definition.
Dependency: Allows for querying of all details for a specific holiday.
criteriavalue text 2147483647 √ null

Meaning: The specific value for the allocation criteria.
Example: A specific employee ID, department name, or location code.
Logic: Used with the related criteria to determine which group or individual receives the holiday allocation.
status varchar 50 null

The current state of the allocation record.
Format: Varies (e.g., String, SmallInt)
Meaning: Indicates if the allocation is Active, Inactive, Pending Review, etc.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id (Presumed Foreign Key)
Meaning: The user who created this allocation detail record.
createddate timestamp 29,6 √ null

Timestamp of when the allocation detail was created.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id (Presumed Foreign Key)
Meaning: The last user who modified this allocation detail record.
modifieddate timestamp 29,6 √ null

Timestamp of when the allocation detail was last modified.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ

Indexes

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

Relationships

Close relationships within degrees of separation