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