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 CONSTRAINT contact_id REFERENCES contact(id),
	"address_id" int CONSTRAINT address_id REFERENCES address(id)
);
CREATE TABLE "contact_phonenumber" (
	"contact_id" int CONSTRAINT contact_id REFERENCES contact(id),
	"phonenumber_id" int CONSTRAINT phonenumber_id REFERENCES phonenumber(id)
);
CREATE TABLE "phonenumber" (
	"id" int PRIMARY KEY,
	"phonenumber" varchar(255),
	"mobile" varchar(255),
	"fax" varchar(255)
);