tdb_erd
Tables (4)
machine_medicine (기계)
- machine_id — varchar(50) — Primary key — NOT NULL
- medi_id — varchar(50) — Foreign key → medicine.medi_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)
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 (1회 복용량) — 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 — varchar(50) — Foreign key → user.user_id