5_8
Tables (4)
machine (기계 관리)
- machine_id — varchar(50) — Primary key — NOT NULL
- medi_id — varchar(50) — Foreign key → medicine.medi_id — NOT NULL
- error_status (에러 상태 관리) — varchar(50)
- last_error_at (마지막 에러 발생 시각) — datetime — NOT NULL
- owenr (소유자(메인유저)) — varchar(50) — Foreign key → user.user_id — NOT NULL
medicine (약)
- medi_id — varchar(50) — Primary key — NOT NULL
- name (약품 이름) — varchar(100) — NOT NULL
- total (총량) — int — NOT NULL
- output (배출량) — int — NOT NULL
- remaining (잔여량) — int
- warning (경고) — tinyint(1)
- slot (배치슬롯) — tinyint(1) — NOT NULL
schedule (스케쥴)
- schedule_id — varchar(50) — Primary key — NOT NULL
- user_id — varchar(50) — Foreign key → user.user_id
- medi_id — varchar(50) — Foreign key → medicine.medi_id
- day_of_week (주간 스케쥴) — enum('mon','tue','wed','thu','fri','sat','sun') — NOT NULL
- time_of_day (일간 스케쥴) — enum('morning','noon','evening') — NOT NULL
- dose (복용량) — int — NOT NULL
user (유저)
- user_id — varchar(50) — Primary key — NOT NULL
- uid (RFID고유번호) — varchar(50) — NOT NULL
- name (이름) — varchar(100) — NOT NULL
- role (그룹 역할) — enum('main','sub') — NOT NULL
- main_user_id (inner조인용) — varchar(50) — Foreign key → user.user_id