CREATE SCHEMA information_schema;
CREATE SCHEMA pg_catalog;
CREATE SCHEMA public;



CREATE TABLE allo_applications(anchor_address VARCHAR, chain_id BIGINT, created_at_block VARCHAR, created_by_address VARCHAR, id VARCHAR, metadata VARCHAR, metadata_signature VARCHAR, metadata_application_recipient VARCHAR, metadata_cid VARCHAR, node_id VARCHAR, project_id VARCHAR, round_id VARCHAR, status VARCHAR, status_snapshots STRUCT(status VARCHAR, updatedAt VARCHAR, updatedAtBlock VARCHAR)[], status_updated_at_block VARCHAR, tags VARCHAR[], total_amount_donated_in_usd DOUBLE, total_donations_count BIGINT, unique_donors_count BIGINT);
CREATE TABLE allo_deployments(address VARCHAR, chain_name VARCHAR, contract VARCHAR);
CREATE TABLE allo_donations(amount_in_usd DOUBLE, amount VARCHAR, amount_in_round_match_token VARCHAR, application_id VARCHAR, block_number VARCHAR, chain_id BIGINT, id VARCHAR, donor_address VARCHAR, node_id VARCHAR, project_id VARCHAR, recipient_address VARCHAR, round_id VARCHAR, token_address VARCHAR, transaction_hash VARCHAR);
CREATE TABLE allo_prices(block_number VARCHAR, chain_id BIGINT, id BIGINT, node_id VARCHAR, price_in_usd DOUBLE, "timestamp" VARCHAR, token_address VARCHAR);
CREATE TABLE allo_projects(anchor_address VARCHAR, chain_id BIGINT, created_at_block VARCHAR, created_by_address VARCHAR, id VARCHAR, metadata VARCHAR, title VARCHAR, description VARCHAR, website VARCHAR, project_twitter VARCHAR, project_github VARCHAR, user_github VARCHAR, logo_image VARCHAR, banner_image VARCHAR, created_at DECIMAL(18,3), metadata_cid VARCHAR, "name" VARCHAR, node_id VARCHAR, nonce VARCHAR, project_number BIGINT, project_type VARCHAR, registry_address VARCHAR, tags VARCHAR[], updated_at_block VARCHAR);
CREATE TABLE allo_rounds(admin_role VARCHAR, application_metadata VARCHAR, application_metadata_cid VARCHAR, applications_end_time VARCHAR, applications_start_time VARCHAR, chain_id BIGINT, created_at_block VARCHAR, created_by_address VARCHAR, donations_end_time VARCHAR, donations_start_time VARCHAR, id VARCHAR, manager_role VARCHAR, match_amount VARCHAR, match_amount_in_usd DOUBLE, match_token_address VARCHAR, node_id VARCHAR, project_id VARCHAR, round_metadata VARCHAR, round_metadata_cid VARCHAR, round_metadata_name VARCHAR, round_metadata_round_type VARCHAR, round_metadata_program_address VARCHAR, round_metadata_sybil_defense VARCHAR, strategy_address VARCHAR, strategy_id VARCHAR, strategy_name VARCHAR, tags VARCHAR, total_amount_donated_in_usd DOUBLE, total_donations_count BIGINT, unique_donors_count BIGINT, updated_at_block VARCHAR);
CREATE TABLE allo_subscriptions(chain_id BIGINT, contract_address VARCHAR, contract_name VARCHAR, created_at VARCHAR, from_block VARCHAR, id VARCHAR, indexed_to_block VARCHAR, indexed_to_log_index BIGINT, node_id VARCHAR, to_block VARCHAR, updated_at VARCHAR);
CREATE TABLE application_answers(question_id VARCHAR, project_id VARCHAR, application_id VARCHAR, chain_id BIGINT, round_id VARCHAR, question VARCHAR, question_type VARCHAR, answer VARCHAR);
CREATE TABLE chain_metadata("name" VARCHAR, short_name VARCHAR, info_url VARCHAR, chain_id VARCHAR, network_id BIGINT, native_currency STRUCT("name" VARCHAR, symbol VARCHAR, decimals INTEGER), ens STRUCT(registry VARCHAR), explorers MAP(VARCHAR, VARCHAR)[], rpc VARCHAR[], parent VARCHAR);
CREATE TABLE gitcoin_passport_scores(id BIGINT, address VARCHAR, community VARCHAR, score VARCHAR, last_score_timestamp VARCHAR, status VARCHAR, error VARCHAR, evidence_type VARCHAR, evidence_success VARCHAR, evidence_raw_score VARCHAR, evidence_threshold VARCHAR, stamp_scores JSON);
CREATE TABLE giveth_projects(title VARCHAR, total_donations DOUBLE, total_trace_donations DOUBLE);
CREATE TABLE karmahq_details(attester VARCHAR, recipient VARCHAR, is_offchain BOOLEAN, decoded_data_json VARCHAR);
CREATE TABLE public.raw_allo_applications(anchorAddress VARCHAR, chainId BIGINT, createdAtBlock VARCHAR, createdByAddress VARCHAR, id VARCHAR, metadata VARCHAR, metadataCid VARCHAR, nodeId VARCHAR, projectId VARCHAR, roundId VARCHAR, status VARCHAR, statusSnapshots STRUCT(status VARCHAR, updatedAt VARCHAR, updatedAtBlock VARCHAR)[], statusUpdatedAtBlock VARCHAR, tags VARCHAR[], totalAmountDonatedInUsd DOUBLE, totalDonationsCount BIGINT, uniqueDonorsCount BIGINT);
CREATE TABLE public.raw_allo_deployments(address VARCHAR, chain_name VARCHAR, contract VARCHAR);
CREATE TABLE public.raw_allo_donations(amountInUsd DOUBLE, amount VARCHAR, amountInRoundMatchToken VARCHAR, applicationId VARCHAR, blockNumber VARCHAR, chainId BIGINT, id VARCHAR, donorAddress VARCHAR, nodeId VARCHAR, projectId VARCHAR, recipientAddress VARCHAR, roundId VARCHAR, tokenAddress VARCHAR, transactionHash VARCHAR);
CREATE TABLE public.raw_allo_prices(blockNumber VARCHAR, chainId BIGINT, id BIGINT, nodeId VARCHAR, priceInUsd DOUBLE, "timestamp" VARCHAR, tokenAddress VARCHAR);
CREATE TABLE public.raw_allo_projects(anchorAddress VARCHAR, chainId BIGINT, createdAtBlock VARCHAR, createdByAddress VARCHAR, id VARCHAR, metadata VARCHAR, metadataCid VARCHAR, "name" VARCHAR, nodeId VARCHAR, nonce VARCHAR, projectNumber BIGINT, projectType VARCHAR, registryAddress VARCHAR, tags VARCHAR[], updatedAtBlock VARCHAR);
CREATE TABLE public.raw_allo_rounds(adminRole VARCHAR, applicationMetadata VARCHAR, applicationMetadataCid VARCHAR, applicationsEndTime VARCHAR, applicationsStartTime VARCHAR, chainId BIGINT, createdAtBlock VARCHAR, createdByAddress VARCHAR, donationsEndTime VARCHAR, donationsStartTime VARCHAR, fundedAmount VARCHAR, fundedAmountInUsd DOUBLE, id VARCHAR, managerRole VARCHAR, matchAmount VARCHAR, matchAmountInUsd DOUBLE, matchingDistribution VARCHAR, matchTokenAddress VARCHAR, nodeId VARCHAR, projectId VARCHAR, readyForPayoutTransaction VARCHAR, roundMetadata VARCHAR, roundMetadataCid VARCHAR, strategyAddress VARCHAR, strategyId VARCHAR, strategyName VARCHAR, tags VARCHAR, totalAmountDonatedInUsd DOUBLE, totalDonationsCount BIGINT, uniqueDonorsCount BIGINT, updatedAtBlock VARCHAR);
CREATE TABLE public.raw_allo_round_roles(address VARCHAR, chainId BIGINT, createdAtBlock VARCHAR, nodeId VARCHAR, "role" VARCHAR, roundId VARCHAR);
CREATE TABLE public.raw_allo_subscriptions(chainId BIGINT, contractAddress VARCHAR, contractName VARCHAR, createdAt VARCHAR, fromBlock VARCHAR, id VARCHAR, indexedToBlock VARCHAR, indexedToLogIndex BIGINT, nodeId VARCHAR, toBlock VARCHAR, updatedAt VARCHAR);
CREATE TABLE public.raw_chain_metadata("name" VARCHAR, "chain" VARCHAR, icon VARCHAR, rpc VARCHAR[], features STRUCT("name" VARCHAR)[], faucets VARCHAR[], nativeCurrency STRUCT("name" VARCHAR, symbol VARCHAR, decimals INTEGER), infoURL VARCHAR, shortName VARCHAR, chainId VARCHAR, networkId BIGINT, slip44 BIGINT, ens STRUCT(registry VARCHAR), explorers MAP(VARCHAR, VARCHAR)[], title VARCHAR, status VARCHAR, redFlags VARCHAR[], parent VARCHAR);
CREATE TABLE public.raw_discourse_categories(id BIGINT, "name" VARCHAR, color VARCHAR, text_color VARCHAR, slug VARCHAR, topic_count BIGINT, post_count BIGINT, "position" BIGINT, description VARCHAR, description_text VARCHAR, description_excerpt VARCHAR, topic_url VARCHAR, read_restricted BOOLEAN, permission INTEGER, notification_level BIGINT, topic_template VARCHAR, has_children BOOLEAN, sort_order VARCHAR, sort_ascending INTEGER, show_subcategory_list BOOLEAN, num_featured_topics BIGINT, default_view VARCHAR, subcategory_list_style VARCHAR, default_top_period VARCHAR, default_list_filter VARCHAR, minimum_required_tags BIGINT, navigate_to_first_post_after_read BOOLEAN, custom_fields MAP(VARCHAR, INTEGER), topics_day BIGINT, topics_week BIGINT, topics_month BIGINT, topics_year BIGINT, topics_all_time BIGINT, subcategory_ids INTEGER[], uploaded_logo INTEGER, uploaded_logo_dark INTEGER, uploaded_background INTEGER, uploaded_background_dark BIGINT, source VARCHAR, is_uncategorized BOOLEAN, subcategory_count BIGINT, topics VARCHAR);
CREATE TABLE public.raw_gitcoin_passport_scores(passport STRUCT(address VARCHAR, community BIGINT, requires_calculation BOOLEAN), score VARCHAR, last_score_timestamp VARCHAR, status VARCHAR, error VARCHAR, evidence STRUCT("type" VARCHAR, success BOOLEAN, rawScore VARCHAR, threshold VARCHAR), stamp_scores JSON, expiration_date VARCHAR, id BIGINT);
CREATE TABLE public.raw_giveth_projects(title VARCHAR, totalDonations DOUBLE, totalTraceDonations DOUBLE);
CREATE TABLE public.raw_karmahq_attestations(attester VARCHAR, recipient VARCHAR, isOffchain BOOLEAN, timeCreated BIGINT, decodedDataJson VARCHAR);