erd
Tables (6)
Untitled (diet)
- Key (diet_id) — bigint — Primary key — NOT NULL
- Field (image) — varchar — NOT NULL
- Field (mealtime) — varchar(16) — NOT NULL
- Field (low_fodmap_count) — int
- Field (high_fodmap_count) — int
- Field (created_date) — timestamp — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (member)
- Key (member_id) — bigint — Primary key — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (sex) — varchar(16) — NOT NULL
- Field (birthyear) — date — NOT NULL
- Field (kakao_id) — bigint — NOT NULL
Untitled (defecation)
- Key (defecation_id) — bigint — Primary key — NOT NULL
- Field (form) — varchar(16) — NOT NULL
- Field (urgency) — int — NOT NULL
- Field (color) — varchar(16) — NOT NULL
- Field (satisfaction) — int — NOT NULL
- Field (duration) — int — NOT NULL
- Field (score) — int
- Field (created_date) — timestamp — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (meal)
- Key (meal_id) — bigint — Primary key — NOT NULL
- Field (meal_name) — varchar — NOT NULL
- Field (is_low_fodmap) — tinyint — NOT NULL
- Field (fructose) — float — NOT NULL
- Field (sucrose) — float — NOT NULL
- Field (lactose) — float — NOT NULL
- Field (maltose) — float — NOT NULL
- Field (fiber) — float — NOT NULL
Untitled (diet_meal)
- Key (diet_meal_id) — bigint — Primary key — NOT NULL
- Key (diet_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (meal_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (stress)
- Key (stress_id) — bigint — Primary key — NOT NULL
- Field (degree) — int — NOT NULL
- Field (created_date) — timestamp — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL