Mastering TypeScript 3 - Third Edition

Database structure

The main tables that we will need for our sample application include the Board table, the Manufacturer table, and the BoardType table. The Board table is as follows:

CREATE TABLE `Board` ( 
   `id`  INTEGER NOT NULL DEFAULT 1 PRIMARY KEY  
         AUTOINCREMENT UNIQUE, 
   `name`      TEXT NOT NULL, 
   `short_description`     TEXT, 
   `long_description`      TEXT, 
   `img` TEXT 
); 

Here, we can see the CREATE command for our Board table. It has an id property that will automatically increment, and also serves as the primary key. Along with the id property, each board has a name property, a short_description, long_description, and an img property. The img property will be used to load the relevant image for display.

The Manufacturer table is as follows:

CREATE TABLE ...