deaho

Tables (11)

daily_production_report (일일생산일보)

  • daily_production_report_id — BIGINT — Primary key — NOT NULL
  • active_efficiency — BIGINT
  • active_hours — BIGINT
  • additional_input_rate — BIGINT
  • admin_costs — BIGINT
  • available_direct_employees — BIGINT
  • available_direct_hours — BIGINT
  • available_employees — BIGINT
  • available_hours — BIGINT
  • available_indirect_employees — BIGINT
  • available_indirect_hours — BIGINT
  • available_support_employees — BIGINT
  • available_support_hours — BIGINT
  • defective_cost — BIGINT
  • defective_qty — BIGINT
  • depreciation_costs — BIGINT
  • direct_cost_total — BIGINT
  • direct_costs — BIGINT
  • direct_employees — BIGINT
  • direct_hourly_vacation_employees — BIGINT
  • direct_hourly_vacation_hours — BIGINT
  • direct_hours — BIGINT
  • direct_other_employees — BIGINT
  • direct_other_hours — BIGINT
  • direct_total_employees — BIGINT
  • direct_total_hours — BIGINT
  • direct_vacation_employees — BIGINT
  • direct_vacation_hours — BIGINT
  • downtime_prod_cost — BIGINT
  • downtime_prod_time — BIGINT
  • flux_op_rate — BIGINT
  • flux_op_time — BIGINT
  • idle_hours — BIGINT
  • in_house_prod_cost — BIGINT
  • indirect_costs — BIGINT
  • indirect_employees — BIGINT
  • indirect_hourly_vacation_employees — BIGINT
  • indirect_hourly_vacation_hours — BIGINT
  • indirect_hours — BIGINT
  • indirect_total_employees — BIGINT
  • indirect_total_hours — BIGINT
  • indirect_vacation_employees — BIGINT
  • indirect_vacation_hours — BIGINT
  • investment_cost — BIGINT
  • job_hours — BIGINT
  • labor_cost — BIGINT
  • labor_input_rate — BIGINT
  • labor_op_rate — BIGINT
  • load_hours — BIGINT
  • loss_rate — BIGINT
  • misc_costs — BIGINT
  • non_prod_hours — BIGINT
  • other_employees — BIGINT
  • outsource_proc_cost — BIGINT
  • overall_labor_efficiency — BIGINT
  • overtime_employees — BIGINT
  • overtime_hours — BIGINT
  • prod_cost — BIGINT
  • prod_estimate — BIGINT
  • prod_profit — BIGINT
  • … +22

labor_input_and_production_cost

  • labor_input_and_production_cost_id — BIGINT — Primary key — NOT NULL
  • active_efficiency — BIGINT
  • active_hours — BIGINT
  • additional_input_rate — BIGINT
  • available_hours — BIGINT
  • available_staff — BIGINT
  • est_total_cost — BIGINT
  • flux_op_rate — BIGINT
  • flux_op_time — BIGINT
  • flux_power_on_time — BIGINT
  • idle_hours — BIGINT
  • input_cost — BIGINT
  • input_rate — BIGINT
  • job_hours — BIGINT
  • load_hours — BIGINT
  • loss_defective_cost — BIGINT
  • loss_defective_quantity — BIGINT
  • loss_downtime_cost — BIGINT
  • loss_downtime_time — BIGINT
  • loss_rate — BIGINT
  • loss_rework_cost — BIGINT
  • loss_rework_time — BIGINT
  • material_ratio — BIGINT
  • non_prod_hours — BIGINT
  • op_rate — BIGINT
  • overall_efficiency — BIGINT
  • overtime_hours — BIGINT
  • overtime_staff — BIGINT
  • performance_profit — BIGINT
  • process_outsourced_cost — BIGINT
  • process_production_cost — BIGINT
  • process_sub_material_cost — BIGINT
  • process_total_material_cost — BIGINT
  • process_total_processing_cost — BIGINT
  • process_total_raw_material_cost — BIGINT
  • processing_ratio — BIGINT
  • profit_rate — BIGINT
  • rework_hours — BIGINT
  • solder_op_rate — BIGINT
  • solder_op_time — BIGINT
  • solder_power_op_time — BIGINT
  • standard_hours — BIGINT
  • total_loss_cost — BIGINT
  • total_loss_rate — BIGINT
  • total_production_cost — BIGINT
  • work_efficiency — BIGINT

long_term_unused_item_issue

  • long_term_unused_item_issue_id — BIGINT — Primary key — NOT NULL
  • application_contents — VARCHAR(255)
  • average_monthly_use_after — VARCHAR(255)
  • average_monthly_use_before — VARCHAR(255)
  • current_inventory — VARCHAR(255)
  • discarding — VARCHAR(255)
  • division_responsibility — VARCHAR(255)
  • invalid_content — VARCHAR(255)
  • justification — VARCHAR(255)
  • long_term_stock — VARCHAR(255)
  • occurrence_date — VARCHAR(255)
  • part_name — VARCHAR(255)
  • parts_code — VARCHAR(255)
  • reselling — VARCHAR(255)

loss_occurrence_status

  • loss_occurrence_status_id — BIGINT — Primary key — NOT NULL
  • loss_min — BIGINT
  • occurrence_date — DATETIME(6)
  • action_content — VARCHAR(255)
  • loss_cost — VARCHAR(255)
  • loss_dept1 — VARCHAR(255)
  • loss_dept1rate — VARCHAR(255)
  • loss_dept2 — VARCHAR(255)
  • loss_dept2rate — VARCHAR(255)
  • loss_dept3 — VARCHAR(255)
  • loss_dept3rate — VARCHAR(255)
  • loss_description — VARCHAR(255)
  • loss_notes — VARCHAR(255)
  • loss_people — VARCHAR(255)
  • loss_status — VARCHAR(255)
  • loss_type — VARCHAR(255)
  • lot_no — VARCHAR(255)
  • occurrence_dept — VARCHAR(255)
  • total_loss_min — VARCHAR(255)

