What are some best practices for designing a table structure to store weight-based shipping cost data?

When designing a table structure to store weight-based shipping cost data, it is important to consider the various factors that can affect shipping costs, such as weight ranges, shipping zones, and pricing tiers. One common approach is to create a table with columns for weight range start and end points, shipping zone, and cost. This allows for efficient querying and updating of shipping costs based on weight and destination.

CREATE TABLE shipping_costs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    weight_start DECIMAL(10,2),
    weight_end DECIMAL(10,2),
    shipping_zone VARCHAR(50),
    cost DECIMAL(10,2)
);