risk_assessments table columns:
Array
(
[0] => Array
(
[Field] => id_assessment
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
[1] => Array
(
[Field] => assessment_type
[Type] => enum('GRA','MS')
[Null] => NO
[Key] => MUL
[Default] => GRA
[Extra] =>
)
[2] => Array
(
[Field] => assessment_id
[Type] => varchar(50)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[3] => Array
(
[Field] => title
[Type] => varchar(255)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[4] => Array
(
[Field] => location
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[5] => Array
(
[Field] => objective
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[6] => Array
(
[Field] => assessed_by
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[7] => Array
(
[Field] => assessment_date
[Type] => date
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[8] => Array
(
[Field] => next_review_date
[Type] => date
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[9] => Array
(
[Field] => last_review_date
[Type] => date
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[10] => Array
(
[Field] => status
[Type] => enum('Draft','Completed','Under Review','Approved','Overdue')
[Null] => YES
[Key] => MUL
[Default] => Draft
[Extra] =>
)
[11] => Array
(
[Field] => hazard_count
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[12] => Array
(
[Field] => document_count
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[13] => Array
(
[Field] => created_by
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[14] => Array
(
[Field] => created_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)
[15] => Array
(
[Field] => updated_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] => on update current_timestamp()
)
)
coshh_products table columns:
Array
(
[0] => Array
(
[Field] => id_product
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
[1] => Array
(
[Field] => coshh_id
[Type] => varchar(20)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[2] => Array
(
[Field] => product_name
[Type] => varchar(255)
[Null] => NO
[Key] => MUL
[Default] =>
[Extra] =>
)
[3] => Array
(
[Field] => hazard_classification
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[4] => Array
(
[Field] => substance_description
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[5] => Array
(
[Field] => toxic_ingredients_json
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[6] => Array
(
[Field] => signal_word
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[7] => Array
(
[Field] => hazard_statements
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[8] => Array
(
[Field] => precautionary_statements
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[9] => Array
(
[Field] => supplemental_label_info
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[10] => Array
(
[Field] => first_aid_eyes
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[11] => Array
(
[Field] => first_aid_skin
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[12] => Array
(
[Field] => first_aid_inhalation
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[13] => Array
(
[Field] => first_aid_ingestion
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[14] => Array
(
[Field] => storage_procedures
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[15] => Array
(
[Field] => control_measures
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[16] => Array
(
[Field] => control_measure_icons
[Type] => varchar(500)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[17] => Array
(
[Field] => description_of_use
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[18] => Array
(
[Field] => quantities_used
[Type] => varchar(500)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[19] => Array
(
[Field] => assessment_of_risk
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[20] => Array
(
[Field] => spillage_procedures
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[21] => Array
(
[Field] => storage_location
[Type] => varchar(100)
[Null] => NO
[Key] => MUL
[Default] =>
[Extra] =>
)
[22] => Array
(
[Field] => supplier_name
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[23] => Array
(
[Field] => status
[Type] => enum('Active','Removed','Archived')
[Null] => YES
[Key] => MUL
[Default] => Active
[Extra] =>
)
[24] => Array
(
[Field] => notes
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[25] => Array
(
[Field] => last_reviewed
[Type] => date
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[26] => Array
(
[Field] => created_by
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[27] => Array
(
[Field] => created_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)
[28] => Array
(
[Field] => updated_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] => on update current_timestamp()
)
[29] => Array
(
[Field] => assessment_date
[Type] => date
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[30] => Array
(
[Field] => assessment_by
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[31] => Array
(
[Field] => last_reviewed_date
[Type] => date
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[32] => Array
(
[Field] => last_reviewed_by
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[33] => Array
(
[Field] => hazards_description
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[34] => Array
(
[Field] => fire_fighting_measures
[Type] => longtext
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
)