alter table parts add column payment_id integer;
alter table payment_terms add column ranking integer;