Machine failure check model

Tables (3)

Failure history (Untitled3)

  • Failure history ID — int — NOT NULL
  • Failure type — char(9) — NOT NULL
  • Failure date — int — NOT NULL
  • Failure period — int — NOT NULL

Machine (Untitled)

  • machine ID — int — NOT NULL
  • machine type — char(9) — NOT NULL — machine type's name length can't more than 9.
  • machine name — char(9) — NOT NULL
  • manufacturer — char(9) — NOT NULL

sensor (Untitled2)

  • sensor ID — int — NOT NULL
  • sensor type — char(9) — NOT NULL
  • measurement date — int — NOT NULL
  • measurement value — int — NOT NULL