CREATE TABLE `ActiveFeatureLicenseMetric` (
    `Id` int(11) NOT NULL,
    `MetricsDate` varchar(255),
    `FeatureType` varchar(255),
    `SystemModstamp` varchar(255),
    `AssignedUserCount` int(11),
    `ActiveUserCount` int(11),
    `TotalLicenseCount` int(11),
    PRIMARY KEY (`Id`) 
);
CREATE TABLE `ActivePermSetLicenseMetric` (
    `Id` int(11) NOT NULL,
    `MetricsDate` varchar(255),
    `PermissionSetLicenseId` int(11), -- foreign key: PermissionSetLicense.Id,
    `SystemModstamp` varchar(255),
    `AssignedUserCount` int(11),
    `ActiveUserCount` int(11),
    PRIMARY KEY (`Id`) ,
    CONSTRAINT `FK_ActivePermSetLicenseMetric_PermissionSetLicenseId` FOREIGN KEY (`PermissionSetLicenseId`) REFERENCES `PermissionSetLicense` (`Id`)
);
CREATE TABLE `ActiveProfileMetric` (
    `Id` int(11) NOT NULL,
    `MetricsDate` varchar(255),
    `UserLicenseId` int(11), -- foreign key: UserLicense.Id,
    `ProfileId` int(11), -- foreign key: Profile.Id,
    `SystemModstamp` varchar(255),
    `AssignedUserCount` int(11),
    `ActiveUserCount` int(11),
    PRIMARY KEY (`Id`) ,
    CONSTRAINT `FK_ActiveProfileMetric_UserLicenseId` FOREIGN KEY (`UserLicenseId`) REFERENCES `UserLicense` (`Id`),
    CONSTRAINT `FK_ActiveProfileMetric_ProfileId` FOREIGN KEY (`ProfileId`) REFERENCES `Profile` (`Id`)
);
