BackStudy_personal

Tables (6)

Follow

  • followI (followId) — integer — Primary key — NOT NULL
  • userId — integer — Foreign key → User.userId — NOT NULL

MealHistory

  • mealId — integer — Primary key — NOT NULL
  • userId — integer — Foreign key → User.userId — NOT NULL
  • mealFood — varchar(100)
  • time — Datetime

Regrigerator (Refrigerator)

  • refrigeratorId — integer — Primary key — NOT NULL
  • ingredient — varchar(100)
  • userId — integer — Foreign key → User.userId — NOT NULL

Restaurant

  • restaurantId — integer — Primary key — NOT NULL
  • userId — integer — Foreign key → User.userId — NOT NULL
  • restaurantName — varchar(100)
  • restaurantPlace — varchar(100)

User

  • userId — integer — Primary key — NOT NULL
  • userName — varchar(100)
  • password — varchar(100)
  • userNickname — varchar(100)
  • userImageUrl — Blob

Weather

  • weatherId — integer — Primary key — NOT NULL
  • weatherMenu — varchar(100)
  • refrigeratorId — integer — Foreign key → Regrigerator.refrigeratorId — NOT NULL