DROP TABLE IF EXISTS `Customer`;
;
;
CREATE TABLE `Customer` (
`CustomerID` varchar(45) NOT NULL,
`Username` varchar(45) NOT NULL,
`Password` varchar(45) NOT NULL,
`Gender` varchar(45) NOT NULL,
`DoB` date NOT NULL,
`AddressID` varchar(45) NOT NULL,
`ContactID` varchar(45) NOT NULL,
`Picture` blob NOT NULL,
PRIMARY KEY (`CustomerID`),
KEY `AddressID` (`AddressID`),
KEY `ContactID` (`ContactID`),
CONSTRAINT `AddressID` FOREIGN KEY (`AddressID`) REFERENCES `Addresses` (`AddressID`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ContactID` FOREIGN KEY (`ContactID`) REFERENCES `Contacts` (`ContactID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
@Zenonymous