SmartSafeOps

Tables (4)

Employee

  • employeeId — int — Primary key — NOT NULL
  • name — String
  • team — String
  • line — String
  • e_status — String

History

  • historyId (Key) — int — Primary key — NOT NULL
  • reportId — int — Foreign key → Report.reportId — NOT NULL
  • employeeId — int — Foreign key → Report.employeeId — NOT NULL
  • action — String
  • createdAt — datetime

Log

  • logId — int — Primary key — NOT NULL
  • reportId — int — Foreign key → Report.reportId — NOT NULL
  • employeeId — int — Foreign key → Report.employeeId — NOT NULL
  • level — String
  • createdAt — datetime
  • message — String

Report

  • reportId — int — Primary key — NOT NULL
  • employeeId — int — Foreign key → Employee.employeeId — NOT NULL
  • line — String
  • equipementId — int
  • type — String
  • memo — String
  • imageUrl — String
  • status — String
  • createdAt — datetime