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