CREATE TABLE "user" (
	"id" int PRIMARY KEY,
	"user_name" varchar(255),
	"password" varchar(255)
);
CREATE TABLE "role" (
	"id" int PRIMARY KEY,
	"role_name" varchar(255)
);
CREATE TABLE "permission" (
	"id" int PRIMARY KEY,
	"permission_name" varchar(255)
);
CREATE TABLE "user_role" (
	"user_id" int,
	"role_id" int,
	FOREIGN KEY("user_id") REFERENCES "user" ("id"),
	FOREIGN KEY("role_id") REFERENCES "role" ("id")
);
CREATE TABLE "role_permission" (
	"role_id" int,
	"permission_id" int,
	FOREIGN KEY("role_id") REFERENCES "role" ("id"),
	FOREIGN KEY("permission_id") REFERENCES "permission" ("id")
);