CREATE TABLE `hr_travel_setup` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`client_id` INT(11) NULL DEFAULT NULL,
	`travel_type_id` INT(11) NULL DEFAULT NULL,
	`travel_title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`daily_expense_id` INT(11) NULL DEFAULT NULL,
	`transport_arrangement_id` INT(11) NULL DEFAULT NULL,
	`transport_expense_id` INT(11) NULL DEFAULT NULL,
	`accommodation_arrangement_id` INT(11) NULL DEFAULT NULL,
	`accommodation_expense_id` INT(11) NULL DEFAULT NULL,
	`accommodation_allowance` TINYINT(4) NULL DEFAULT NULL,
	`doc_required` TINYINT(4) NULL DEFAULT NULL,
	`apply_pre_fact` TINYINT(4) NULL DEFAULT NULL,
	`min_pre_fact_apply` INT(11) NULL DEFAULT NULL,
	`max_pre_fact_apply` INT(11) NULL DEFAULT NULL,
	`apply_for_next_year` TINYINT(4) NULL DEFAULT NULL,
	`apply_post_fact` INT(11) NULL DEFAULT NULL,
	`max_post_fact_apply` INT(11) NULL DEFAULT NULL,
	`monthly_quota` INT(11) NULL DEFAULT NULL,
	`weekly_quota` INT(11) NULL DEFAULT NULL,
	`max_monthly_frequency` INT(11) NULL DEFAULT NULL,
	`max_annual_frequency` INT(11) NULL DEFAULT NULL,
	`status` INT(11) NULL DEFAULT '0',
	`created_at` DATETIME NULL DEFAULT NULL,
	`updated_at` DATETIME NULL DEFAULT NULL,
	`deleted_at` DATETIME NULL DEFAULT NULL,
	`deleted_by` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=3
;
