CREATE TABLE NotifyCalls
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    Service VARCHAR(30) NOT NULL,
    Communication BIGINT UNSIGNED NOT NULL,
    CommName VARCHAR(150) DEFAULT NULL,
    Person BIGINT UNSIGNED NOT NULL,
    Notification BIGINT UNSIGNED NOT NULL,
    Worker INT UNSIGNED DEFAULT NULL,
    CallLength INT UNSIGNED DEFAULT NULL,
    OnlineLength INT UNSIGNED DEFAULT NULL,
    InitiateTs BIGINT UNSIGNED DEFAULT NULL,
    AnswerTs BIGINT UNSIGNED DEFAULT NULL,
    DoneTs BIGINT UNSIGNED DEFAULT NULL,
    EndStatus VARCHAR(45) DEFAULT NULL,
    KEY ( Notification,Person,Service ),
    KEY ( Notification ),
    KEY ( Communication ),
    KEY ( Communication, EndStatus ),
    PRIMARY KEY ( id )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="List of calls made during a notification";
