CREATE TABLE Horse $($

ID INT UNSIGNED AUTO$\_$INCREMENT PRIMARY KEY,

RegisteredName VARCHAR$(15)$ NOT NULL,

Breed ENUM$(\text{'}$Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', 'Saddlebred'$)$ NOT NULL,

Height DECIMAL$(4,1)$ CHECK $($Height $>=10\mathrm{.}0$ AND Height $<=20\mathrm{.}0),$

BirthDate DATE CHECK $($BirthDate $>=\text{'}2015-01-01\text{'}),$

Notes TEXT

$)$ AUTO$\_$INCREMENT$=0$;