CREATE TABLE SMSCommunicationInboundLogs
(
    id          BIGINT NOT NULL AUTO_INCREMENT,
    Ts          BIGINT UNSIGNED NOT NULL COMMENT "Timestamp when the text was received by us",
    Provider    VARCHAR(25) DEFAULT NULL COMMENT "Operator network onto which this text was received",
    MobileFrom  VARCHAR(35) NOT NULL COMMENT "Mobile number, in E.164 format, from which this text was received",
    MobileTo    VARCHAR(35) NOT NULL COMMENT "Mobile number, in E.164 format, to which this text was targetted, likely 332211",
    Supplier    VARCHAR(15) DEFAULT NULL COMMENT "Supplier name that received the text",
    Zone        BIGINT UNSIGNED DEFAULT NULL COMMENT "Zone ID into which this SMS was handled,if known",
    SMSNode     BIGINT UNSIGNED DEFAULT NULL COMMENT "SMS Node ID related to this communication, if known",
    Message     TEXT NOT NULL COMMENT "Message or text received",

    PRIMARY KEY ( id )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Logs of inbound SMS communications";
