TDB2
Tables (8)
dose_history
- history_id — VARCHAR(50) — Primary key
- group_id — VARCHAR(50)
- user_id — VARCHAR(50)
- medi_id — VARCHAR(50)
- 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 — NOT NULL
- notes — TEXT
machine
- machine_id — VARCHAR(50)
- group_id — VARCHAR(50)
- max_slot — TINYINT — NOT NULL
- error_status — VARCHAR(50)
- last_error_at — DATETIME
machine_slot
- machine_id — VARCHAR(50)
- slot_number — TINYINT
- medi_id — VARCHAR(50)
- total — INT — NOT NULL
- remain — INT — NOT NULL
medicine
- medi_id — VARCHAR(50)
- group_id — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- warning — TINYINT — NOT NULL
- start_date — DATE
- end_date — DATE
- target_users — TEXT
- listed_only — BOOLEAN — NOT NULL
schedule
- schedule_id — VARCHAR(50)
- group_id — VARCHAR(50)
- 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') — NOT NULL
- dose — INT — NOT NULL
- created_at — DATETIME
user_group
- group_id — VARCHAR(50)
- group_name — VARCHAR(100)
- parent_user_id — VARCHAR(50)
- created_at — DATETIME
- note — TEXT
user_group_membership
- group_id — VARCHAR(50)
- user_id — VARCHAR(50)
- role — ENUM('parent', 'child') — NOT NULL
- joined_at — DATETIME
users
- user_id — VARCHAR(50)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- age — INT
- birthDate — DATE
- k_uid — VARCHAR(45)
- took_today — INT — NOT NULL
- refresh_token — VARCHAR(255)