Naengttogi

Tables (16)

cooking_attribute

  • id_bigint — BIGSERIAL
  • name — BIGINT — NOT NULL
  • method — BIGINT — NOT NULL
  • situation — BIGINT — NOT NULL
  • main_ingre — BIGINT — NOT NULL
  • type — BIGINT — NOT NULL

cooking_main_ingre

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

cooking_method

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

cooking_name_list

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

cooking_situation

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

cooking_type

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

detail_recipe

  • id_bigint — BIGSERIAL
  • img_url — VARCHAR(255)
  • recipe_text — TEXT — NOT NULL
  • tip — TEXT — NOT NULL
  • step — SMALLINT
  • recipe_id — BIGINT — NOT NULL

ingre_major

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

ingre_middle

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • major_id — BIGINT — NOT NULL

ingre_sub

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • middle_id — BIGINT — NOT NULL

ingredient

  • id_bigint — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • major_id — BIGINT — NOT NULL
  • middle_id — BIGINT — NOT NULL
  • sub_id — BIGINT — NOT NULL

recipe

  • id_bigint — BIGSERIAL
  • url — VARCHAR(255) — NOT NULL
  • recipe_name — TEXT — NOT NULL
  • nick_name — VARCHAR(255) — NOT NULL
  • recommend_num — INTEGER
  • recipe_intro — TEXT
  • eat_people — SMALLINT
  • difficulty — recipe_difficulty
  • cooking_time — INTEGER
  • thumbnail_url — VARCHAR(255)
  • attribute_id — BIGINT

recipe_ingredient_list

  • recipe_id — BIGINT — Primary key — NOT NULL
  • ingredient_id — BIGINT — Primary key — NOT NULL

refrigerator

  • id_bigint — BIGSERIAL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_activate — BOOLEAN
  • user_id — BIGINT — NOT NULL

refrigerator_ingredient_list

  • refrigerator_id — BIGINT — Primary key — NOT NULL
  • ingredient_id — BIGINT — Primary key — NOT NULL
  • expiration_date — DATE

user

  • id_bigint — BIGSERIAL
  • user_id — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_login_at — TIMESTAMP
  • is_activate — BOOLEAN — NOT NULL
  • role — user_role