--SO 20012728

--------------------------------TABLE PRODUCT--------------------------


ALTER TABLE PRODUCT
	ADD (NOOFWASHESNOCHECKPOINT NUMBER);

COMMENT ON COLUMN PRODUCT.NOOFWASHESNOCHECKPOINT IS 'This attribute is used to define the maximum number of washes where it is not needed yet to inspect the unique item so it may bypass the checkpoint. When this number is exceeded, the item needs to be inspected. Used in combination with an automatic sorting system. ';


--------------------------------TABLE PRODUCTLISTPERCUSTOMER--------------------------

ALTER TABLE PRODUCTLISTPERCUSTOMER
	ADD (NOOFWASHESNOCHECKPOINT NUMBER);

COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.NOOFWASHESNOCHECKPOINT IS 'This attribute is used to define the maximum number of washes where it is not needed yet to inspect the unique item so it may bypass the checkpoint. When this number is exceeded, the item needs to be inspected. Used in combination with an automatic sorting system';


