Doma Testnet: Core DomainFi Entities
Core entities for traders
@blt.doma_testnet_core
Core entities for traders
@blt.doma_testnet_core
Core entities from Doma’s multi-chain DomainFi network, designed to power trader/degen dashboards and grow over time.
Initial release includes Names, Listings, and Offers. The dataset is intentionally extensible to
add more orderbook detail (e.g., depth, fills, cancels, venue metrics) and fractionalization data (events, supply,
buyout thresholds) in subsequent versions.
CREATE TABLE listings (
"id" BIGINT,
"external_id" VARCHAR,
"name" VARCHAR,
"name_expires_at" TIMESTAMP,
"token_id" VARCHAR,
"token_address" VARCHAR,
"price" VARCHAR,
"price_adj" DOUBLE,
"currency_symbol" VARCHAR,
"currency_decimals" BIGINT,
"orderbook" VARCHAR,
"offerer_address" VARCHAR,
"chain_name" VARCHAR,
"chain_network_id" VARCHAR,
"expires_at" TIMESTAMP,
"created_at" TIMESTAMP,
"updated_at" TIMESTAMP,
"registrar_name" VARCHAR,
"registrar_iana_id" BIGINT
);
CREATE TABLE names (
"name" VARCHAR,
"tokenized_at" TIMESTAMP,
"expires_at" TIMESTAMP,
"eoi" BOOLEAN,
"transfer_lock" BOOLEAN,
"claimed_by" VARCHAR,
"registrar_name" VARCHAR,
"registrar_iana_id" BIGINT,
"registrar_website_url" VARCHAR,
"nameservers" VARCHAR,
"ds_keys" VARCHAR,
"tokens" VARCHAR
);
CREATE TABLE offers (
"id" BIGINT,
"external_id" VARCHAR,
"name" VARCHAR,
"name_expires_at" TIMESTAMP,
"token_id" VARCHAR,
"token_address" VARCHAR,
"price" BIGINT,
"price_adj" DOUBLE,
"currency_symbol" VARCHAR,
"currency_decimals" BIGINT,
"orderbook" VARCHAR,
"offerer_address" VARCHAR,
"chain_name" VARCHAR,
"chain_network_id" VARCHAR,
"expires_at" TIMESTAMP,
"created_at" TIMESTAMP,
"registrar_name" VARCHAR,
"registrar_iana_id" BIGINT
);
Anyone who has the link will be able to view this.