予算事業の支出先と契約です。1 行が 1 事業の 1 支出先の 1 契約です。金額の単位は円です。
CREATE TABLE review.expenditures ( review_year INTEGER, project_id VARCHAR, line_number INTEGER, block_number VARCHAR, block_name VARCHAR, block_supplier_count INTEGER, block_role VARCHAR, block_amount BIGINT, supplier_name VARCHAR, corporate_number VARCHAR, address VARCHAR, corporate_kind VARCHAR, other_suppliers BOOLEAN, supplier_amount BIGINT, contract_summary VARCHAR, amount BIGINT, contract_method VARCHAR, contract_method_detail VARCHAR, bidder_count INTEGER, winning_bid_rate DOUBLE, single_bid_reason VARCHAR, other_contracts BOOLEAN, source_sha256 VARCHAR );