CNC Mill Tool Wear
Variational CNC machining data
@kaggle.shasun_tool_wear_detection_in_cnc_mill
Variational CNC machining data
@kaggle.shasun_tool_wear_detection_in_cnc_mill
A series of machining experiments were run on 2" x 2" x 1.5" wax blocks in a CNC milling machine in the System-level Manufacturing and Automation Research Testbed (SMART) at the University of Michigan. Machining data was collected from a CNC machine for variations of tool condition, feed rate, and clamping pressure. Each experiment produced a finished wax part with an "S" shape - S for smart manufacturing - carved into the top face, as shown in test_artifact.jpg (included in the dataset).
General data from each of the 18 different experiments are given in train.csv and includes the experiment number, material (wax), feed rate, and clamp pressure. Outputs per experiment include tool condition (unworn and worn tools) and whether or not the tool passed visual inspection.
Time series data was collected from the 18 experiments with a sampling rate of 100 ms and are separately reported in files experiment_01.csv to experiment_18.csv. Each file has measurements from the 4 motors in the CNC (X, Y, Z axes and spindle). These CNC measurements can be used in two ways:
Note that some variables will not accurately reflect the operation of the CNC machine. This can usually be detected by when M1_CURRENT_FEEDRATE reads 50, when X1 ActualPosition reads 198, or when M1_CURRENT_PROGRAM_NUMBER does not read 0. The source of these errors has not been identified.
This data was extracted using the Rockwell Cloud Collector Agent Elastic software from a CNC milling machine in the System-level Manufacturing and Automation Research Testbed (SMART) at the University of Michigan.
The dataset can be used in classification studies such as:
(1) Tool wear detection --- Supervised binary classification could be performed for identification of worn and unworn cutting tools. Eight experiments were run with an unworn tool while ten were run with a worn tool (see tool_condition column for indication).
(2) Detection of inadequate clamping --- The data could be used to detect when a workpiece is not being held in the vise with sufficient pressure to pass visual inspection (see passed_visual_inspection column for indication of visual flaws). Experiments were run with pressures of 2.5, 3.0, and 4.0 bar. The data could also be used for detecting when conditions are critical enough to prevent the machining operation from completing (see machining_completed column for indication of when machining was preemptively stopped due to safety concerns).
CREATE TABLE experiment_01 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_02 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_03 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_04 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_05 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_06 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_07 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_08 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_09 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_10 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_11 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_12 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_13 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_14 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_15 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_16 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_17 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE experiment_18 (
"x1_actualposition" DOUBLE,
"x1_actualvelocity" DOUBLE,
"x1_actualacceleration" DOUBLE,
"x1_commandposition" DOUBLE,
"x1_commandvelocity" DOUBLE,
"x1_commandacceleration" DOUBLE,
"x1_currentfeedback" DOUBLE,
"x1_dcbusvoltage" DOUBLE,
"x1_outputcurrent" DOUBLE,
"x1_outputvoltage" DOUBLE,
"x1_outputpower" DOUBLE,
"y1_actualposition" DOUBLE,
"y1_actualvelocity" DOUBLE,
"y1_actualacceleration" DOUBLE,
"y1_commandposition" DOUBLE,
"y1_commandvelocity" DOUBLE,
"y1_commandacceleration" DOUBLE,
"y1_currentfeedback" DOUBLE,
"y1_dcbusvoltage" DOUBLE,
"y1_outputcurrent" DOUBLE,
"y1_outputvoltage" DOUBLE,
"y1_outputpower" DOUBLE,
"z1_actualposition" DOUBLE,
"z1_actualvelocity" DOUBLE,
"z1_actualacceleration" DOUBLE,
"z1_commandposition" DOUBLE,
"z1_commandvelocity" DOUBLE,
"z1_commandacceleration" DOUBLE,
"z1_currentfeedback" DOUBLE,
"z1_dcbusvoltage" DOUBLE,
"z1_outputcurrent" DOUBLE,
"z1_outputvoltage" DOUBLE,
"s1_actualposition" DOUBLE,
"s1_actualvelocity" DOUBLE,
"s1_actualacceleration" DOUBLE,
"s1_commandposition" DOUBLE,
"s1_commandvelocity" DOUBLE,
"s1_commandacceleration" DOUBLE,
"s1_currentfeedback" DOUBLE,
"s1_dcbusvoltage" DOUBLE,
"s1_outputcurrent" DOUBLE,
"s1_outputvoltage" DOUBLE,
"s1_outputpower" DOUBLE,
"s1_systeminertia" DOUBLE,
"m1_current_program_number" DOUBLE,
"m1_sequence_number" DOUBLE,
"m1_current_feedrate" DOUBLE,
"machining_process" VARCHAR
);CREATE TABLE train (
"no" BIGINT,
"material" VARCHAR,
"feedrate" BIGINT,
"clamp_pressure" DOUBLE,
"tool_condition" VARCHAR,
"machining_finalized" VARCHAR,
"passed_visual_inspection" VARCHAR
);Anyone who has the link will be able to view this.