-- Add comments to the columns 
comment on column I_PRICELIST.PRICELISTTYPE
  is '1 = Wash
2 = Rent
3 = Replacement
4 = Sales
5 = Weight
6 = Repair
7 = Emblem
8 = Emblem Template
9 = Garment Insurance';
-- Create/Recreate check constraints 
alter table I_PRICELIST
  drop constraint PRICETYPE_VALIDATION1;
alter table I_PRICELIST
  add constraint PRICETYPE_VALIDATION1
  check (PRICELISTTYPE BETWEEN 1 AND 9);
-- Add comments to the columns 
comment on column I_PRICELISTPERCUSTOMER.PRICELISTTYPE
  is '1 = Wash
2 = Rent
3 = Replacement
4 = Sales
5 = Weight
6 = Repair
7 = Emblem
8 = Emblem Template
9 = Garment Insurance';
-- Create/Recreate check constraints 
alter table I_PRICELISTPERCUSTOMER
  drop constraint PRICETYPE_VALIDATION2;
alter table I_PRICELISTPERCUSTOMER
  add constraint PRICETYPE_VALIDATION2
  check (PRICELISTTYPE BETWEEN 1 AND 9);
