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 CONSTRAINT tblcontact_ REFERENCES tblcontact(),
	"areacodeid" int CONSTRAINT tblareacode_ 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 CONSTRAINT tblcontact_ REFERENCES tblcontact(),
	"contactaliastext" varchar(255)
);