地方整備局・北海道開発局が発注した建設工事と建設コンサルタント業務等の入札結果です。1 行が 1 つの案件に入札した 1 業者で、予定価格・調査基準価格・技術点と、1〜3 回目の入札額・評価値、落札したかどうかを持ちます。同じ案件の行は bid_id が同じです。
CREATE TABLE bid.bid_result ( bid_id VARCHAR, bureau VARCHAR, kind VARCHAR, office VARCHAR, project_name VARCHAR, location VARCHAR, bid_date DATE, contract_date DATE, period VARCHAR, category VARCHAR, method VARCHAR, overall_evaluation BOOLEAN, bidder_name VARCHAR, bidder_address VARCHAR, corporate_number VARCHAR, planned_price BIGINT, minimum_price BIGINT, technical_score DOUBLE, round1_amount BIGINT, round1_price_score DOUBLE, round1_score DOUBLE, round1_status VARCHAR, round2_amount BIGINT, round2_price_score DOUBLE, round2_score DOUBLE, round2_status VARCHAR, round3_amount BIGINT, round3_price_score DOUBLE, round3_score DOUBLE, round3_status VARCHAR, estimate_amount BIGINT, is_winner BOOLEAN, note VARCHAR, source_url VARCHAR, source_sha256 VARCHAR );