
/* 1 first parent*/
INSERT INTO 'travel' (`id`, `person_id`, `medication`, `allergies`, `blood_type_id`, `remarks`, `airline_code`, `loyalty_number`) VALUES (14, 523, 'euthyrox 25mg/day', 'iodium/iodine', 7, '<p>Second passport : NVB6PRoHo , valid up to: 19 march 2020</p>', 'KLM', '1112845892');

/* 2 second parent */
INSERT INTO 'file' (`id`, `name`, `created`, `hash`, `extension`, `mime_type`, `owner`, `modified`, `status`, `'file'_url`) VALUES (19797, 'HFF John EV.9859 Mombasa.docx', '2018-04-26 13:10:34', '1794e5037417a5d36201804267ad4450c43efa8730001004', 'docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 6881, NULL, 1, '2018/04/26/7/9/794e5037417a5d367ad4450c43efa873.docx');
INSERT INTO 'file' (`id`, `name`, `created`, `hash`, `extension`, `mime_type`, `owner`, `modified`, `status`, `'file'_url`) VALUES (19812, 'HFF John Doe for AS.9120 ILO-Haiti 3. docx.docx', '2018-04-30 10:31:53', '150ab655739303eab20180430e95b0b95306660f70001004', 'docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 251, NULL, 1, '2018/04/30/5/0/50ab655739303eabe95b0b95306660f7.docx');
INSERT INTO 'file' (`id`, `name`, `created`, `hash`, `extension`, `mime_type`, `owner`, `modified`, `status`, `'file'_url`) VALUES (20807, 'AS9121 HFF John Doe.docx', '2018-07-13 13:25:21', '12e99fc75754e95bf20180713453adfeb142af9ee0001004', 'docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 5438, NULL, 1, '2018/07/13/2/e/2e99fc75754e95bf453adfeb142af9ee.docx');
INSERT INTO 'file' (`id`, `name`, `created`, `hash`, `extension`, `mime_type`, `owner`, `modified`, `status`, `'file'_url`) VALUES (23508, 'HFF John Doe AS.10994.docx', '2019-01-29 14:31:25', '1d43bd461c0366c4620190129dfb3fff39d26257a0001004', 'docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 5438, NULL, 1, '2019/01/29/d/4/d43bd461c0366c46dfb3fff39d26257a.docx');
INSERT INTO 'file' (`id`, `name`, `created`, `hash`, `extension`, `mime_type`, `owner`, `modified`, `status`, `'file'_url`) VALUES (24103, 'HFF John Doe AS.10960.docx', '2019-02-28 09:35:48', '113fddcc1f473682b20190228c6375b98fafa92aa0001004', 'docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 252, NULL, 1, '2019/02/28/1/3/13fddcc1f473682bc6375b98fafa92aa.docx');

/* 3 relationship*/
INSERT INTO 'travel_documents' (`travel_id`, `'file'_id`) VALUES (14, 19797);
INSERT INTO 'travel_documents' (`travel_id`, `'file'_id`) VALUES (14, 19812);
INSERT INTO 'travel_documents' (`travel_id`, `'file'_id`) VALUES (14, 20807);
INSERT INTO 'travel_documents' (`travel_id`, `'file'_id`) VALUES (14, 23508);
INSERT INTO 'travel_documents' (`travel_id`, `'file'_id`) VALUES (14, 24103);

/* A delete of a record from travel_documents, is not send to Kafka */