dish
Tables (6)
images
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- image_name — INT — Foreign key → ingredients.id — NOT NULL
ingredients
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- category — VARCHAR(50)
- added_date — DATETIME
- limit_date — DATETIME — NOT NULL
- is_frozen — TINYINT(1)
- image_name — VARCHAR(255)
- kakao_id — BIGINT(20) — Foreign key → users.kakao_id — NOT NULL
notifications
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- body — VARCHAR(1000) — NOT NULL
- is_read — TINYINT(1)
- created_at — DATETIME
- kakao_id — BIGINT(20) — Foreign key → users.kakao_id — NOT NULL
recipes
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- subtitle — VARCHAR(255)
- youtube_link — VARCHAR(255) — NOT NULL
- steps — LONGTEXT — NOT NULL
- ingredients — LONGTEXT — NOT NULL
- seasonings — LONGTEXT — NOT NULL
- created_at — DATETIME
- kakao_id — BIGINT(20) — Foreign key → users.kakao_id — NOT NULL
stars
- id — INT — Primary key — NOT NULL
- recipe_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- kakao_id — BIGINT(20) — Foreign key → users.kakao_id — NOT NULL
users
- kakao_id — BIGINT(20) — Primary key — NOT NULL
- nickname — VARCHAR(255)
- profile_image — VARCHAR(255)
- created_at — DATETIME
- push_subscription — VARCHAR(2000)