DROP table if exists Animal;
CREATE TABLE Animal (
    ID INT4 NOT NULL auto_increment primary key,
    MotherID INT4,
    ZooID INT4,
    PrefFoodID INT4,
    AltFoodID INT4,
    LastEsc TIMESTAMP,
    Name VARCHAR(100),
    Age INT(2),
    Lifespan FLOAT4,
    PrevZoos TEXT,
    Legs INT4 DEFAULT 4,
    Species VARCHAR(100)
);

DROP table if exists Zoo;
CREATE TABLE Zoo (
    ID INT4 auto_increment primary key,
    Name VARCHAR(255),
    Admission DECIMAL(6, 2),
    Founded DATE, 
    LastEsc TIMESTAMP,
    Opens TIME
);