 CREATE TABLE pack_content (
 	pack_concept_id int4 NOT NULL,
 	drug_concept_id int4 NOT NULL,
-	amount FLOAT,
+	amount int2,
 	box_size int4
 );
 

CREATE TABLE drug_strength (
	drug_concept_id int4 NOT NULL,
	ingredient_concept_id int4 NOT NULL,
	amount_value FLOAT,
	amount_unit_concept_id int4,
	numerator_value FLOAT,
	numerator_unit_concept_id int4,
	denominator_value FLOAT,
	denominator_unit_concept_id int4,
	box_size int4,
	valid_start_date DATE NOT NULL,

	vocabulary_id_1 VARCHAR (20) NOT NULL,
	ingredient_concept_code VARCHAR (20) NOT NULL,
	vocabulary_id_2 VARCHAR (20) NOT NULL,
	amount_value NUMERIC,
	amount_unit_concept_id int4,
	numerator_value NUMERIC,
	numerator_unit_concept_id int4,
	denominator_value NUMERIC,
	denominator_unit_concept_id int4,
	valid_start_date DATE NOT NULL,
	valid_end_date DATE NOT NULL,
