CREATE TABLE `cargo_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `contract_cargo_sub_id` int(11) unsigned NOT NULL,
  `object_type` enum('auto',' wagon',' vessel',' placement') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `contract_cargo_sub_id` (`contract_cargo_sub_id`),
  CONSTRAINT `cargo_card_fk1` FOREIGN KEY (`contract_cargo_sub_id`) REFERENCES `contract_cargo_sub` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `auto_cargo_card` (
  `id` int(11) unsigned NOT NULL,
  `auto_card_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `auto_card_id` (`auto_card_id`),
  CONSTRAINT `auto_cargo_card_fk2` FOREIGN KEY (`id`) REFERENCES `cargo_card` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `auto_cargo_card_fk1` FOREIGN KEY (`auto_card_id`) REFERENCES `auto_card` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CONSTRAINT `auto_cargo_card_fk1` FOREIGN KEY (`auto_card_id`) REFERENCES `auto_card` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

CREATE TABLE `cargo_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `contract_cargo_sub_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `cargo_card_fk2` FOREIGN KEY (`id`) REFERENCES `auto_cargo_card` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `auto_cargo_card` (
  `id` int(11) unsigned NOT NULL,
  `auto_card_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `auto_cargo_card_fk2` FOREIGN KEY (`id`) REFERENCES `cargo_card` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `cargo_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  CONSTRAINT `cargo_card_fk2` FOREIGN KEY (`id`) REFERENCES `auto_cargo_card` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `auto_cargo_card` (
  `id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `auto_cargo_card_fk2` FOREIGN KEY (`id`) REFERENCES `cargo_card` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `cargo_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `contract_cargo_sub_id` int(11) unsigned NOT NULL,
  `auto_card_id: integer,
  `wagon_card_id: integer,
  `самолет_id: integer`,
  `воздушный_шар_id: integer,
  `пароход_id: integer,
  PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `человек` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ФИО,
  `№ карты пациента`, // Иванов Иннокентий Петрович
  `размер матки`,
  `сколько раз рожала`,
  .............
  ........
  PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

CREATE TABLE `cargo_card` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `contract_cargo_sub_id` int(11) unsigned NOT NULL,
  `траспортное_средство_card_id: integer,
  PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

DELETE auto_card, auto_cargo_card, cargo_card
FROM auto_card
LEFT JOIN auto_cargo_card ON auto_cargo_card.auto_card_id = auto_card.id
LEFT JOIN cargo_card ON cargo_card.id = auto_cargo_card.id
WHERE auto_card.id = :auto_card_id