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 FOREIGN KEY("contactid") REFERENCES "tblcontact" (""),
	"areacodeid" int FOREIGN KEY("areacodeid") REFERENCES "tblareacode" (""),
	"phonenumbertext" varchar(255),
	"phonenumberdigits" int,
	"phonenumbercreated" datetime,
	"phonenumberupdated" datetime
);
CREATE TABLE "tblareacode" (
	"areacodeid" int PRIMARY KEY,
	"areacodenumber" int
);
CREATE TABLE "tblcontactalias" (
	"contactaliasid" int,
	"contactid" int FOREIGN KEY("contactid") REFERENCES "tblcontact" (""),
	"contactaliastext" varchar(255)
);