CREATE TABLE NotificationLaunchDatatype_Persistence
(
    isExpectingResponse TINYINT UNSIGNED NOT NULL COMMENT "Indication if the launch was expecting an answer at launch time",
    LaunchId BIGINT UNSIGNED NOT NULL COMMENT "ID of the launch for which we are persiting the information",
    FullMessage TEXT NOT NULL COMMENT "Text representation of the message sent at launch time",
    NotificationType VARCHAR(50) NOT NULL COMMENT "Class name representing the type of notification that was launched",
    LaunchById BIGINT UNSIGNED NOT NULL COMMENT "Node ID of the launcher ( typically a Person ID )",
    LaunchByEmail VARCHAR(128) DEFAULT NULL COMMENT "First email address of the launcher at launch time if it exists",
    LaunchByFirstName VARCHAR(50) DEFAULT NULL COMMENT "First name of the launcher",
    LaunchByLastName VARCHAR(50) NOT NULL COMMENT "Last name of the launcher",
    CommunicationTypes VARCHAR(255) NOT NULL COMMENT "JSON list of communication types that were configured at launch time",
    Answers VARCHAR(1000) NOT NULL COMMENT "JSON list of all possible actions that were configured at launch time",
    PRIMARY KEY ( LaunchId )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Launch related information snapshot taken at launch time";
