Procedures

From PlcWiki

write_eventshow

write_eventshow (
 in_place VARCHAR(6),
 in_project VARCHAR(6),
 in_WPID CHAR(2),
 in_WUID VARCHAR(36),
 in_event_time DATETIME,
 in_product_config_uuid VARCHAR(36),
 in_seqNum INT(10) UNSIGNED,
 in_worker_card_no VARCHAR(30),
 in_worker_pers_no VARCHAR(30),
 in_worker_name VARCHAR(250),
 in_authorized_worker_card_no, VARCHAR(30)
 in_authorized_worker_pers_no VARCHAR(30),
 in_authorized_worker_name VARCHAR(250),
 in_ansi_screen BLOB,
 in_event_source VARCHAR(255),
 in_screen_log BLOB,
 in_operations_state TEXT,
 in_info_log BLOB
)

write_operation_result

write_operation_result (
 in_place VARCHAR(6),
 in_project VARCHAR(6),
 in_WPID CHAR(2),
 in_WUID VARCHAR(36),
 in_event_time DATETIME,
 in_product_config_uuid VARCHAR(36),
 in_seqNum INT(10) UNSIGNED,
 in_worker_id VARCHAR(30),
 in_worker_name VARCHAR(250),
 in_product_id VARCHAR(20),
 in_op_done_time DATETIME,
 in_opid VARCHAR(32),
 in_rsid INT(11) UNSIGNED,
 in_op_slot SMALLINT UNSIGNED,
 in_result TINYINT UNSIGNED,
 in_attempt SMALLINT UNSIGNED,
 in_req_count SMALLINT UNSIGNED,
 in_op_data TEXT,
 in_op_attribute VARCHAR(45),
 in_op_attribute_comment VARCHAR(45)
)

write_tightening_result

write_tightening_result (
 in_place VARCHAR(6),
 in_project VARCHAR(6),
 in_WPID CHAR(2),
 in_WUID VARCHAR(36),
 in_event_time DATETIME,
 in_product_config_uuid VARCHAR(36),
 in_seqNum INT(10) UNSIGNED,
 in_worker_id VARCHAR(30),
 in_worker_name VARCHAR(250),
 in_product_id VARCHAR(20),
 in_op_done_time DATETIME,
 in_opid VARCHAR(32),
 in_rsid INT(11) UNSIGNED,
 in_op_slot SMALLINT UNSIGNED,
 in_result TINYINT UNSIGNED,
 in_attempt SMALLINT UNSIGNED,
 in_req_count SMALLINT UNSIGNED,
 in_op_data TEXT,
 in_op_attribute VARCHAR(45),
 in_op_attribute_comment VARCHAR(45)
 XXXXX tightening parameters
)