tastylog2
Tables (6)
Category
- category_id — BIGINT — Primary key — NOT NULL — 카테고리Id
- category_name — VARCHAR(225) — 카테고리명
Member (Members)
- member_id — BIGINT — Primary key — NOT NULL — 고객 ID
- member_name — VARCHAR(225) — NOT NULL — 고객이름
- member_email — VARCHAR(225) — NOT NULL — 고객 이메일
- oauth_provider — VARCHAR(50) — NOT NULL — OAUTH 제공자
- oauth_id — VARCHAR(225) — NOT NULL — OAUTH ID
- password — VARCHAR(225)
Recipe
- recipe_id — BIGINT — Primary key — NOT NULL — 레시피 ID
- recipe_title — VARCHAR(255) — NOT NULL — 레시피명
- URL — VARCHAR(255) — URL
- recipe_content — TEXT — 요리법
- recipe_created — TIMESTAMP — NOT NULL — 레시피 생성날짜
- recipe_amount — VARCHAR(50) — 레시피인분
- recipe_time — VARCHAR(50) — 레시피소요시간
- recipe_difficulty — VARCHAR(50) — 레시피 난이도
- recipe_main_image — VARCHAR(225) — 레시피 메인 이미지
- recipe_tip — TEXT — 팁/주의사항
- recipe_image — VARCHAR(225) — 레시피 이미지
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — 고객 ID
- category_id — BIGINT — Foreign key → Category.category_id — NOT NULL — 카테고리 ID
Recipe_Ingredient
- ingredient_id — BIGINT — Primary key — NOT NULL — 레시피재료ID
- recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL — 레시피 ID
- ingredient_name — VARCHAR(225) — 재료이름
- ingredient_quantity — VARCHAR(50) — 재료단위/양
Recipe_Step
- recipe_step_id — BIGINT — Primary key — NOT NULL — 레시피단계ID
- recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL — 레시피 ID
- step_content — TEXT — 요리순서설명
- step_image — VARCHAR(225) — 단계이미지
- step_order — INT — 순서
- step_time — LocalTime
Recipe_spice
- recipe_spice_id — BIGINT — Primary key — NOT NULL — 레시피양념ID
- recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL — 레시피 ID
- spice_name — VARCHAR(225) — 양념이름
- spice_quantity — VARCHAR(50) — 재료타입/양