ddd

Tables (11)

BPS

  • bps_id — INT
  • blasting_type — VARCHAR(50)
  • grit_type — VARCHAR(100)
  • surface_cleanliness — VARCHAR(50)
  • equipment_spec — VARCHAR(255)
  • temperature — FLOAT
  • humidity — FLOAT
  • inspection_procedures — TEXT
  • created_at — DATETIME

BlockInformation

  • block_id — INT — Primary key
  • block_name — VARCHAR(100) — NOT NULL
  • dimensions — VARCHAR(100)
  • weight — FLOAT
  • cad_file_path — VARCHAR(255)
  • created_at — DATETIME

CADAttributes

  • cad_id — INT — Primary key
  • block_id — INT
  • attribute_name — VARCHAR(100)
  • attribute_value — VARCHAR(100)
  • created_at — DATETIME

CPS

  • cps_id — INT
  • coating_system — VARCHAR(255)
  • coating_material — VARCHAR(100)
  • application_method — VARCHAR(100)
  • temperature — FLOAT
  • humidity — FLOAT
  • drying_time — VARCHAR(100)
  • inspection_procedures — TEXT
  • created_at — DATETIME

ProductionPlan

  • plan_id — INT — Primary key
  • block_id — INT — Foreign key → BlockInformation.block_id
  • work_type — VARCHAR(50) — NOT NULL
  • bps_id — INT
  • cps_id — INT
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(50)

QualityInspection

  • inspection_id — INT
  • block_id — INT
  • inspection_type — VARCHAR(50)
  • inspection_result — VARCHAR(50)
  • inspection_data — TEXT
  • video_analysis — TEXT
  • created_at — DATETIME

RealTimeMonitoring

  • monitoring_id — INT
  • robot_id — INT
  • block_id — INT
  • status — VARCHAR(50)
  • current_task — VARCHAR(100)
  • timestamp — DATETIME

RobotInformation

  • robot_id — INT
  • robot_name — VARCHAR(100)
  • model — VARCHAR(100)
  • status — VARCHAR(50)

WorkExecutionResults

  • result_id — INT
  • block_id — INT
  • robot_id — INT
  • work_type — VARCHAR(50)
  • bps_id — INT
  • cps_id — INT
  • execution_status — VARCHAR(50)
  • start_time — DATETIME
  • end_time — DATETIME
  • feedback — TEXT

WorkPath

  • path_id — INT
  • block_id — INT
  • path_coordinates — TEXT
  • scan_type — VARCHAR(50)
  • created_at — DATETIME

WorkSchedule

  • schedule_id — INT — Primary key
  • plan_id — INT — Foreign key → ProductionPlan.plan_id
  • schedule_date — DATE
  • shift — VARCHAR(50)
  • status — VARCHAR(50)