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 CONSTRAINT User_id REFERENCES User(id), "role_id" int CONSTRAINT Role_id REFERENCES Role(id) );