rwa_multichain.product_reference_data is the catalog of tokenized RWA products included in the metadata research scope. Grain: one row per product_id. deployments is an array of (chain, token_address) pairs from the product token registry — empty (never null) when the product has no registered on-chain identity yet.
This table is product grain with chain deployments nested. tokens_reference_data is token grain with product fields attached. Join the two on product_id.
Coverage and shared assets
Product inventory and researched metadata have different scopes. Products outside the research scope retain their identities and registered token deployments, but their archived enrichment is excluded from this table. Their token rows and available product, issuer and platform identity remain intokens_reference_data; an inner join to this product table excludes those rows. The research scope prioritizes equities and commodities, plus selected fixed-income and alternative products with established price coverage. Registration or pricing alone does not establish complete researched metadata.
asset_id links the product to a shared reference asset. That asset identifies and classifies the referenced investment independently of its tokenisation products and chain deployments. Multiple issuers’ Tesla products can link to the same Tesla ordinary-share asset, while keeping their own issuer, legal wrapper and investor terms. Different securities or share classes have separate asset identities; exchange listings do not by themselves create a new shared asset.
Classification comes from the linked asset: asset_class is economic exposure, asset_subclass narrows that exposure, and asset_type is financial form. A null asset_id means the reference asset has not been resolved; the classification fields can also be null when evidence is insufficient.
Table schema
Product identity
Asset classification
Mechanics and legal structure
Blank versus NOT_APPLICABLE
- Blank means the value is unknown or not yet verified.
NOT_APPLICABLEmeans the field has been shown not to apply — a basket product has no singleunderlying_ticker, a non-SEC issuer has noissuer_cik.
WHERE custodian_entity NOT IN ('', 'NOT_APPLICABLE') gives products with a known custodian; WHERE custodian_entity = 'NOT_APPLICABLE' gives products for which custody does not apply.
asset_class and asset_subclass values
A fund follows its principal investment exposure. A Treasury ETF is
fixed_income / public_sector_debt; a gold ETF is commodities / metals. Listing a fund does not make its portfolio exposure equities. Public-sector debt includes sovereign, agency, supranational and development-bank borrowers. A private corporate loan does not become public-sector debt because it has a government guarantee.
credit and cash_equivalent are no longer separate tokenized-product classes; debt falls within fixed_income. The former multi_asset and other groupings are covered by alternative. A supported broad class can remain populated when the subclass is unknown. The public classification fields use SQL null for unresolved values and intentionally unassigned Alternative subclasses.
asset_type values
asset_type describes the financial form independently of exposure. It replaces the former mix of exposure, form and tokenisation labels; this is a change in meaning of an existing column, not a direct rename of old values.
A tokenized Tesla product can reference
common_share without giving token holders Tesla voting rights. Those rights and the token’s legal structure must be established from its own product terms.
Hyperliquid perpetual markets retain their existing exposure vocabulary. Their
asset_type field has a different meaning from the shared asset’s financial form. Do not combine the vocabularies or join a perpetual’s numeric asset_id to this shared-asset identifier.legal_wrapper_type values
DIRECT_TOKENIZED_EQUITY, SPECIAL_PURPOSE_VEHICLE, REGISTERED_FUND, UNREGISTERED_FUND, STRUCTURED_NOTE, STRUCTURED_CREDIT_TRANCHE, DERIVATIVE_CONTRACT, CUSTODIAL_RECEIPT, WRAPPED_RWA_TOKEN, DEFI_VAULT_SHARE, OTHER.
eligible_investors values
UNRESTRICTED, US_RETAIL, US_ACCREDITED, US_QUALIFIED_PURCHASER, PROFESSIONAL_QUALIFIED, NON_US_PERSON, INSTITUTIONAL_ONLY.
PROFESSIONAL_QUALIFIED is jurisdiction-neutral (MiFID II, Swiss CISA, UK FCA, and similar tests). Which regime supplies the test is a regulatory_framework fact.
Issuer, platform, and asset manager
issuer_nameidentifies the legal entity that issues this tokenized product. Do not substitute the manager, platform, sponsor, or issuer of an instrument the product wraps. Group by this field for issuer rankings, not automatically for asset-manager rankings.platform_nameidentifies the tokenization or distribution platform. For example,tltonhas issuerOndo Global Markets (BVI) Limitedand platformOndo Global Markets; its underlying ticker isTLT.asset_manager_entityidentifies the entity managing the underlying portfolio when distinct from the issuer. Use the populated manager field for manager attribution; a blank value is unknown, andNOT_APPLICABLEdenotes a self-managed or passive receipt structure.
Example queries
Issuer league table for tokenized public-sector debt funds:US_RETAIL, by legal wrapper (excludes the separate UNRESTRICTED category):