Database - Design

[TheMoakMan]

This step is to design a relational database (mainly schema) for the project. The design needs to contain at least the following information plus some added attributes

UPDATE : Please Read the Comments of this Post.

Tables

• Machines

  • machine_ID, location (coordinates), brand_of_machine, network_IP, location_description, ...

• Machine Inventory

  • Not sure if this is to be stored in the back-end or on the PI, (most likely the PI)
  • item, quantity_of_item, price_of_item, ...

• Items

  • item_ID, item_photo, item_nutrition?

• Users

  • I don't know how user information should be stored in the database, I have no experience with this, confer with Jacques.

• Anything else

[jacquesaronius]

Let's just build an ORM in EFCore. That way we can puke out the database on whatever platform we choose.

[TheMoakMan]

Okay, I need someone to look into this EFCore and the Object Relational Mapping (ORM). From what I understand we can create objects and the tool EFCore will create a database design based on this.

[jacquesaronius]

EFCore is just spicy SQL Server.

[TheMoakMan]

What about the SQL Lite for the Raspberry Pi itself.

[TheMoakMan]

What language are we going to write the software for the Pi? We could do it in Python probably

[jacquesaronius]

EF Core will generate a SQLite schema as well

[itotallyrock]

This will be switching to typeorm to better fit with the nodejs backend. Similar in style to entity framework.