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" ("")
);