CREATE TABLE `Announcement` (
    `Id` int(11) NOT NULL,
    `IsDeleted` int(11),
    `CreatedDate` varchar(255),
    `CreatedById` int(11), -- foreign key: User.Id,
    `LastModifiedDate` varchar(255),
    `LastModifiedById` int(11), -- foreign key: User.Id,
    `SystemModstamp` varchar(255),
    `FeedItemId` int(11), -- foreign key: FeedItem.Id,
    `ExpirationDate` varchar(255),
    `SendEmails` int(11),
    `IsArchived` int(11),
    `ParentId` int(11), -- foreign key: CollaborationGroup.Id,
    PRIMARY KEY (`Id`) ,
    CONSTRAINT `FK_Announcement_CreatedById` FOREIGN KEY (`CreatedById`) REFERENCES `User` (`Id`),
    CONSTRAINT `FK_Announcement_LastModifiedById` FOREIGN KEY (`LastModifiedById`) REFERENCES `User` (`Id`),
    CONSTRAINT `FK_Announcement_FeedItemId` FOREIGN KEY (`FeedItemId`) REFERENCES `FeedItem` (`Id`),
    CONSTRAINT `FK_Announcement_ParentId` FOREIGN KEY (`ParentId`) REFERENCES `CollaborationGroup` (`Id`)
);
