CREATE TABLE `tblcompany_rewards_reedemption` (
`id` VARCHAR(255) NOT NULL,
`tenant_id` BIGINT UNSIGNED NOT NULL,
`reward_reedemption_value` INT NOT NULL,
`coupon_code` VARCHAR(255) NOT NULL,
`coupon_service_provider` VARCHAR(255) NOT NULL,
`activity_done_by_staff_id` BIGINT UNSIGNED NOT NULL,
`activity_done_on` DATETIME NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB;


CREATE TABLE `tblcompany_rewards` (
`id` VARCHAR(255) NOT NULL,
`tenant_id` BIGINT UNSIGNED NOT NULL,
`reward_value` INT NOT NULL,
`reward_for_activity` TEXT NOT NULL,
`activity_done_by_staff_id` BIGINT UNSIGNED NOT NULL,
`reward_for_type` VARCHAR(255) NULL,
`reward_for_type_id` BIGINT UNSIGNED NULL,
`activity_done_on` DATETIME NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB;


CREATE TABLE `tblstaff_rewards_reedemption` (
`id` VARCHAR(255) NOT NULL,
`tenant_id` BIGINT UNSIGNED NOT NULL,
`reward_reedemption_value` INT NOT NULL,
`coupon_code` VARCHAR(255) NOT NULL,
`coupon_service_provider` VARCHAR(255) NOT NULL,
`activity_done_by_staff_id` BIGINT UNSIGNED NOT NULL,
`activity_done_on` DATETIME NOT NULL,
PRIMARY KEY (`id`)) ENGINE = InnoDB;


CREATE TABLE `tblstaff_rewards` (
`id` VARCHAR(255) NOT NULL,
`tenant_id` BIGINT UNSIGNED NOT NULL,
`reward_value` INT NOT NULL,
`reward_for_activity` TEXT NOT NULL,
`activity_done_by_staff_id` BIGINT UNSIGNED NOT NULL,
`reward_for_type` VARCHAR(255) NULL,
`reward_for_type_id` BIGINT UNSIGNED NULL,
`activity_done_on` DATETIME NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB;
