CREATE TABLE `al_work_calendar_employee_weekends` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `al_work_calendar_settings_id_forign_key`  INT(10) UNSIGNED NOT NULL ,
    `al_public_holidays_id_forign_key`  INT(10) UNSIGNED NOT NULL ,
    `proll_employee_id_forign_key`  INT(10) UNSIGNED NOT NULL ,
	`desc` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
    `start_date` DATE NULL DEFAULT NULL,
    `end_date` DATE NULL DEFAULT NULL,
    `status` TINYINT(1) NULL DEFAULT NULL,
    `created_by` INT(11) NULL DEFAULT NULL,
    `created_date` DATETIME NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    FOREIGN KEY (`al_work_calendar_settings_id_forign_key`) REFERENCES al_work_calendar_settings(`id`),
    FOREIGN KEY (`al_public_holidays_id_forign_key`) REFERENCES al_public_holidays(`id`),
    FOREIGN KEY (`proll_employee_id_forign_key`) REFERENCES proll_employee(`id`))
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
