ALTER TABLE `families`
    ADD COLUMN `slug` varchar(170) NULL AFTER `name`;

ALTER TABLE `children`
    ADD COLUMN `slug` varchar(170) NULL AFTER `last_name`;

ALTER TABLE `families`
    ADD UNIQUE KEY `families_organization_slug_unique`
    (`organization_id`, `slug`);

ALTER TABLE `children`
    ADD UNIQUE KEY `children_family_slug_unique`
    (`family_id`, `slug`);
