SQL script for Australia Zoo Wildlife Hospital database creation and data insertion

/*--------------------------CREATE DATABASE -----------------------*/
CREATE DATABASE AustraliaZooWildlifeHospital;
/*---------------------------CREATE TABLES------------------------*/
/*----------------------BRAED_TYPE TABLES------------------------*/
CREATE TABLE BREAD_TYPE
(
BREAD_ID INT(10) NOT NULL,
BREAD_TYPE VARCHAR(150),
BREAD_NAME VARCHAR(150),
PRIMARY KEY (BREAD_ID)
)
;
/*-------------------AFFICITION TABLES------------------------*/
CREATE TABLE AFFICITION
(
AFFICITION_NO INT(10) NOT NULL,
AFFICITION_NAME VARCHAR(150),
PRIMARY KEY (AFFICITION_NO)
)
;
/*-------------------ANIMAL_INFO TABLES------------------------*/

CREATE TABLE ANIMAL_INFO
(
ANIMAL_ID VARCHAR(10) NOT NULL,
ANIMAL_TYPE VARCHAR(50) NOT NULL,
ANIMAL_NAME VARCHAR(50) NOT NULL,
RESCUER_LOCATION VARCHAR(50),
SUBURB VARCHAR(50),
LOCATION_GOV_AREA_SHIRE VARCHAR(50) NOT NULL,
ANIMAL_SITUATION VARCHAR(100),
HAPPENED VARCHAR(100),
AFFICITION_NO INT(10) NOT NULL,
FED VARCHAR(50),
MEDICATED VARCHAR(50) NOT NULL,
HOW_LONG_AGO VARCHAR(20),
POSTCODE INT(10) NOT NULL,
PRIMARY KEY (ANIMAL_ID),
FOREIGN KEY (AFFICITION_NO) REFERENCES AFFICITION(AFFICITION_NO)
)
;
/*-----------------------PATIENT_INFO TABLES------------------------*/
CREATE TABLE PATIENT_INFO
(
PATIENT_ID VARCHAR(10) NOT NULL,
ANIMAL_ID VARCHAR(10) NOT NULL,

BREAD_ID INT(10) NOT NULL,
KOALATAG VARCHAR (10),
MICROSHIP VARCHAR (10),
LEFTEARTAGE VARCHAR(10),
RIGHTEARTAG VARCHAR(10),
TURTLESTAG VARCHAR(10),
IDENTIFICATION VARCHAR (255),
PRIMARY KEY (PATIENT_ID),
FOREIGN KEY (ANIMAL_ID) REFERENCES ANIMAL_INFO(ANIMAL_ID),
FOREIGN KEY (BREAD_ID) REFERENCES BREAD_TYPE(BREAD_ID)
)
;
/*--------------------------PATIENT_DNA TABLES------------------------*/
CREATE TABLE PATIENT_DNA
(
DNA_NO VARCHAR(10) NOT NULL,
PATIENT_ID VARCHAR(10) NOT NULL,
DATETIMETAKEN DATETIME,
SYSTEMENTERDATETIME DATETIME,
RESULT VARCHAR(100),
PRIMARY KEY (DNA_NO),
FOREIGN KEY (PATIENT_ID) REFERENCES PATIENT_INFO(PATIENT_ID)
)
;

/*---------------------RESCUER_INFO TABLES------------------------*/
CREATE TABLE RESCUER_INFO
(
RESCUER_ID VARCHAR(10) NOT NULL,
FIRSTNAME VARCHAR(50) NOT NULL,
LASTNAME VARCHAR(50),
ADDRESS VARCHAR(200) NOT NULL,
PHONE VARCHAR(20),
MOBILE VARCHAR(20) NOT NULL,
EMAIL VARCHAR(20),
DATE DATE ,
PRIMARY KEY (RESCUER_ID)
)
;
/*------------------CONTACTS TABLES------------------------*/
CREATE TABLE CONTACTS
(
S_NO INT(10) NOT NULL,
CONTACT_TYPE VARCHAR(100) NOT NULL,
FIRSTNAME VARCHAR(50) NOT NULL,
LASTNAME VARCHAR(50),
TITLE VARCHAR(100) NOT NULL,
EMAIL VARCHAR(50),