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