CREATE TABLE R_QUANTITY_TYPE
(

RANGE_LOWER	FLOAT (6)	,
RANGE_UOM	CHAR VARYING (15)	REFERENCES R_UOM (ACRONYM),
RANGE_UPPER	FLOAT (6)	,
R_QUANTITY_TYPE_NM	CHAR VARYING (40)	NOT NULL,
R_QUANTITY_TYPE_S	CHAR VARYING (19)	NOT NULL PRIMARY KEY,
SOURCE	CHAR VARYING (40)	NOT NULL REFERENCES R_SOURCE (R_SOURCE_NAME),
SOURCE_REFERENCE_S	CHAR VARYING (19)	REFERENCES R_SOURCE_REF (R_SOURCE_REF_S),
STATUS	CHAR VARYING (11)	,
VERSION	CHAR VARYING (40)	REFERENCES R_EPCNT_VERSION (NAME)

)
ALTER TABLE R_QUANTITY_TYPE ADD (CONSTRAINT UNIQUE (r_quantity_type_nm))