The test data is stored on an sqlite database. The model is illustrated above. It is a simplified version of a system that a retailer might have. The tables are as follows. The links are to the confuration files and open in a new tab.
To explore the data go to sudsjs.com/admin and log in with demo@demo.demo password demo. This will give you access to most of the functions (you can't edit this website and yoiu will have difficulty deleting the superuser). Other logins are:
- gladys@loman.demo password: gladys, permission: purchasing;
- howard@wagner.com password howard, permission: General manager
- willy@loman.com password willy, permission: sales
The tables in the test database are:
- Users: These might be for example, customers, suppliers, in-house staff or web developers. A user type fields is used to distinguish between them.
- Contacts: Records of contacts with the user.
- Products: Products sold by the organisation
- Product join: This establishes relations between products, for example spares. As a join table is creates many to many relationships between products.
- Purchase orders:
- Purchase order lines: Although the link to supplier is via the purchase order, there is some code to copy the supplier number into the individual lines to make anakysis easier.
- Sales orders:
- Sales order lines: Although the link to purchaser is via the sales order, there is some code to copy the customer number into the individual lines to make analysis easier.
- Web pages: This site.