create table species (
    speciesID varchar(32) primary key,
	categoryID varchar(16) not null references speciesCategories(categoryID),
    subCategoryID varchar(16),
    commonName varchar(32),
    scientificName varchar(48),
	imagePath varchar(64),
	maxLength real,
	lifeSpanLow integer,
	lifeSpanHigh integer,
	diet varchar(16),
	isActive tinyint not null default 1
);
