Public Sector Balance Sheet (PSBS)

CREATE TABLE codes_cl_country (
  "code" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE codes_cl_freq (
  "code" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE codes_cl_sector (
  "code" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE codes_cl_unit (
  "code" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE indicators (
  "indicator" VARCHAR,
  "series_name" VARCHAR,
  "unit" VARCHAR,
  "transformation" VARCHAR,
  "http_www_w3_org_2001_xmlschema_instance_type" VARCHAR,
  "instr_asset" VARCHAR,
  "gfs_sto" VARCHAR,
  "fsentry" VARCHAR,
  "accounting_entry" VARCHAR,
  "counterparty_sector" VARCHAR,
  "mfs_coltn" VARCHAR,
  "currency" VARCHAR,
  "mfs_instrl" VARCHAR,
  "int_ttc" VARCHAR,
  "fi_maturity" VARCHAR,
  "mfs_ra" VARCHAR,
  "na_sto" VARCHAR
);

CREATE TABLE observations (
  "country" VARCHAR,
  "sector" VARCHAR,
  "indicator" VARCHAR,
  "unit" VARCHAR,
  "frequency" VARCHAR,
  "time_period" BIGINT,
  "value" DOUBLE
);