CREATE TABLE `tblcontact` (
	`contactid` int PRIMARY KEY,
	`contactfirstname` varchar(255),
	`contactmiddlename` varchar(255),
	`contactlastname` varchar(255)
);
CREATE TABLE `tblphonenumber` (
	`phonenumberid` int PRIMARY KEY,
	`contactid` int,
	`areacodeid` int,
	`phonenumbertext` varchar(255),
	`phonenumberdigits` int,
	`phonenumbercreated` datetime,
	`phonenumberupdated` datetime,
	FOREIGN KEY(`contactid`) REFERENCES `tblcontact` (``),
	FOREIGN KEY(`areacodeid`) REFERENCES `tblareacode` (``)
);
CREATE TABLE `tblareacode` (
	`areacodeid` int PRIMARY KEY,
	`areacodenumber` int
);
CREATE TABLE `tblcontactalias` (
	`contactaliasid` int,
	`contactid` int,
	`contactaliastext` varchar(255),
	FOREIGN KEY(`contactid`) REFERENCES `tblcontact` (``)
);