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)