yumyum
Tables (5)
diet_log (diet)
- id — bigint — Primary key — NOT NULL
- calories — int
- carbohydrate — float
- fat — float
- image_url — varchar(255)
- meal_type — varchar(255)
- protein — float
- record_time — date
- user_id — bigint
diet_log_item (Untitled)
- id — bigint — Primary key — NOT NULL
- diet_log_id — bigint
- food_code — varchar(255)
- quantity — float
point
- id — bigint — NOT NULL
- daily_point — int
- points_earned — int
- record_date — date
- user_id — bigint
target
- id — bigint — Primary key — NOT NULL
- calories — float
- carbohydrate — float
- fat — float
- protein — float
- user_id — bigint
users
- id — bigint — Primary key — NOT NULL
- birthdate — date
- current_point — int
- email — varchar(255)
- gender — varchar(255)
- height — float
- password — varchar(255)
- username — varchar(255)
- weight — float