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