.uml

@startuml

left to right direction
skinparam roundcorner 15
skinparam shadowing true
skinparam handwritten false
skinparam class {
    BackgroundColor white
    ArrowColor #2688d4
    BorderColor #2688d4
}

!define table(x) entity x << (T, LightSkyBlue) >>
!define primary_key(x) <b><color:#b8861b><&key></color> x</b>
!define foreign_key(x) <color:#aaaaaa><&key></color> <u>x</u>
!define column(x) <color:#efefef><&media-record></color> x
!define column_fk(x) <color:#efefef><&media-record></color> <u>x</u>

table( recipe_ingredients ) {
  foreign_key( recipe_id ): INTEGER
  foreign_key( ingredient_id ): INTEGER
}

table( recipe_type ) {
  primary_key( type_id ): INTEGER PRIMARY KEY
  column( type_name ): TEXT NOT NULL
}

table( recipes ) {
  primary_key( recipe_id ): INTEGER PRIMARY KEY
  column( name ): TEXT
  foreign_key( type_id ): INTEGER
}

ingredient_list::ingredient_id --> recipe_ingredients::ingredient_id
recipes::recipe_id --> recipe_ingredients::recipe_id
recipe_type::type_id --> recipes::type_id

@enduml