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