CREATE TABLE `tblstaff_other_details`(
    `id` BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `tenant_id` BIGINT(20) UNSIGNED NOT NULL,
    `staff_id` BIGINT(20) UNSIGNED NOT NULL,
    `paying_method` VARCHAR(100) NOT NULL,
    `compensation_rate` DECIMAL(15, 2) NOT NULL,
    `compensation_frequency` ENUM('hourly','weekly','monthly','annually') NOT NULL,
    `hours_in_week` INT(10) NOT NULL,
    `ssn_ein` VARCHAR(200) NOT NULL,
    `street` VARCHAR(200) NOT NULL,
    `street_2` VARCHAR(200) NOT NULL,
    `state` VARCHAR(100) NOT NULL,
    `state_id` BIGINT(20) NOT NULL,
    `city` VARCHAR(100) NOT NULL,
    `zip` VARCHAR(100) NOT NULL,
    `country` BIGINT(20) NOT NULL,
    `added_on` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_on` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY(`tenant_id`) REFERENCES tbltenants(`id`),
    FOREIGN KEY(`staff_id`) REFERENCES tblstaff(`staffid`)
) ENGINE = InnoDB;