create table animal ( `name` varchar(64) not null primary key, `type` varchar(16) not null, `count_legs` int not null, -- only used for birds `wingspan` int , -- only used for mammals `count_live_young` int );