"Field"    "Type"    "Null"    "Key"    "Default"    "Extra"
"obj_id"    "int(11) unsigned"    "NO"    "PRI"    NULL    ""
"property_id"    "int(11) unsigned"    "YES"    ""    NULL    ""
"building_id"    "int(11) unsigned"    "YES"    ""    NULL    ""
"itc_number"    "varchar(500)"    "YES"    ""    NULL    ""
"unit"    "varchar(500)"    "YES"    ""    NULL    ""
"operating_status"    "varchar(500)"    "YES"    ""    NULL    ""
"unit_count"    "int(11) unsigned"    "YES"    ""    NULL    ""
"year_of_construction"    "year(4)"    "YES"    ""    NULL    ""
"latest_maintenance"    "datetime"    "YES"    ""    NULL    ""
"unit_type"    "varchar(500)"    "YES"    ""    NULL    ""
"nominal_heating_load_in_kW"    "float unsigned"    "YES"    ""    NULL    ""
"exit_count_hot_water_distribution"    "int(11) unsigned"    "YES"    ""    NULL    ""
"nominal_heat_transfer_load_in_kW"    "float unsigned"    "YES"    ""    NULL    ""
"total_storage_volume_in_l"    "float unsigned"    "YES"    ""    NULL    ""
"pumps_count"    "varchar(500)"    "YES"    ""    NULL    ""
"pump_power_output_in_W"    "float"    "YES"    ""    NULL    ""
"circulation_available"    "char(1)"    "YES"    ""    NULL    ""
"heat_generator"    "varchar(100)"    "YES"    ""    NULL    ""
"central_or_decentral"    "varchar(50)"    "YES"    ""    NULL    ""
"supplied_area"    "varchar(50)"    "YES"    ""    NULL    ""
"hotwater_usage_type"    "varchar(50)"    "YES"    ""    NULL    ""
"hotwater_usage_starttime_weekday"    "text"    "YES"    ""    NULL    ""
"hotwater_usage_endtime_weekday"    "text"    "YES"    ""    NULL    ""
"hotwater_usage_starttime_weekend"    "text"    "YES"    ""    NULL    ""
"hotwater_usage_endtime_weekend"    "text"    "YES"    ""    NULL    ""
"pipe_length_total_in_m"    "float"    "YES"    ""    NULL    ""
"location"    "text"    "YES"    ""    NULL    ""
"notes"    "text"    "YES"    ""    NULL    ""
"last_edited"    "timestamp"    "NO"    ""    "CURRENT_TIMESTAMP"    "on update CURRENT_TIMESTAMP"