Bitte die Types von LAT,LON und den verschiedenen Costs in create_statements_db.sql von INTEGER auf DECIMAL ändern.

[HaSzyBS]

Patients:

• LAT und LON in decimal(6,2)
• Healthcare_expenses und healthcared_coverage in decimal(9,2) Medications:
• Base_cost, Payer_coverage, Dispenses, Totalcost in decimal(9,2) Procedures: Base_Cost in decimal(9,2) Immunizations: Base_Cost in decimal(9,2) Encounters:
• Base_Encounter_Cost in decimal(9,2)
• Total_Claim_Cost in decimal(9,2)
• Payer_coverage_Cost in decimal(9,2) Facts_Table: Patient_LAT und Patient_LON in decimal(6,2) Patient_healthcare_expenses in decimal(6,2) Patient_healthcare_coverage in decimal(6,2) Procedures_base_cost in decimal(6,2) Medications_totalcost in decimal(6,2) Immunizations_base_cost in decimal(6,2) encounter_base_encounter_cost in decimal(6,2)

[moanesga]

done