CREATE TABLE "contact" (
	"id" int PRIMARY KEY,
	"first name" varchar(255),
	"last name" varchar(255)
);
CREATE TABLE "address" (
	"id" int PRIMARY KEY,
	"street address" varchar(255),
	"house number" varchar(255),
	"zipcode" varchar(255),
	"city" varchar(255)
);
CREATE TABLE "contact_address" (
	"contact_id" int,
	"address_id" int,
	FOREIGN KEY("contact_id") REFERENCES "contact" ("id"),
	FOREIGN KEY("address_id") REFERENCES "address" ("id")
);
CREATE TABLE "contact_phonenumber" (
	"contact_id" int,
	"phonenumber_id" int,
	FOREIGN KEY("contact_id") REFERENCES "contact" ("id"),
	FOREIGN KEY("phonenumber_id") REFERENCES "phonenumber" ("id")
);
CREATE TABLE "phonenumber" (
	"id" int PRIMARY KEY,
	"phonenumber" varchar(255),
	"mobile" varchar(255),
	"fax" varchar(255)
);