다모아레시피 1차
테이블 (7)
Untitled (user)
- Key (user_id) — VARCHAR(30) — 기본 키 — NOT NULL
- Field (user_pw) — VARCHAR(30)
- Field (user_name) — VARCHAR(30)
- Field2 (user_email) — VARCHAR(100)
- Field (user_image) — VARCHAR(500) — ex) 프로필 사진
- Field (user_created_at) — TIMESTAMP
- Field (user_updated_at) — TIMESTAMP
- Field (user_status) — TINYINT
Untitled (category)
- Key (category_id) — INT — 기본 키 — NOT NULL
- Field (category_type) — VARCHAR(30)
- Field (category_created_at) — TIMESTAMP
- Field2 (category_updated_at) — TIMESTAMP
- Field (category_status) — TINYINT
Untitled (recipe)
- Key (recipe_id) — BIGINT — 기본 키 — NOT NULL
- Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (recipe_author_id) — VARCHAR(30) — NOT NULL — 레시피 작성자
- Field (recipe_name) — VARCHAR(30)
- Field (recipe_content) — VARCHAR(10000)
- Field2 (recipe_cooking_time) — VARCHAR(30)
- Field3 (recipe_level) — TINYINT
- Field4 (recipe_created_at) — TIMESTAMP
- Field5 (recipe_updated_at) — TIMESTAMP
- Field6 (recipe_status) — TINYINT
Untitled (ingredient)
- Key (ingredient_id) — VARCHAR(30) — 기본 키 — NOT NULL
- Field (ingredient_unit) — VARCHAR(30) — ex) 10g, 1kg
- Field (ingredient_created_at) — TIMESTAMP
- Field2 (ingredient_updated_at) — TIMESTAMP
- Field3 (ingredient_status) — TINYINT
Untitled (image(recipe))
- Key (image_id) — VARCHAR(300) — 기본 키 — NOT NULL
- Key (recipe_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (image1) — VARCHAR(500)
- Field2 (image2) — VARCHAR(500)
- Field3 (image3) — VARCHAR(500)
- Field4 (image4) — VARCHAR(500)
- Field5 (image5) — VARCHAR(500)
- Field6 (image_created_at) — TIMESTAMP
- Field7 (image_updated_at) — TIMESTAMP
- Field8 (image_status) — TINYINT
Untitled (recipe-ingredient)
- Key (recipe_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL — 여러 개의 재료가 여러 개의 레시피에 들어갈 수 있기 때문에 M:N
- Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (ingredient_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled2 (review)
- Key (review_id) — BIGINT — 기본 키 — NOT NULL
- Key (recipe_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id2) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (review_author_id) — VARCHAR(30) — NOT NULL — 리뷰 작성자
- Field (review_content) — VARCHAR(5000)
- Field (review_created_at) — TIMESTAMP
- Field (review_updated_at) — TIMESTAMP
- Field (review_status) — TINYINT