8team
Tables (7)
DAILY_NUTRIENT
- 성별 (gender) — VARCHAR
- 연령대 (age_group) — INT
- 열량 (kcal) — FLOAT(7,2)
- 탄수화물 (carbohydrate) — FLOAT(7,2)
- 단백질 (protein) — FLOAT(7,2)
- 지방 (fat) — FLOAT(7,2)
FEED
- FEEDID (feed_id) — INT — Primary key — NOT NULL
- UID (user_id) — INT — Foreign key → USER.UID — NOT NULL
- 이미지키 (image_url) — VARCHAR
- 식사시간 (meal_time) — VARCHAR
- 날짜 (date) — DATE
- 생성일자 (created_at) — DATE
- 수정일자 (updated_at) — DATE
- 공개여부 (open) — BOOL
- Field (thumbnail) — VARCHAR
FEED_FOODS
- FEEDID (feed_id) — INT — Foreign key → FEED.FEEDID — NOT NULL
- 이미지 (image_url) — VARCHAR
- 음식 (food_id) — INT
- 무게 (weight) — FLOAT(7,2)
FOOD_INFO
- FOODID (food_id) — INT — Primary key — NOT NULL
- 음식 (name) — VARCHAR
- 1인분 weight (weight) — FLOAT(7,2)
- 열량 (kcal) — FLOAT(7,2)
- 탄수화물 (carbohydrate) — FLOAT(7,2)
- 단백질 (protein) — FLOAT(7,2)
- 지방 (fat) — FLOAT(7,2)
LIKES
- UID (user_id) — INT — Foreign key → USER.UID — NOT NULL
- FEEDID (feed_id) — INT — Foreign key → FEED.FEEDID — NOT NULL
USER
- UID (user_id) — INT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR — NOT NULL
- 암호화된비번 (password) — VARCHAR — NOT NULL
- 성별 (gender) — VARCHAR — NOT NULL
- 연령대 (age_group) — INT — NOT NULL
- 닉네임 (nickname) — VARCHAR — NOT NULL
- 생성일자 (created_at) — DATE — NOT NULL
- 수정일자 (updated_at) — DATE
- 삭제여부 (is_deleted) — BOOL
- 목표 (goal) — VARCHAR
USER_DAILY_NUTRIENT
- UID (user_id) — INT — Foreign key → USER.UID — NOT NULL
- 열량 (kcal) — FLOAT(7,2)
- 탄수화물 (carbohydrate) — FLOAT(7,2)
- 단백질 (protein) — FLOAT(7,2)
- 지방 (fat) — FLOAT(7,2)