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`) );