CREATE TABLE "User" ( "id" int, "username" varchar(255), "salt" varchar(255), "password_digest" varchar(255), "is_enabled" bool ); CREATE TABLE "Role" ( "id" int PRIMARY KEY, "authority" varchar(255) ); CREATE TABLE "Assignment" ( "user_id" int FOREIGN KEY("user_id") REFERENCES "User" ("id"), "role_id" int FOREIGN KEY("role_id") REFERENCES "Role" ("id") );