CREATE TABLE parentAddress(
parentID INT NOT NULL,
addressID INT NOT NULL,
FOREIGN KEY (parentID) REFERENCES parent(parentID),
FOREIGN KEY (addressID) REFERENCES address(addressID)
) ENGINE=InnoDB;

CREATE TABLE referenceAddress(
referenceID INT NOT NULL,
addressID INT NOT NULL,
FOREIGN KEY (referenceID) REFERENCES reference(referenceID),
FOREIGN KEY (addressID) REFERENCES address(addressID)
) ENGINE=InnoDB;

CREATE TABLE emergencyAddress(
emergencyID INT NOT NULL,
addressID INT NOT NULL,
FOREIGN KEY (emergencyID) REFERENCES emergency(emergencyID),
FOREIGN KEY (addressID) REFERENCES address(addressID)
) ENGINE=InnoDB;