This entity holds a record of all the holidays that a company might have. These holidays would include public holidays, and also any company related holiday.
Public holidays are linked to a country through the Holiday Country ID. New holidays can be added and existing ones deleted. On the calendar, public holidays are marked with the letter "P". Public holidays will affect leave applcation dates and wage calculation.

Shows the identity of the holiday. It uniquely identifies each public holiday the country celebrates. This is the primary key for the Holidays table.
Example: Vesak Day / National Day / Hari Raya Haji etc

Stores the start date of the public holiday. This is also the primary key for the Holidays table.
It is usually in the format: DD-MM-YYYY.

Stores the end date of the public holiday.
It is usually in the format: DD-MM-YYYY.

Stores any description about the holiday.

Shows the holiday leave pattern.

Shows the holiday work pattern.

Shows the holiday pay pattern.