CREATE TABLE `contract_plus`.`tblstaff_app_usage_data`(
    `id` VARCHAR(191) NOT NULL,
    `tenant_id` BIGINT(20) UNSIGNED NOT NULL,
    `staff_id` BIGINT(20) UNSIGNED NOT NULL,
    `mobile_type` ENUM('android', 'ios') NOT NULL,
    `mobile_app_version` VARCHAR(300) NULL DEFAULT NULL,
    `device_id` VARCHAR(300) NOT NULL,
    `fcm_token` VARCHAR(300) NOT NULL,
    `mobile_api_token` VARCHAR(300) NOT NULL,
    `mobile_web_view_token` VARCHAR(300) NOT NULL,
    `is_logout` TINYINT(1) NOT NULL DEFAULT '0',
    `last_used` DATETIME NOT NULL,
    `device_info` TEXT NOT NULL,
    PRIMARY KEY(`id`)
) ENGINE = INNODB;