Earthquake Magnitude, Damage And Impact

CREATE TABLE n__building_structure (
  "building_id" BIGINT,
  "district_id" BIGINT,
  "vdcmun_id" BIGINT,
  "ward_id" BIGINT,
  "count_floors_pre_eq" BIGINT,
  "count_floors_post_eq" BIGINT,
  "age_building" BIGINT,
  "plinth_area_sq_ft" BIGINT,
  "height_ft_pre_eq" BIGINT,
  "height_ft_post_eq" BIGINT,
  "land_surface_condition" VARCHAR,
  "foundation_type" VARCHAR,
  "roof_type" VARCHAR,
  "ground_floor_type" VARCHAR,
  "other_floor_type" VARCHAR,
  "position" VARCHAR,
  "plan_configuration" VARCHAR,
  "has_superstructure_adobe_mud" BIGINT,
  "has_superstructure_mud_mortar_stone" BIGINT,
  "has_superstructure_stone_flag" BIGINT,
  "has_superstructure_cement_mortar_stone" BIGINT,
  "has_superstructure_mud_mortar_brick" BIGINT,
  "has_superstructure_cement_mortar_brick" BIGINT,
  "has_superstructure_timber" BIGINT,
  "has_superstructure_bamboo" BIGINT,
  "has_superstructure_rc_non_engineered" BIGINT,
  "has_superstructure_rc_engineered" BIGINT,
  "has_superstructure_other" BIGINT,
  "condition_post_eq" VARCHAR,
  "damage_grade" VARCHAR,
  "technical_solution_proposed" VARCHAR
);