Database Diagram Generator and Visualizer for MySQL Schema

SchemaVerse - Database Diagram Visualizer

Light Toggle Theme Dark

SQL Schema Input CREATE TABLE `users` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `role` ENUM('sales_agent','manager','admin') NOT NULL, `first_name` VARCHAR(255) NOT NULL, `last_name` VARCHAR(255) DEFAULT NULL, `email` VARCHAR(255) NOT NULL, `password` VARCHAR(255) NOT NULL, `spoken_languages` VARCHAR(255) DEFAULT NULL, `status` ENUM('active','inactive','invited', 'invite_expired') DEFAULT 'active', `reset_token` VARCHAR(255) DEFAULT NULL, `reset_token_expiry` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, `created_by` INT(11) NOT NULL, `updated_by` INT(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ); CREATE TABLE `campaigns` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `description` TEXT DEFAULT NULL, `status` ENUM('active','inactive') DEFAULT 'active', `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, `created_by` INT(11) NOT NULL, `updated_by` INT(11) DEFAULT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `campaign_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int(11) NOT NULL, `updated_by` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `campaign_users_uc_1` (`campaign_id`, `user_id`), KEY `user_id` (`user_id`), CONSTRAINT `campaign_users_ibfk_1` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE, CONSTRAINT `campaign_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL );

Entity-Relationship Diagram