ㅇㅁㅇㄴㅁ

Tables (8)

cheap_recipe

  • id — SERIAL
  • recipe_id — INTEGER — NOT NULL
  • menu — VARCHAR(64) — NOT NULL
  • youtube_url — VARCHAR(1024) — NOT NULL
  • min_total_price — FLOAT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ingredient

  • id — SERIAL
  • alternative_id — INTEGER — Foreign key → ingredient.id
  • cheapest_product_id — INTEGER
  • name — VARCHAR(64) — NOT NULL
  • quantity — FLOAT
  • unit — VARCHAR(32)
  • vague — VARCHAR(64)

menu

  • id — SERIAL
  • name — VARCHAR(64) — NOT NULL
  • category — VARCHAR(64)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

quantity_conversion

  • conversion_id — SERIAL
  • ingredient_name — VARCHAR(64)
  • unit_name — VARCHAR(32)
  • converted_gram — FLOAT

recipe

  • id — SERIAL
  • youtube_vdo_id — INTEGER — Foreign key → youtube_vdo.id — NOT NULL
  • menu_id — INTEGER — Foreign key → menu.id — NOT NULL
  • portions — SMALLINT

recipe_ingredient

  • id — SERIAL
  • recipe_id — INTEGER — Foreign key → recipe.id — NOT NULL
  • ingredient_id — INTEGER — Foreign key → ingredient.id — NOT NULL

unit_conversion

  • conversion_id — SERIAL
  • standard_unit — VARCHAR(32)
  • converted_vol — FLOAT
  • unit_name — VARCHAR(32)

youtube_vdo

  • id — SERIAL
  • menu_id — INTEGER — Foreign key → menu.id — NOT NULL
  • youtube_url — VARCHAR(256) — NOT NULL
  • full_text — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP