Database Schema

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. Databases may be stored on local file systems or hosted on a server. End users and applications interact with a database via a database management system (DBMS).

Databases are classified by the database model that they support. Two of the most popular currently are Relational Databases andNoSQL databases.

In a relational database, data is modelled as rows and columns in a series of tables, and queried via a language called SQL. This starter application is a builder for a schema for a relational database: you can add tables, configure their columns, and also configure "views", which are SQL queries that operate on the contents of the database.

SQL - Structured Query Language - is the language used to query or update a relational database. In this starter app we have the concept of a **view**, which is a prepared SQL statement that the database runs whenever something is updated.

There are many types of NoSQL databases, but their characterizing feature is that they do not store data in a tabular fashion.

Full documentation on this starter application is available here: https://docs.jsplumbtoolkit.com/toolkit/7.x/lib/starter-app-schema-builder