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