File manager

File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/db/rating_systemV2.sql

Back
-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Table `abilities` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `abilities` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `entity_id` BIGINT UNSIGNED NULL DEFAULT NULL, `entity_type` VARCHAR(255) NULL DEFAULT NULL, `only_owned` TINYINT(1) NOT NULL DEFAULT '0', `options` JSON NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `abilities_scope_index` (`scope` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `systems` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `systems` ( `id` INT NOT NULL AUTO_INCREMENT, `system_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `templates` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `templates` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `q_id` VARCHAR(999) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `questionnaires` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questionnaires` ( `id` INT NOT NULL AUTO_INCREMENT, `s_id` INT NOT NULL, `t_id` INT NOT NULL, `instruction` VARCHAR(499) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `s_id` (`s_id` ASC, `t_id` ASC), INDEX `system_id_idx` (`s_id` ASC), INDEX `t_id_idx` (`t_id` ASC), CONSTRAINT `s_id` FOREIGN KEY (`s_id`) REFERENCES `systems` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `answers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `answers` ( `id` INT NOT NULL AUTO_INCREMENT, `user_id` INT NOT NULL, `qstnn_id` INT NULL DEFAULT NULL, `tmpt_id` INT NOT NULL, `qst_id` VARCHAR(455) NOT NULL, `syst_id` INT NULL DEFAULT NULL, `rating` VARCHAR(455) NOT NULL, `comment` VARCHAR(255) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `user_id` (`user_id` ASC, `qstnn_id` ASC, `tmpt_id` ASC, `syst_id` ASC), INDEX `qstnn_id` (`qstnn_id` ASC), INDEX `syst_id` (`syst_id` ASC), INDEX `tmpt_id` (`tmpt_id` ASC), CONSTRAINT `qstnn_id` FOREIGN KEY (`qstnn_id`) REFERENCES `questionnaires` (`id`), CONSTRAINT `syst_id` FOREIGN KEY (`syst_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `roles` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `roles` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `roles_name_unique` (`name` ASC, `scope` ASC), INDEX `roles_scope_index` (`scope` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `assigned_roles` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `assigned_roles` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `role_id` BIGINT UNSIGNED NOT NULL, `entity_id` BIGINT UNSIGNED NOT NULL, `entity_type` VARCHAR(255) NOT NULL, `restricted_to_id` BIGINT UNSIGNED NULL DEFAULT NULL, `restricted_to_type` VARCHAR(255) NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `assigned_roles_entity_index` (`entity_id` ASC, `entity_type` ASC, `scope` ASC), INDEX `assigned_roles_role_id_index` (`role_id` ASC), INDEX `assigned_roles_scope_index` (`scope` ASC), CONSTRAINT `assigned_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `asa_id` INT NULL DEFAULT NULL, `f_name` VARCHAR(45) NOT NULL, `l_name` VARCHAR(45) NULL DEFAULT NULL, `email` VARCHAR(255) NOT NULL, `email_verified_at` TIMESTAMP NULL DEFAULT NULL, `password` VARCHAR(255) NOT NULL, `remember_token` VARCHAR(100) NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `type` VARCHAR(45) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `users_email_unique` (`email` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `audit_trail` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `audit_trail` ( `id` INT NOT NULL AUTO_INCREMENT, `usr` INT UNSIGNED NOT NULL, `action` VARCHAR(100) NOT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `usr_idx` (`usr` ASC), CONSTRAINT `usr` FOREIGN KEY (`usr`) REFERENCES `users` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `companies` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `companies` ( `id` INT NOT NULL, `comp_code` VARCHAR(45) NOT NULL, `comp_name` VARCHAR(45) NOT NULL, `created_at` DATETIME NOT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `device_access` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `device_access` ( `id` INT NOT NULL AUTO_INCREMENT, `tablet` INT NOT NULL DEFAULT '0', `mobile` INT NOT NULL DEFAULT '0', `pc` INT NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `email_responses` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `email_responses` ( `id` INT NOT NULL AUTO_INCREMENT, `user` INT UNSIGNED NOT NULL, `ans` INT NOT NULL, `email` VARCHAR(45) NOT NULL, `created_at` DATETIME NOT NULL, `status` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `user_idx` (`user` ASC), INDEX `ans_idx` (`ans` ASC), CONSTRAINT `ans` FOREIGN KEY (`ans`) REFERENCES `answers` (`id`), CONSTRAINT `user` FOREIGN KEY (`user`) REFERENCES `users` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `failed_jobs` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` VARCHAR(255) NOT NULL, `connection` TEXT NOT NULL, `queue` TEXT NOT NULL, `payload` LONGTEXT NOT NULL, `exception` LONGTEXT NOT NULL, `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `failed_jobs_uuid_unique` (`uuid` ASC)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `forget_password` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `forget_password` ( `id` INT NOT NULL AUTO_INCREMENT, `email` VARCHAR(45) NULL DEFAULT NULL, `token` VARCHAR(45) NULL DEFAULT NULL, `link` VARCHAR(255) NULL DEFAULT NULL, `expires_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3 KEY_BLOCK_SIZE = 2; -- ----------------------------------------------------- -- Table `links` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `links` ( `id` INT NOT NULL AUTO_INCREMENT, `sys_id` INT NOT NULL, `tmp_id` INT NOT NULL, `link` VARCHAR(255) NOT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `sys_id_idx` (`sys_id` ASC), INDEX `tmp_id_idx` (`tmp_id` ASC), CONSTRAINT `sys_id` FOREIGN KEY (`sys_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmp_id` FOREIGN KEY (`tmp_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `migrations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `migrations` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `migration` VARCHAR(255) NOT NULL, `batch` INT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `password_resets` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `password_resets` ( `email` VARCHAR(255) NOT NULL, `token` VARCHAR(255) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`email`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `permissions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `permissions` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `ability_id` BIGINT UNSIGNED NOT NULL, `entity_id` BIGINT UNSIGNED NULL DEFAULT NULL, `entity_type` VARCHAR(255) NULL DEFAULT NULL, `forbidden` TINYINT(1) NOT NULL DEFAULT '0', `scope` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `permissions_entity_index` (`entity_id` ASC, `entity_type` ASC, `scope` ASC), INDEX `permissions_ability_id_index` (`ability_id` ASC), INDEX `permissions_scope_index` (`scope` ASC), CONSTRAINT `permissions_ability_id_foreign` FOREIGN KEY (`ability_id`) REFERENCES `abilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `personal_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` VARCHAR(255) NOT NULL, `tokenable_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NOT NULL, `token` VARCHAR(64) NOT NULL, `abilities` TEXT NULL DEFAULT NULL, `last_used_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `personal_access_tokens_token_unique` (`token` ASC), INDEX `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type` ASC, `tokenable_id` ASC)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `questions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questions` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `disclaimer` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `disclaimer` ( `id` INT NOT NULL, `content` VARCHAR(1000) NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings