Database SQL Creation Script

User Story

As a: developer,
I want: a database creation script
so that: we can start creating the database and every system that relies upon the database (see context diagram).

Functional Requirements

Must work on MySQL or SQLite (see datatypes available here: https://www.sqlite.org/datatype3.html)
No SQL Errors
Must include Create Table IF NOT EXISTS (see: https://dev.mysql.com/doc/refman/5.5/en/replication-features-create-if-not-exists.html)
Include some very simple diagram to help explain what is going on
Tutorial: https://www.w3schools.com/sql/sql_create_table.asp

Description

This file will be used to create the whole database schema, including the multiple tables and relationships.

MySQL Workbench can create an automatic schema diagram for you.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information