database_assignment
Tables (9)
BOOKMARK
- bookmark_id — BIGINT
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- recipe_id — BIGINT — Foreign key → RECIPE.recipe_id — NOT NULL
- created_at — DATETIME — NOT NULL
COMMENT
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → COOK_POST.post_id — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
COOK_POST
- post_id — BIGINT
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- recipe_id — BIGINT — Foreign key → RECIPE.recipe_id
- img_url — VARCHAR(500)
- content — TEXT
- like_count — INT
- created_at — DATETIME — NOT NULL
FOLLOW
- follow_id — BIGINT
- follower_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- following_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
INGREDIENT
- ingredient_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- unit — VARCHAR(20)
RECIPE
- recipe_id — BIGINT
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- category — VARCHAR(50)
- difficulty — VARCHAR(20)
- cook_time — INT
- description — TEXT
- created_at — DATETIME — NOT NULL
RECIPE_INGREDIENT
- ri_id — BIGINT
- recipe_id — BIGINT — Foreign key → RECIPE.recipe_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → INGREDIENT.ingredient_id — NOT NULL
- amount — VARCHAR(50)
REVIEW
- review_id — BIGINT
- recipe_id — BIGINT — Foreign key → RECIPE.recipe_id — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- rating — TINYINT
- content — TEXT
- created_at — DATETIME — NOT NULL
USER
- user_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- profile_img — VARCHAR(500)
- bio — TEXT
- created_at — DATETIME — NOT NULL