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 CONSTRAINT region_id REFERENCES region(id)
);
CREATE TABLE "box" (
	"id" int,
	"user_id" int CONSTRAINT users_ REFERENCES users(),
	"products_id" int CONSTRAINT products_id REFERENCES products(id)
);
CREATE TABLE "products" (
	"id" int,
	"name" varchar(255),
	"user_id" int CONSTRAINT users_id REFERENCES users(id),
	"box_id" int CONSTRAINT box_id REFERENCES box(id),
	"description" varchar(255),
	"sh_or_do" bool,
	"published" bool,
	"date_created" datetime,
	"tag_id" int CONSTRAINT tag_id REFERENCES tag(id)
);
CREATE TABLE "tag" (
	"id" int,
	"name" varchar(255)
);
CREATE TABLE "region" (
	"id" int,
	"name" varchar(255)
);