CREATE TABLE "User" (
	"id" int PRIMARY KEY,
	"email" varchar(255),
	"password" varchar(255)
);
CREATE TABLE "AuthInfo" (
	"id" int PRIMARY KEY,
	"user_id" int,
	"client_id" int,
	"scope" varchar(255),
	"refresh_token" varchar(255),
	"code" varchar(255),
	"redirect_uri" varchar(255),
	FOREIGN KEY("user_id") REFERENCES "User" ("id"),
	FOREIGN KEY("client_id") REFERENCES "Client" ("id"),
	FOREIGN KEY("scope") REFERENCES "Scope" ("id"),
	FOREIGN KEY("redirect_uri") REFERENCES "Client" ("redirect_uri")
);
CREATE TABLE "Client" (
	"id" int PRIMARY KEY,
	"redirect_uri" varchar(255),
	"secret" varchar(255),
	"name" varchar(255)
);
CREATE TABLE "Scope" (
	"id" varchar(255) PRIMARY KEY,
	"description" varchar(255)
);