awer

Tables (20)

analysis_results

  • id — INT
  • poop_image_id — INT
  • content — TEXT

breastfeeding_records

  • record_id — INT
  • left_time — INT
  • right_time — INT
  • type — ENUM('left', 'right') — NOT NULL

care_records

  • id — INT
  • type — ENUM('poop', 'pee', 'formula', 'solid_food', 'breastfeeding', 'pumping', 'pumped_feeding', 'hospital_visit', 'medication', 'other', 'sleep', 'temperature', 'water', 'milk', 'snack') — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • memo — TEXT
  • memo_image_url — TEXT
  • child_id — INT

children

  • id — INT
  • name — VARCHAR(255)
  • sex — INT
  • birthday — DATETIME
  • default_diaper_weight — INT

formula_records

  • record_id — INT
  • time — INT
  • quantity — INT

hospital_visit_records

  • record_id — INT
  • visit_type — BOOLEAN
  • hospital_name — VARCHAR(255)
  • doctor_name — VARCHAR(255)
  • diagnosis — TEXT

medication_records

  • record_id — INT
  • medication_name — VARCHAR(255)
  • medication_color — INT

members

  • id — INT
  • provider — ENUM('kakao', 'naver', 'google', 'apple') — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL

milk_records

  • record_id — INT
  • quantity — INT

other_records

  • record_id — INT
  • item — VARCHAR(255)
  • duration — INT

pee_records

  • record_id — INT
  • quantity — INT

poop_records

  • record_id — INT
  • color — INT
  • weight — INT

profiles

  • id — INT
  • username — VARCHAR(255)
  • role — ENUM('admin', 'user') — NOT NULL
  • child_id — INT

pumped_feeding_records

  • record_id — INT
  • duration — INT
  • quantity — INT

pumping_records

  • record_id — INT
  • left_time — INT
  • right_time — INT
  • place_type — ENUM('home', 'work', 'other') — NOT NULL
  • left_quantity — INT
  • right_quantity — INT
  • total_quantity — BOOLEAN

sleep_records

  • record_id — INT
  • is_afternoon — BOOLEAN

snack_records

  • record_id — INT
  • snack_name — VARCHAR(255)
  • quantity — INT

solid_food_records

  • record_id — INT
  • type — VARCHAR(255)

temperature_records

  • record_id — INT
  • temperature — FLOAT

water_records

  • record_id — INT
  • quantity — INT