Test Data
The test data 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 if necessary with demo@demo.demo password demo. This will give you access to most of the functions (you can't edit this website and you will have difficulty deleting the superuser). Other logins are:
- gladys@loman.demo password: demo, permission: purchasing;
- howard@wagner.demo password demo, permission: General manager
- willy@loman.demo password demo, permission: sales
- trainer@trainer.demo password demo permission trainers - gives access to the exam case studies.
The tables in the test database are:
- Simple exam results database - normalised model
- Simple exam papers database - denormalised / structured data
- Subjectsdenorm: Subjects
- Papersdenorm Papers
- Studentdenorm Student and results
- Simple exam papers database - variable content
- Studentsubschema Students and results
- Subschema Subschemas for subjects and products
- Users and contacts
- Sales and purchases
- Products: Products sold by the organisation
- 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: In this case the sales order lines are denormalised and included in the sales order record
- Other files