Skip to content
Snippets Groups Projects

Added script to create data_units table

Merged Cecilia Nievas requested to merge feature/data_units_table into master
All threads resolved!
2 files
+ 38
5
Compare changes
  • Side-by-side
  • Inline
Files
2
+ 17
0
CREATE TABLE public.data_units
(
data_unit_id VARCHAR,
occupancy_case occupancycase,
aggregated_source_id SMALLINT,
exposure_entity CHAR(3),
buildings_total FLOAT,
dwellings_total FLOAT,
people_census FLOAT,
cost_total FLOAT,
PRIMARY KEY (data_unit_id, occupancy_case, aggregated_source_id)
);
ALTER TABLE public.data_units
OWNER TO postgres;
Loading