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)