material_process_inventory

  • material_process_inventory_id — BIGINT — Primary key — NOT NULL
  • process_name — TINYINT
  • insolvency_stock — BIGINT
  • inventory_waiting — BIGINT
  • long_stock — BIGINT
  • materials_storage — BIGINT
  • reselling — BIGINT
  • total — BIGINT
  • material_classification — VARCHAR(255)
  • note — VARCHAR(255)

process_inventory

  • process_inventory_id — BIGINT — Primary key — NOT NULL
  • inventory_completed_cost — BIGINT
  • inventory_completed_quantity — BIGINT
  • inventory_defective_cost — BIGINT
  • inventory_defective_quantity — BIGINT
  • inventory_model_number — BIGINT
  • inventory_product_name — BIGINT
  • inventory_progress_cost — BIGINT
  • inventory_progress_quantity — BIGINT
  • inventory_specs — BIGINT
  • inventory_total_cost — BIGINT
  • inventory_total_quantity — BIGINT
  • inventory_unit_material_cost — BIGINT
  • inventory_unit_processing_cost — BIGINT
  • inventory_unit_total — BIGINT
  • inventory_waiting_cost — BIGINT
  • inventory_waiting_quantity — BIGINT
  • inventoryid — BIGINT
  • process_inventory_name — BIGINT

production_performance

  • production_performance_id — BIGINT — Primary key — NOT NULL
  • process_name — TINYINT
  • completed_quantity — BIGINT
  • defective_quantity — BIGINT
  • estimated_cost_per_set — BIGINT
  • input_quantity — BIGINT
  • labor_hours_per_set — BIGINT
  • material_cost_per_set — BIGINT
  • monthly_production — BIGINT
  • performance_amount — BIGINT
  • planned_quantity — BIGINT
  • processing_cost_per_set — BIGINT
  • subtotal_cost_per_set — BIGINT
  • total_material_cost — BIGINT
  • total_processing_cost — BIGINT
  • total_production — BIGINT
  • work_in_progress_quantity — BIGINT
  • work_order_no — BIGINT
  • achievement_rate — VARCHAR(255)
  • defect_rate — VARCHAR(255)
  • model_standard — VARCHAR(255)
  • product_name — VARCHAR(255)
  • spec — VARCHAR(255)
  • unit — VARCHAR(255)

purchase_material_inventory

  • purchase_material_order_id — BIGINT — Primary key — NOT NULL
  • consigned_store_daily — BIGINT
  • consigned_store_monthly — BIGINT
  • consigned_store_plan — BIGINT
  • consigned_store_weekly — BIGINT
  • direct_store_daily — BIGINT
  • direct_store_monthly — BIGINT
  • direct_store_plan — BIGINT
  • direct_store_weekly — BIGINT
  • long_term_stock — BIGINT
  • purchase_material_order_ratio_daily — BIGINT
  • purchase_material_order_ratio_monthly — BIGINT
  • purchase_material_order_ratio_weekly — BIGINT
  • purchase_order_ratio_daily — BIGINT
  • purchase_order_ratio_monthly — BIGINT
  • purchase_order_ratio_weekly — BIGINT
  • total_store_daily — BIGINT
  • total_store_monthly — BIGINT
  • total_store_plan — BIGINT
  • total_store_weekly — BIGINT
  • unused_inventory — BIGINT
  • material_classification — VARCHAR(255)
  • purchase_issue_content — VARCHAR(255)

purchase_material_order

  • purchase_material_order_id — BIGINT — Primary key — NOT NULL
  • consigned_material_inventory — BIGINT
  • consigned_purchase_daily — BIGINT
  • consigned_purchase_monthly — BIGINT
  • consigned_purchase_weekly — BIGINT
  • direct_material_inventory — BIGINT
  • direct_purchase_daily — BIGINT
  • direct_purchase_monthly — BIGINT
  • direct_purchase_weekly — BIGINT
  • purchase_material_order_ratio_daily — BIGINT
  • purchase_material_order_ratio_monthly — BIGINT
  • purchase_material_order_ratio_weekly — BIGINT
  • purchase_order_ratio_daily — BIGINT
  • purchase_order_ratio_monthly — BIGINT
  • purchase_order_ratio_weekly — BIGINT
  • purchase_plan — BIGINT
  • sales_plan — BIGINT
  • total_material_inventory — BIGINT
  • total_purchase_daily — BIGINT
  • total_purchase_monthly — BIGINT
  • total_purchase_weekly — BIGINT
  • material_classification — VARCHAR(255)
  • purchase_issue_content — VARCHAR(255)

purchase_order_inventory_report

  • purchase_order_report_id — BIGINT — Primary key — NOT NULL
  • consigned_inventory — BIGINT
  • direct_inventory — BIGINT
  • total_material — BIGINT
  • material_classification — VARCHAR(255)
  • note — VARCHAR(255)
  • stocking_ratio — VARCHAR(255)

purchase_order_report

  • purchase_order_report_id — BIGINT — Primary key — NOT NULL
  • ordering_plan — BIGINT
  • purchase_plan — BIGINT
  • sales_plan — BIGINT
  • material_classification — VARCHAR(255)
  • material_cost — VARCHAR(255)
  • note — VARCHAR(255)