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