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