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 (변경일)