Current Relation Between Tables

[thelostone-mc]

erDiagram
    projects {
        text id
        text name
        decimal nonce
        text anchorAddress
        integer chainId
        integer projectNumber
        text registryAddress
        text metadataCid
        jsonb metadata
        text createdByAddress
        decimal createdAtBlock
        decimal updatedAtBlock
        text[] tags
        text projectType
    }
    pending_project_roles_IGNORE {
        serial id
        integer chainId
        text role
        text address
        decimal createdAtBlock
    }
    project_roles {
        integer chainId
        text projectId
        text address
        text role
        decimal createdAtBlock
    }
    rounds {
        text id
        integer chainId
        text[] tags
        decimal matchAmount
        text matchTokenAddress
        real matchAmountInUSD
        decimal fundedAmount
        real fundedAmountInUSD
        text applicationMetadataCid
        jsonb applicationMetadata
        text roundMetadataCid
        jsonb roundMetadata
        timestamptz applicationsStartTime
        timestamptz applicationsEndTime
        timestamptz donationsStartTime
        timestamptz donationsEndTime
        text createdByAddress
        decimal createdAtBlock
        decimal updatedAtBlock
        text managerRole
        text adminRole
        text strategyAddress
        text strategyId
        text strategyName
        jsonb matchingDistribution
        text readyForPayoutTransaction
        text projectId
        real totalAmountDonatedInUSD
        integer totalDonationsCount
        integer uniqueDonorsCount
        decimal totalDistributed
    }
    pending_round_roles {
        serial id
        integer chainId
        text role
        text address
        decimal createdAtBlock
    }
    round_roles {
        integer chainId
        text roundId
        text address
        text role
        decimal createdAtBlock
    }
    applications {
        text id
        integer chainId
        text roundId
        text projectId
        text anchorAddress
        text status
        jsonb statusSnapshots
        text distributionTransaction
        text metadataCid
        jsonb metadata
        text createdByAddress
        decimal createdAtBlock
        decimal statusUpdatedAtBlock
        integer totalDonationsCount
        real totalAmountDonatedInUSD
        integer uniqueDonorsCount
        text[] tags
    }
    applications_payouts {
        serial id
        integer chainId
        text applicationId
        text roundId
        decimal amount
        text tokenAddress
        real amountInUSD
        text amountInRoundMatchToken
        text transactionHash
        timestamptz timestamp
        text sender
    }
    donations {
        text id
        integer chainId
        text roundId
        text applicationId
        text donorAddress
        text recipientAddress
        text projectId
        text transactionHash
        decimal blockNumber
        text tokenAddress
        timestamptz timestamp
        decimal amount
        real amountInUSD
        decimal amountInRoundMatchToken
    }
    prices {
        serial id
        integer chainId
        text tokenAddress
        real priceInUSD
        timestamptz timestamp
        decimal blockNumber
    }
    legacy_projects {
        serial id
        text v1ProjectId
        text v2ProjectId
    }

    projects ||--o{ project_roles : "has"
    projects ||--o{ rounds : "has"
    projects ||--o{ applications : "has"
    rounds ||--o{ applications : "has"
    applications ||--o{ applications_payouts : "has"
    applications ||--o{ donations : "has"
    rounds ||--o{ donations : "has"
    projects ||--o{ donations : "has"

    project_roles }|..|{ projects : "references"
    round_roles }|..|{ rounds : "references"
    applications }|..|{ projects : "references"
    applications }|..|{ rounds : "references"
    applications_payouts }|..|{ applications : "references"
    applications_payouts }|..|{ rounds : "references"
    donations }|..|{ applications : "references"
    donations }|..|{ rounds : "references"

Loading