CREATE TABLE "person" (
	"id" int,
	"email" varchar(255),
	"phone_number" varchar(255),
	"" varchar(255),
	"" datetime
);
CREATE TABLE "conversation" (
	"id" int,
	"person_id" int,
	"" datetime,
	"status" varchar(255),
	"fingerprint" varchar(255),
	FOREIGN KEY("person_id") REFERENCES "person" ("id")
);
CREATE TABLE "message" (
	"id" int,
	"conversation_id" int,
	"body" varchar(255),
	"person_id" int,
	"status" varchar(255),
	FOREIGN KEY("conversation_id") REFERENCES "conversation" ("id"),
	FOREIGN KEY("person_id") REFERENCES "person" ("id")
);
CREATE TABLE "recipient" (
	"person_id" int,
	"conversation_id" int,
	"status" varchar(255),
	"contact_id" int,
	"id" int,
	FOREIGN KEY("person_id") REFERENCES "person" ("id"),
	FOREIGN KEY("conversation_id") REFERENCES "conversation" ("id"),
	FOREIGN KEY("contact_id") REFERENCES "contact" ("id")
);
CREATE TABLE "contact" (
	"id" int,
	"owner_id" int,
	"phone_number" varchar(255),
	"target_user_id (opt)" int,
	FOREIGN KEY("owner_id") REFERENCES "person" ("id"),
	FOREIGN KEY("target_user_id (opt)") REFERENCES "person" ("id")
);