404-스마트 팩토리
테이블 (6)
attendance
- id — bigint — 기본 키 — NOT NULL
- check_in — time
- check_out — time
- status — varchar(255)
- work_date — date
- employee_id — bigint — 외래 키 → employee.id
- daily_wage — int
- working_minutes — int
camera_result
- id — int — 기본 키 — NOT NULL
- car_id — int — 외래 키 → car.id — NOT NULL
- result — varchar(20) — NOT NULL
- created_at — datetime
car
- id — int — 기본 키 — NOT NULL
- created_at — datetime
defect_images
- id — int — 기본 키 — NOT NULL
- camera_result_id — int — 외래 키 → camera_result.id — NOT NULL
- image_path — varchar(255) — NOT NULL
- created_at — datetime
- car_id — int — 외래 키 → car.id — NOT NULL
employee
- id — bigint — 기본 키 — NOT NULL
- employee_number — varchar(8) — NOT NULL
- name — varchar(100) — NOT NULL
- department — varchar(50) — NOT NULL
- position — varchar(50) — NOT NULL
- phone — varchar(20)
- password_hash — varchar(255)
- created_at — datetime
- updated_at — datetime
- monthly_salary — int — NOT NULL
- hourly_rate — int — NOT NULL
- annual_leave — float
- sick_leave — int
sensor_result
- id — int — 기본 키 — NOT NULL
- car_id — int — 외래 키 → car.id — NOT NULL
- device — varchar(50) — NOT NULL
- result — varchar(10) — NOT NULL
- created_at — datetime