CREATE TABLE `users` ( `id` int, `email` varchar(255), `password` varchar(255) ); CREATE TABLE `admins` ( `id` int, `email` varchar(255), `password` varchar(255) ); CREATE TABLE `cards` ( `id` int, `card_number` varchar(255), FOREIGN KEY(`card_number`) REFERENCES `card` (`number`) ); CREATE TABLE `statuses` ( `id` int, `user_id` int, `card_id` int, `online_count` int, `online_at` datetime, `offline_at` datetime, `status` bool, `value` int, FOREIGN KEY(`user_id`) REFERENCES `users` (`id`), FOREIGN KEY(`card_id`) REFERENCES `cards` (`id`) );