FridgeApp

Tables (5)

comments (Untitled4)

  • comment_id (Key) — Primary key — NOT NULL
  • recipe_id (Field)
  • user_no (Field2)
  • contentc (Field3)
  • Field4

fridge_items (Untitled2)

  • item_no (Key) — Primary key — NOT NULL
  • user_no (Field)
  • item_name (Field2)
  • quantity (Field3)
  • expiry_date (Field4)
  • category (Field5)
  • added_date (Field6)

recipe_likes (Untitled5)

  • like_id (Key) — Primary key — NOT NULL
  • recipe_id (Field)
  • uesr_no (Field2)
  • Field3

recipies (Untitled3)

  • recipe_id (Key) — Primary key — NOT NULL
  • user_o (Field)
  • title (Field2)
  • content (Field3)
  • image_file (Field4)
  • cooking_time (Field5)
  • difficulty (Field6)
  • serving (Field7)
  • category (Field8)
  • hits (Field9)
  • likes (Field10)
  • Field11

users (Untitled)

  • user_no (Key) — Primary key — NOT NULL
  • user_id (Field)
  • password (Field2)
  • nickname (Field3)
  • email (Field4)
  • profile_image (Field5)
  • role (Field6)
  • bio (Field7)
  • created_at (Field8)