DIVISON

테이블 (14)

audit_logs(시스템 로그) (audit_logs)

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users(유저).id
  • action — VARCHAR(50) — NOT NULL
  • target_table — VARCHAR(100) — NOT NULL
  • target_id — BIGINT
  • before_data — JSON
  • after_data — JSON
  • ip_address — VARCHAR(45)
  • created_at — DATETIME — NOT NULL

cross_check_results(순회검사 결과) (cross_check_results)

  • id — BIGINT — 기본 키 — NOT NULL
  • cross_check_id — BIGINT — 외래 키 → cross_checks(순회검사).id — NOT NULL
  • dim_id — BIGINT — 외래 키 → product_dims(제품 치수).id — NOT NULL
  • quality_measured_value — DECIMAL(10, 3)
  • quality_judgment — ENUM('OK', 'NG', 'PENDING') — NOT NULL
  • quality_image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cross_checks(순회검사) (cross_checks)

  • id — BIGINT — 기본 키 — NOT NULL
  • inspection_id — BIGINT — 외래 키 → inspections(자주검사).id — NOT NULL
  • quality_user_id — BIGINT — 외래 키 → users(유저).id — NOT NULL
  • status — ENUM('DRAFT', 'QUALITY_DONE') — NOT NULL
  • cross_completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

customers(고객사) (customers)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

equipments(설비) (equipments)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • process — ENUM('INOUT', 'AL_CUTTING', 'ST_CUTTING', 'PROCESSING') — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

incomplete_reasons(테이블 삭제 필요) (incomplete_reasons)

  • id — BIGINT — 기본 키 — NOT NULL
  • inspection_id — BIGINT — 외래 키 → inspections(자주검사).id — NOT NULL
  • submitted_by — BIGINT — 외래 키 → users(유저).id — NOT NULL
  • approved_by — BIGINT — 외래 키 → users(유저).id
  • reason — TEXT — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED') — NOT NULL
  • admin_comment — TEXT — EX
  • submitted_at — DATETIME — NOT NULL
  • approved_at — DATETIME

inspection_orders(검사 등록) (inspection_orders)

  • id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → products(제품).id — NOT NULL
  • equipment_id — BIGINT — 외래 키 → equipments(설비).id — NOT NULL
  • created_by — BIGINT — 외래 키 → users(유저).id — NOT NULL
  • target_date — DATE — NOT NULL
  • memo — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inspection_results(자주검사 결과) (inspection_results)

  • id — BIGINT — 기본 키 — NOT NULL
  • inspection_id — BIGINT — 외래 키 → inspections(자주검사).id — NOT NULL
  • dim_id — BIGINT — 외래 키 → product_dims(제품 치수).id — NOT NULL
  • worker_measured_value — DECIMAL(10, 3)
  • worker_judgment — ENUM('OK', 'NG', 'PENDING') — NOT NULL
  • worker_image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inspections(자주검사) (inspections)

  • id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → inspection_orders(검사 등록).id — NOT NULL
  • worker_id — BIGINT — 외래 키 → users(유저).id — NOT NULL
  • type — ENUM('DAY_1','DAY_2','DAY_3','DAY_4','DAY_5', 'NIGHT_1','NIGHT_2','NIGHT_3','NIGHT_4','NIGHT_5') — NOT NULL
  • inspection_time — TIME — NOT NULL
  • status — ENUM('DRAFT','WORKER_DONE','QUALITY_DONE','INCOMPLETE') — NOT NULL
  • self_completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications(알림) (notifications)

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users(유저).id — NOT NULL
  • type — ENUM('APPROVAL_REQUESTED','REPORT_PUBLISHED','INSPECTION_COMPLETED', 'CROSS_CHECK_APPROVED','INCOMPLETE_SUBMITTED', 'INCOMPLETE_APPROVED','INCOMPLETE_REJECTED','SYSTEM') — NOT NULL
  • icon — ENUM('WARNING', 'SUCCESS', 'INFO') — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • message — TEXT — NOT NULL
  • target_id — BIGINT
  • target_type — VARCHAR(50)
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

product_dims(제품 치수) (product_dims)

  • id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → products(제품).id — NOT NULL
  • dim_no — INT — NOT NULL
  • dim_name — VARCHAR(100) — NOT NULL
  • standard_value — DECIMAL(10, 3) — NOT NULL
  • tolerance_plus — DECIMAL(10, 3) — NOT NULL
  • tolerance_minus — DECIMAL(10, 3) — NOT NULL
  • pos_x — DECIMAL(5, 4)
  • pos_y — DECIMAL(5, 4)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

products(제품) (products)

  • id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customers(고객사).id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • process — ENUM('INOUT', 'AL_CUTTING', 'ST_CUTTING', 'PROCESSING') — NOT NULL
  • sketch_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reports(보고서) (reports)

  • id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → inspection_orders(검사 등록).id — NOT NULL
  • published_by — BIGINT — 외래 키 → users(유저).id
  • report_no — VARCHAR(60) — NOT NULL
  • status — ENUM('DRAFT', 'PUBLISHED') — NOT NULL
  • notes — TEXT
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users(유저) (users)

  • id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('WORKER', 'QUALITY', 'QUALITY_ADMIN', 'SUPER_ADMIN') — NOT NULL
  • department — ENUM('PRODUCTION', 'QUALITY') — NOT NULL
  • process — ENUM('INOUT', 'AL_CUTTING', 'ST_CUTTING', 'PROCESSING') — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'PENDING') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL