this is to show that it works trx pin or order id: 852f632e96 column definition file for laravel vendor/laravel/framework/src/Illuminate/Database/Schema/ColumnDefinition.php Things that should never be deleted, can only be created and updated, but never deleted 1. books (can only clear purchase history after every semester) 2. organisations (can only update) 3. add the following to the LIve server /routes /resources/views/layouts /resources/views/snit /resources/views/components { modified: resources/views/components/delete-refresh.blade.php resources/views/components/delete-resource-and-refresh.blade.php } /app/Http/Controllers /app/Models/Dept.php /database/migrations/2023_07_28_143608_create_depts_table.php /database/migrations/2023_07_01_214506_create_courses_table.php modified: /public/pub_resources/js/helpers.js //actions : run php artisan migrate //optional (only for dev purposes) /database/seeders/DeptSeeder.php NB: pls note that the helpers file I'm using in my code is resided in the /public/pub_resources/ directory ================ random password : Pa$$w0rd! authors can belong to more than one school via having multiple accounts table restructure use user roles __ongoing | migrated remove is_sch based on user role on registration, you create either an author profile or a schAdmin profile new tables org_admins | done ============================== user registration case scenarios ==============Successful=============== instructor registers with existing org done instructor registers with new org org_admin registers with existing org (correct ims_code) org_admin registers with new org (ims_code is autogenerated) ==============Error=============== org_admin registers with existing org (wrong ims_code [but valid code in db]) org_admin registers with existing org (invalid ims_code [not existing in db])