See project on retool.com
Creating a database from existing tables, queries to the database
Use all data from tables Northwind_Traders/assets/databases;
Project will work from existing database : Northwind_Traders/assets/northwinddb.sql
Express + PostgreSQL + Sequelize + BootstrapGET http:\{your_host}:{your_port}/ - start page;
GET http:\{your_host}:{your_port}/employees - get all employees;
GET http:\{your_host}:{your_port}/employees/:employeeid - get employees with current id;
GET http:\{your_host}:{your_port/customers - get all customers;
GET http:\{your_host}:{your_port}/customers/:customerid - get customers with current id;
GET http:\{your_host}:{your_port}/products - get all products;
GET http:\{your_host}:{your_port}/products/:productid - get products with current id;
GET http:\{your_host}:{your_port}/orders - get all orders;
GET http:\{your_host}:{your_port}/orders/:orderid - get orders with current id;
GET http:\{your_host}:{your_port}/suppliers/ - get all suppliers;
GET http:\{your_host}:{your_port}/suppliers/:supplierid - get suppliers with current id;
GET http:\{your_host}:{your_port}/search/ - search for products names or company name, contact name, contacttitle;
GET http:\{your_host}:{your_port}/dashboard - get all users sql query;