CREATE TABLE "User" (
	"id" int PRIMARY KEY,
	"email" varchar(255),
	"password" varchar(255)
);
CREATE TABLE "AuthInfo" (
	"id" int PRIMARY KEY,
	"user_id" int CONSTRAINT User_id REFERENCES User(id),
	"client_id" int CONSTRAINT Client_id REFERENCES Client(id),
	"scope" varchar(255) CONSTRAINT Scope_id REFERENCES Scope(id),
	"refresh_token" varchar(255),
	"code" varchar(255),
	"redirect_uri" varchar(255) CONSTRAINT Client_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)
);