tdb
Tables (5)
dose_history
- history_id — varchar(50) — Primary key — NOT NULL
- connect — varchar(50) — NOT NULL
- user_id — varchar(50) — NOT NULL
- medi_id — varchar(50) — NOT NULL
- time_of_day — enum('morning','afternoon','evening') — NOT NULL
- dose_date — date — NOT NULL
- scheduled_dose — int — NOT NULL
- actual_dose — int — NOT NULL
- status — enum('completed','missed','partial') — NOT NULL
- completed_at — datetime
- notes — text
machine
- machine_id — varchar(50) — Primary key — NOT NULL
- medi_id — varchar(50) — Primary key — NOT NULL
- owner — varchar(50) — NOT NULL
- error_status — varchar(50)
- last_error_at — datetime — NOT NULL
- total — int — NOT NULL
- remain — int — NOT NULL
- slot — tinyint
- max_slot — tinyint — NOT NULL
medicine
- medi_id — varchar(50) — Primary key — NOT NULL
- connect — varchar(50) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- warning — tinyint(1) — NOT NULL
- start_date — date
- end_date — date
- target_users — json — 복용 대상 "user1","user2" 또는 NULL(전체)
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL
schedule
- schedule_id — varchar(50) — Primary key — NOT NULL
- connect — varchar(50) — NOT NULL
- user_id — varchar(50)
- medi_id — varchar(50)
- day_of_week — enum('mon','tue','wed','thu','fri','sat','sun') — NOT NULL
- time_of_day — enum('morning','afternoon','evening')
- dose — int — NOT NULL
- created_at — datetime — NOT NULL
- user_id (user_id2) — varchar(50) — Foreign key → users.user_id — NOT NULL
users
- user_id — varchar(50) — Primary key — NOT NULL
- m_uid — varchar(50)
- connect — varchar(50)
- password — varchar(255)
- name — varchar(100)
- role — enum('parent','child')
- took_today — tinyint — NOT NULL
- age — int
- k_uid — varchar(50)
- birthDate — varchar(20)
- refresh_token — text