dd
Tables (4)
Favorites (즐겨찾기)
- F_id (즐겨찾기아이디) — VARCHAR(100) — Primary key — NOT NULL
- U_id (유저아이디) — VARCHAR(50) — Foreign key → Users.U_id — NOT NULL
- R_id (레시피아이디) — VARCHAR(100) — Foreign key → Recipes.R_id — NOT NULL
Recipes (레시피)
- R_id (레시피아이디) — VARCHAR(100) — Primary key — NOT NULL
- U_id (유저아이디) — VARCHAR(50) — Foreign key → Users.U_id — NOT NULL
- title (제목) — VARCHAR(255) — NOT NULL
- ingredients (재료) — TEXT — NOT NULL
- instructions (조리방법) — TEXT — NOT NULL
- image_url (이미지) — VARCHAR(255)
Reviews (리뷰)
- U_id (유저아이디) — VARCHAR(50) — Foreign key → Users.U_id — NOT NULL
- R_id (레시피아이디) — VARCHAR(100) — Foreign key → Recipes.R_id — NOT NULL
- content (리뷰내용) — TEXT — NOT NULL
- rating (리뷰평점) — INT — NOT NULL
Users (유저)
- U_id (유저아이디) — VARCHAR(50) — Primary key — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- nickname (닉네임) — VARCHAR(50) — NOT NULL