tbl_holidaydetails

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_holidaydetails_id_seq'::regclass)
tbl_holidayallocationdetails.holidayid fk_tbl_holidayallocationdetails_holidayid R
tbl_holidayallocationdetailshistory.holidayid fk_tbl_holidayallocationdetailshistory_holidayid R
tbl_holidaydetailshistory.holidaydetailsid fk_tbl_holidaydetailshistory_holidayid R
tbl_holidayemployeemapping.holidayid fk_tbl_holidayemployeemapping_holidayid R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single holiday definition.
holidayname varchar 255 null

The common or formal name of the holiday.
Format: Varchar/Text
Example: Christmas, New Year’s Day, State Election Day.
holidaytype varchar 255 null

The type of holiday for categorization.
Format: Varchar/Text or FK to a lookup table
Example: Public Holiday, Festival, National Day, Restricted Holiday.
holidaydate date 13 null

The official date on which the holiday occurs.
Format: Date
Logic: This may be a fixed date (e.g., Dec 25) or a calculated date (e.g., last Monday of May).
isoptionalholiday bool 1 null

Flag indicating if the holiday is optional (Restricted Holiday) for an employee.
Format: Boolean (True/False)
Logic: If true, employees may be able to choose a limited number of these.
ispayableholiday bool 1 null

Flag indicating if the holiday is a paid day off for the employee.
Format: Boolean (True/False)
Logic: Affects payroll calculations for the holiday period.
iscontinuousholiday bool 1 null

Flag indicating if the holiday is part of a continuous block of days (e.g., a long festival or weekend extension).
Format: Boolean (True/False)
Logic: Used by scheduling and time-off systems to manage consecutive days.
status varchar 50 null

The current status of the holiday definition.
Format: Varchar/Text or SmallInt
Meaning: Indicates if the holiday is Active for the current year, Draft, or Archived.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who initially defined and created this holiday record.
createddate timestamp 29,6 √ null

Timestamp of when the holiday definition 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 holiday definition record.
modifieddate timestamp 29,6 √ null

Timestamp of when the holiday definition 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_holidaydetails_id Primary key Asc id

Relationships

Close relationships within degrees of separation