--order 502567

ALTER TABLE WEARERINVENTORY ADD ( SELECTFLAGRETURN NUMBER NULL
					CONSTRAINT SelectFlagReturn_Valid 
						CHECK (SELECTFLAGRETURN IN (1,2,3,4,5)) );

COMMENT ON COLUMN WEARERINVENTORY.SELECTFLAGRETURN IS '1 = First scanned
2 = Oldest
3 = Newest
4 = Most washed
5 = Least washed';