CREATE TABLE CastingMaterials (
    id INT PRIMARY KEY AUTO_INCREMENT UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT(CURRENT_TIMESTAMP),
    last_modified TIMESTAMP NOT NULL DEFAULT(CURRENT_TIMESTAMP) ON UPDATE CURRENT_TIMESTAMP,

    name VARCHAR(255) UNIQUE NOT NULL,
    slug VARCHAR(255) UNIQUE NOT NULL,

    cost_per_unit FLOAT NOT NULL,
    unit_of_measurement VARCHAR(50) NOT NULL,

    manufacturer VARCHAR(255) NOT NULL

);