CREATE TABLE "User" (
	"id" int,
	"username" varchar(255),
	"password" varchar(255),
	"email" varchar(255),
	"created_at" datetime,
	"updated_at" datetime
);
CREATE TABLE "Device" (
	"id" int,
	"uuid" int,
	"user_id" int,
	"created_at" datetime,
	"brand" varchar(255),
	"version" varchar(255),
	"operating_system" varchar(255),
	"model" varchar(255),
	FOREIGN KEY("user_id") REFERENCES "User" ("id")
);
CREATE TABLE "Permission" (
	"id" int,
	"from_user_id" int,
	"to_user_id" int,
	"device_id" int,
	"created_at" datetime,
	FOREIGN KEY("from_user_id") REFERENCES "User" ("id"),
	FOREIGN KEY("to_user_id") REFERENCES "User" ("id"),
	FOREIGN KEY("device_id") REFERENCES "Device" ("id")
);
CREATE TABLE "Log" (
	"id" int,
	"longitude" varchar(255),
	"device_id" int,
	"latitude" varchar(255),
	"timestamp" datetime,
	FOREIGN KEY("device_id") REFERENCES "Device" ("id")
);