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