text: CREATE TABLE companies (
    company_name varchar (1000),
    okpo varchar (8) PRIMARY KEY,
    okopf varchar (5),
    okfs varchar (2),
    okved varchar (8),
    inn varchar (10)
  );
  
  CREATE TABLE reports (
    okpo varchar (8),
    code varchar (3),
    report_type varchar (1),
    c11103 bigint,
    c11104 bigint,
    c11203 bigint,
    c11204 bigint,
    c11303 bigint,
    c11304 bigint,
    c11403 bigint,
    c11404 bigint,
    c11503 bigint,
    c11504 bigint,
    c11603 bigint,
    c11604 bigint,
    c11703 bigint,
    c11704 bigint,
    c11803 bigint,
    c11804 bigint,
    c11903 bigint,
    c11904 bigint,
    c11003 bigint,
    c11004 bigint,
    c12103 bigint,
    c12104 bigint,
    c12203 bigint,
    c12204 bigint,
    c12303 bigint,
    c12304 bigint,
    c12403 bigint,
    c12404 bigint,
    c12503 bigint,
    c12504 bigint,
    c12603 bigint,
    c12604 bigint,
    c12003 bigint,
    c12004 bigint,
    c16003 bigint,
    c16004 bigint,
    c13103 bigint,
    c13104 bigint,
    c13203 bigint,
    c13204 bigint,
    c13403 bigint,
    c13404 bigint,
    c13503 bigint,
    c13504 bigint,
    c13603 bigint,
    c13604 bigint,
    c13703 bigint,
    c13704 bigint,
    c13003 bigint,
    c13004 bigint,
    c14103 bigint,
    c14104 bigint,
    c14203 bigint,
    c14204 bigint,
    c14303 bigint,
    c14304 bigint,
    c14503 bigint,
    c14504 bigint,
    c14003 bigint,
    c14004 bigint,
    c15103 bigint,
    c15104 bigint,
    c15203 bigint,
    c15204 bigint,
    c15303 bigint,
    c15304 bigint,
    c15403 bigint,
    c15404 bigint,
    c15503 bigint,
    c15504 bigint,
    c15003 bigint,
    c15004 bigint,
    c17003 bigint,
    c17004 bigint,
    c21103 bigint,
    c21104 bigint,
    c21203 bigint,
    c21204 bigint,
    c21003 bigint,
    c21004 bigint,
    c22103 bigint,
    c22104 bigint,
    c22203 bigint,
    c22204 bigint,
    c22003 bigint,
    c22004 bigint,
    c23103 bigint,
    c23104 bigint,
    c23203 bigint,
    c23204 bigint,
    c23303 bigint,
    c23304 bigint,
    c23403 bigint,
    c23404 bigint,
    c23503 bigint,
    c23504 bigint,
    c23003 bigint,
    c23004 bigint,
    c24103 bigint,
    c24104 bigint,
    c24213 bigint,
    c24214 bigint,
    c24303 bigint,
    c24304 bigint,
    c24503 bigint,
    c24504 bigint,
    c24603 bigint,
    c24604 bigint,
    c24003 bigint,
    c24004 bigint,
    c25103 bigint,
    c25104 bigint,
    c25203 bigint,
    c25204 bigint,
    c25003 bigint,
    c25004 bigint,
    c32003 bigint,
    c32004 bigint,
    c32005 bigint,
    c32006 bigint,
    c32007 bigint,
    c32008 bigint,
    c33103 bigint,
    c33104 bigint,
    c33105 bigint,
    c33106 bigint,
    c33107 bigint,
    c33108 bigint,
    c33117 bigint,
    c33118 bigint,
    c33125 bigint,
    c33127 bigint,
    c33128 bigint,
    c33135 bigint,
    c33137 bigint,
    c33138 bigint,
    c33143 bigint,
    c33144 bigint,
    c33145 bigint,
    c33148 bigint,
    c33153 bigint,
    c33154 bigint,
    c33155 bigint,
    c33157 bigint,
    c33163 bigint,
    c33164 bigint,
    c33165 bigint,
    c33166 bigint,
    c33167 bigint,
    c33168 bigint,
    c33203 bigint,
    c33204 bigint,
    c33205 bigint,
    c33206 bigint,
    c33207 bigint,
    c33208 bigint,
    c33217 bigint,
    c33218 bigint,
    c33225 bigint,
    c33227 bigint,
    c33228 bigint,
    c33235 bigint,
    c33237 bigint,
    c33238 bigint,
    c33243 bigint,
    c33244 bigint,
    c33245 bigint,
    c33247 bigint,
    c33248 bigint,
    c33253 bigint,
    c33254 bigint,
    c33255 bigint,
    c33257 bigint,
    c33258 bigint,
    c33263 bigint,
    c33264 bigint,
    c33265 bigint,
    c33266 bigint,
    c33267 bigint,
    c33268 bigint,
    c33277 bigint,
    c33278 bigint,
    c33305 bigint,
    c33306 bigint,
    c33307 bigint,
    c33406 bigint,
    c33407 bigint,
    c33003 bigint,
    c33004 bigint,
    c33005 bigint,
    c33006 bigint,
    c33007 bigint,
    c33008 bigint,
    c36003 bigint,
    c36004 bigint,
    c41103 bigint,
    c41113 bigint,
    c41123 bigint,
    c41133 bigint,
    c41193 bigint,
    c41203 bigint,
    c41213 bigint,
    c41223 bigint,
    c41233 bigint,
    c41243 bigint,
    c41293 bigint,
    c41003 bigint,
    c42103 bigint,
    c42113 bigint,
    c42123 bigint,
    c42133 bigint,
    c42143 bigint,
    c42193 bigint,
    c42203 bigint,
    c42213 bigint,
    c42223 bigint,
    c42233 bigint,
    c42243 bigint,
    c42293 bigint,
    c42003 bigint,
    c43103 bigint,
    c43113 bigint,
    c43123 bigint,
    c43133 bigint,
    c43143 bigint,
    c43193 bigint,
    c43203 bigint,
    c43213 bigint,
    c43223 bigint,
    c43233 bigint,
    c43293 bigint,
    c43003 bigint,
    c44003 bigint,
    c44903 bigint,
    c61003 bigint,
    c62103 bigint,
    c62153 bigint,
    c62203 bigint,
    c62303 bigint,
    c62403 bigint,
    c62503 bigint,
    c62003 bigint,
    c63103 bigint,
    c63113 bigint,
    c63123 bigint,
    c63133 bigint,
    c63203 bigint,
    c63213 bigint,
    c63223 bigint,
    c63233 bigint,
    c63243 bigint,
    c63253 bigint,
    c63263 bigint,
    c63303 bigint,
    c63503 bigint,
    c63003 bigint,
    c64003 bigint,
    updated varchar (10)
  );
  
  ALTER TABLE reports ADD FOREIGN KEY (okpo) REFERENCES companies (okpo);
  
  CREATE INDEX ON companies USING gin(to_tsvector('russian', company_name));
  
  CREATE INDEX reports_okpo_idx ON reports (okpo);
  
  CREATE INDEX companies_inn_idx ON companies (inn);
  
  -- set default_text_search_config = russian;