By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 0 Duplicates: 0 Warnings: 0
Records: 0 Duplicates: 0 Warnings: 0
| Table | Create Table |
|---|---|
| pet | CREATE TABLE `pet` ( `pet_id` smallint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL, `owner_id` smallint unsigned DEFAULT NULL, PRIMARY KEY (`pet_id`), KEY `idx_fk_pet_person` (`owner_id`), CONSTRAINT `fk_pet_person` FOREIGN KEY (`owner_id`) REFERENCES `person` (`person_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |