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