Data Model

Disclaimer: As this is an interface, is not expected to have a large number of recipes in a local database. That's why we recommend import them when you need, and delete unused ones.

Simple model database

Relations

Ref: S.receipe_id > R.id	/// many to one rationship between Steps and Receipe
Ref: Sp.recipe > R.id		/// many to one rationship between Supply and Receipe
Ref: Sp.material > M.id		/// many to one rationship between Supply and Material

• Recipe: A recipe

Complete text to reproduce diagram

/// last modified: 29-08-2021
/// @author: Marcelo Becerra A.
/// @project: BioMixer
/// @model: Receipe Material
Table Material as M {
  id int [pk, increment]
  type varchar(2)
  name varchar(200)
  chemical_formula varchar(200)
}

Table Recipe as R {
  id int [pk, increment]  
  name varchar
  tag varchar
  img_link link
  creation_date date
}

Table Steps as S{
  id int [pk, increment]
  recipe_id int
  text varchar(100)
}

Ref: S.recipe_id > R.id

Table Supply as Sp {
  id int [pk, increment]
  recipe int
  position int
  material int
  value int
  type varchar(2)
}

Ref: Sp.recipe > R.id
Ref: Sp.material > M.id

Postgress SQL database