ver5
Tables (8)
app_user
- id — INT
- login_id — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- job_title — VARCHAR(100)
- role — ENUM('admin', 'engineer', 'sales') — NOT NULL
- status — ENUM('active', 'inactive')
- created_at — DATETIME
- updated_at — DATETIME
as_request
- id — INT
- fk_product_id — INT — Foreign key → product.id — NOT NULL — product 테이블 참조
- fk_handler_user_id — INT — Foreign key → app_user.id — app_user 테이블 참조 (처리 담당자)
- issue_summary — VARCHAR(500) — NOT NULL
- memo — TEXT
- status — ENUM('received', 'in_progress', 'completed')
- received_at — DATE
- resolved_at — DATE
- created_at — DATETIME
- updated_at — DATETIME
customer
- id — INT
- customer_code — VARCHAR(50) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- customer_name — VARCHAR(150) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
part
- id — INT
- part_code — VARCHAR(100)
- part_full_name — VARCHAR(150) — NOT NULL
- category — ENUM('cpu', 'ram', 'ssd', 'hdd', 'gpu', 'nic', 'raid', 'platform', 'cable', 'riser', 'npu', 'other') — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
product
- id — INT
- document_no — VARCHAR(100) — NOT NULL
- revision_id — INT — NOT NULL
- is_latest — CHAR(1) — NOT NULL
- product_full_name — VARCHAR(150) — NOT NULL
- inventory_stock_qty — INT — NOT NULL
- status — ENUM('pending', 'completed', 'failed')
- fk_customer_id — INT — Foreign key → customer.id
- fk_site_id — INT — Foreign key → site.id — site 테이블 참조
- fk_sales_user_id — INT — Foreign key → app_user.id
- fk_assemble_user_id — INT — Foreign key → app_user.id
- fk_qc_user_id — INT — Foreign key → app_user.id
- fk_modifier_user_id — INT — Foreign key → app_user.id
- created_at — DATETIME
product_part
- id — INT
- fk_product_id — INT — Foreign key → product.id — NOT NULL
- fk_part_id — INT — Foreign key → part.id — NOT NULL
- required_qty — INT — NOT NULL
- part_name_snapshot — VARCHAR(150) — NOT NULL
- category_snapshot — VARCHAR(50) — NOT NULL
- created_at — DATETIME
product_part_serial
- id — INT
- fk_product_part_id — INT — Foreign key → product_part.id — NOT NULL
- company_asset_tag — VARCHAR(100)
- slot_position — VARCHAR(50)
- hardware_serial_no — VARCHAR(150)
- os_logical_device_name — VARCHAR(255)
- notes — TEXT
- created_at — DATETIME
site
- id — INT
- fk_customer_id — INT — Foreign key → customer.id — NOT NULL — customer 테이블 참조
- site_name — VARCHAR(150) — NOT NULL
- region — VARCHAR(100)
- address — VARCHAR(300)
- memo — TEXT
- created_at — DATETIME
- updated_at — DATETIME