CREATE TABLE "users" (
	"id" int,
	"email" varchar(255),
	"user_name" varchar(255),
	"phone number" varchar(255),
	"first_name" varchar(255),
	"last_name" varchar(255),
	"password" varchar(255),
	"bio" varchar(255),
	"approved" bool,
	"active" bool,
	"region_id" int,
	FOREIGN KEY("region_id") REFERENCES "region" ("id")
);
CREATE TABLE "box" (
	"id" int,
	"user_id" int,
	"products_id" int,
	FOREIGN KEY("user_id") REFERENCES "users" (""),
	FOREIGN KEY("products_id") REFERENCES "products" ("id")
);
CREATE TABLE "products" (
	"id" int,
	"name" varchar(255),
	"user_id" int,
	"box_id" int,
	"description" varchar(255),
	"sh_or_do" bool,
	"published" bool,
	"date_created" datetime,
	"tag_id" int,
	FOREIGN KEY("user_id") REFERENCES "users" ("id"),
	FOREIGN KEY("box_id") REFERENCES "box" ("id"),
	FOREIGN KEY("tag_id") REFERENCES "tag" ("id")
);
CREATE TABLE "tag" (
	"id" int,
	"name" varchar(255)
);
CREATE TABLE "region" (
	"id" int,
	"name" varchar(255)
);