I need help migrating an old table

i have this big table that has columns:
partnumber, 1piece-price-break, 10K-piece-price-break, 25k, etc…

i want to split this into two tables:
part_number, id


price_break, price, product_id

so that, you know, the price-break columns are not stuck at fixed
values; different parts can have differnt numbers of price-breaks, etc

is there a ruby way to do this?
i have navicat, but i can’t think of a way to keep everything straight
with it.