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