ㅇㅁㅇㄴㅁ
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