Full relational diagram - sql with partitioned field

Full relational diagram - sql with partitioned field.sql

SELECT
    transactions.hash as transaction_hash,
    transactions.block_hash,
    transactions.block_number,
    transactions.block_timestamp,
    outputs.index,
    outputs.script_asm,
    outputs.script_hex,
    outputs.required_signatures,
    outputs.type,
    outputs.addresses,
    outputs.value
FROM `bigquery-public-data.crypto_bitcoin.transactions` as transactions,
    transactions.outputs as outputs # no join needed due to recored type
WHERE transactions.hash = 'f4184fc596403b9d638783cf57adfe4c75c605f6356fbc91338530e9831e9e16'
        AND transactions.block_timestamp_month = '2009-01-01'
LIMIT 100