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