GREENFIT_ERD
Tables (13)
BloodPressure Record (혈압기록)
- user_id (사용자 id) — Primary key — NOT NULL
- bp_id (혈압기록 id) — Primary key — NOT NULL
- diastolic_bp (이완기혈압)
- systolic_bp (수축기 혈압)
- body_pulse (맥박)
- record_time (측정시간)
- created_at (생성일)
- updated_at (변경일)
CODE (code)
- MOOD_VERY_GOOD (기분째짐)
- MOOD_GOOD (좋음)
- MOOD_SAD (우울/슬픔)
- MOOD_MAD (화남)
- MOOD_RELAX (편안함)
- MOOD_SICK (아픔)
- MOOD_EXHAUST (지침)
- DAYS_EVERYDAY (매일)
- DAYS_MON (월요일)
- DAYS_TUE (화요일)
- DAYS_WED (수요일)
- DAYS_THR (목요일)
- DAYS_FRI (금요일)
- DAYS_SAT (토요일)
- DAYS_SUN (일요일)
- INTAKE_BEFORE_MEAL (식전)
- INTAKE_BETWEEN_MEAL (식간)
- INTAKE_AFTER_MEAL (식후)
- INTAKE_BREAKFAST (아침)
- INTAKE_LUNCH (점심)
- INTAKE_DINNER (저녁)
- INTAKE_AMOUNT_UNIT_1 (g)
- INTAKE_AMOUNT_UNIT_2 (mg)
- INTAKE_AMOUNT_UNIT_3 (정)
Execise Record (운동기록)
- user_id (사용자 id) — Primary key — NOT NULL
- execise_id (운동기록 id) — Primary key — NOT NULL
- exercise_time (운동시간)
- exercise_type (운동종류 코드)
- exercise (운동설명)
- exercise_intencity (운동강도코드)
- record_time (측정(기록)시간)
- created_at (생성일)
- updated_at (변경일)
Feces Record (대변기록)
- user_id (사용자 id) — Primary key — NOT NULL
- feces_id (대변기록 id) — Primary key — NOT NULL
- feces_shape (대변 모양)
- feces_color (대변 색깔)
- feces_smell (대변 냄새)
- feces_feel (대변 느낌)
- record_time (측정(기록)시간)
- created_at (생성일)
- updated_at (변경일)
Meal Record (식단기록)
- user_id (사용자 id) — Primary key — NOT NULL
- meal_id (식단기록 id) — Primary key — NOT NULL
- meal_type (끼니 타입)
- food_name (음식 이름)
- food_calorie (음식 열량)
- food_amount (음식 양)
- carbo (탄수화물)
- fat (지방)
- protain (단백질)
- record_time (측정(기록)시간)
- created_at (생성일)
- updated_at (변경일)
Medication Prescription (처방전 이미지)
- Key — Primary key — NOT NULL
- Field
Medication Record (복용약 루틴 기록)
- user_id (사용자 uid) — Primary key — NOT NULL
- medication_id (복용약 루틴 기록 id) — Primary key — NOT NULL
- medication_intake_push_alert_id (푸시알림 uid) — Primary key — NOT NULL
- medication_name (약이름)
- medication_nickname (약 별명)
- medication_period (약 섭취 기간)
- medication_frequency (약 섭취 휫수)
- medication_intake_time (약 섭취 시간)
- medication_intake_days (약 섭취 요일)
- medication_intake_indue (섭취 언제)
- medication_intake_amount (섭취 양)
- medication_intake_push_alert_yn (푸시알림여부)
- medication_intake_yn (복용여부)
- medication_expired (복용기간만료)
- medication_image_url (약 이미지 url)
- medication_prescription (약 처방전 이미지 url)
- updated_at (변경일)
- created_at (생성일)
Mood Record (기분기록)
- user_id (사용자 uid) — Primary key — NOT NULL
- mood_id (기분기록 id) — Primary key — NOT NULL
- mood_code (기분코드)
- mood_code_name (기분코드이름)
- mood_record (기분상세기록)
- created_at (생성일)
- updated_at (변경일)
Push Alert (푸시알림)
- user_id (사용자 uid) — Primary key — NOT NULL
- push_id (푸시알림id) — Primary key — NOT NULL
- alert_time (푸시알림 시간)
- alert_message (푸시알림 메세지)
- alert_yn (푸시알림여부)
- created_at (생성일)
Urine Record (소변기록)
- user_id (사용자 id) — Primary key — NOT NULL
- urine_id (소변기록 id) — Primary key — NOT NULL
- urine_color (소변 색깔)
- urine_amount (소변 양)
- urine_smell (소변 냄새)
- urine_feel (소변 느낌)
- record_time (측정(기록)시간)
- created_at (생성일)
- updated_at (변경일)
User (사용자)
- user_id — Primary key — NOT NULL
- name (이름)
- gender (성별)
- phone_number (휴대폰번호)
- email (이메일)
- password (비밀번호)
- term_agree_yn (이용약관동의)
- created_at (생성일)
- updated_at (변경일)
Water Record (수분기록)
- user_id (사용자 id) — Primary key — NOT NULL
- water_id (수분기록 id) — Primary key — NOT NULL
- goal_water (하루목표섭취양)
- water_amount (섭취양)
- water_type (섭취종류)
- record_time (섭취시간)
- created_at (생성일)
- updated_at (변경일)
Weight Record (체중기록)
- user_id (사용자 id) — Primary key — NOT NULL
- weight_id (체중기록 id) — Primary key — NOT NULL
- goal_weight (목표체중)
- weight (기록한 체중)
- skeletal_musle_mess (골격근량)
- body_fat (체지방률)
- record_time (측정시간)
- created_at (생성일)
- updated_at (변경일)