MENUW
Tables (4)
Ingredient (재료)
- ingredientId (재료Id) — int — Primary key — NOT NULL
- ingredientName (재료이름) — varchar(100)
- ingredientImageURL (재료사진경로) — varchar(255)
- ingredientType (재료타입) — varchar(100)
Menu (메뉴)
- menuId (메뉴Id) — int — Primary key — NOT NULL
- menuLike (메뉴평가) — int
- menuName (메뉴명) — varchar(100)
- menuImageURL (음식 사진) — varchar(255)
- ingredients (재료) — varchar(255)
- userId (사용자PK) — int — Foreign key → User.id — NOT NULL
Refrigerator (냉장고)
- refrigeratorId (냉장고Id) — int — Primary key — NOT NULL
- menu (메뉴)
- user_id (사용자PK) — int — Foreign key → User.id — NOT NULL
User (사용자)
- id (사용자PK) — int — Primary key — NOT NULL
- nickname (사용자이름) — varchar(100)
- keyCode (로그인식별키) — varchar(100)
- profile_image (프로필사진) — varchar(200)
- thumbnail_image (배경화면사진) — varchar(200)