Careman database structure

Relationship Graph

Diagram File

MySQL EER Diagram File

EER Diagram Image

View Image

Seed

This could have been improved as the entire database should have been seed-ready

php artisan db:seed

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class MessageTypeSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::table('message_types')->insert([
            ["type" => "Shift Begins", "message" => "Shift Starts tomorrow"],
            ["type" => "Shift Ends", "message" => "Shift Ends tomorrow"],
            ["type" => "Shift Nurse Change", "message" => "Shift change Nurse"],
        ]);
    }
}