CREATE TABLE custom_production_jobs (
  id VARCHAR(80) PRIMARY KEY,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  shop VARCHAR(255),
  product_id BIGINT,
  variant_id BIGINT,
  product_title VARCHAR(255),
  method_key VARCHAR(64),
  method_label VARCHAR(120),
  wood_primary_key VARCHAR(64),
  wood_primary_label VARCHAR(120),
  use_combo_wood BOOLEAN DEFAULT FALSE,
  wood_secondary_key VARCHAR(64),
  wood_secondary_label VARCHAR(120),
  combo_style VARCHAR(64),
  finish_key VARCHAR(64),
  finish_label VARCHAR(120),
  width_in DECIMAL(10,2),
  height_in DECIMAL(10,2),
  thickness_in DECIMAL(10,2),
  board_feet_est DECIMAL(10,2),
  sqft_est DECIMAL(10,2),
  material_type VARCHAR(32),
  text_mode VARCHAR(32),
  line_count INT,
  text_lines TEXT,
  font_name VARCHAR(255),
  upload_original_url TEXT,
  upload_preview_url TEXT,
  notes TEXT,
  pricing_json JSON,
  proof_status VARCHAR(64) DEFAULT 'Review Needed',
  production_status VARCHAR(64) DEFAULT 'New'
);
