smartFactory
Tables (5)
Factory
- id — INT — Primary key — NOT NULL
- factory_name — VARCHAR(100)
Training
- id — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → Factory.id — NOT NULL
- training_name — VARCHAR(100) — NOT NULL
TrainingLog
- id — INT — Primary key — NOT NULL
- training_id (traiining_id) — INT — Foreign key → Training.id — NOT NULL
- log — VARCHAR(100) — NOT NULL
- log_time — DATETIME — NOT NULL
UserTraining
- id — INT — Primary key
- user_id — INT — Foreign key → Users.id — NOT NULL
- training_id — INT — Foreign key → Training.id — NOT NULL
- value — INT
- timestamp — DATETIME — NOT NULL
- completion — BOOLEAN — NOT NULL
- duration — NOT NULL
Users
- id — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → Factory.id — NOT NULL
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL