USE hazard_db;

CREATE TABLE IF NOT EXISTS tingkat_cedera (
  id INT AUTO_INCREMENT PRIMARY KEY,
  level INT NOT NULL,
  kategori VARCHAR(50) NOT NULL,
  deskripsi_cedera TEXT NOT NULL,
  batas_kerugian_min DECIMAL(15,2) DEFAULT 0,
  batas_kerugian_max DECIMAL(15,2) DEFAULT NULL,
  keterangan_kerugian VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB;