Rarible

Explore the interactive ERD

Table & Field Reference

collection_feature

Column	Type	Keys
`feature`	String	PK
`collection_id`	String	PKFK

collection_tag

Column	Type	Keys
`tags`	String	PK
`collection_id`	String	PKFK

collection_genre

Column	Type	Keys
`genre`	String	PK
`collection_id`	String	PKFK

collection_content

Column	Type	Keys
`_fivetran_id`	String	PK
`collection_id`	String	FK
`file_name`	String
`height`	Long
`mime_type`	String
`representation`	String
`size`	Long
`type`	String
`url`	String
`width`	Long

collection_minter

Column	Type	Keys
`minter`	String	PK
`collection_id`	String	PKFK

collection_volume

Column	Type	Keys
`_fivetran_id`	String	PK
`collection_id`	String	FK
`change_percent`	Double
`period`	String
`value`	Double
`value_usd`	Double

collection_origin_order

Column	Type	Keys
`origin`	String	PK
`collection_id`	String	PKFK
`best_bid_order_cancelled`	Boolean
`best_bid_order_created_at`	Instant
`best_bid_order_data_fee`	Double
`best_bid_order_data_type`	String
`best_bid_order_db_updated_at`	Instant
`best_bid_order_ended_at`	Instant
`best_bid_order_fill`	Double
`best_bid_order_id`	String
`best_bid_order_last_updated_at`	Instant
`best_bid_order_make_price`	Double
`best_bid_order_make_price_usd`	Double
`best_bid_order_make_stock`	Double
`best_bid_order_make_type_contract`	String
`best_bid_order_make_type_token_id`	String
`best_bid_order_make_type_type`	String
`best_bid_order_make_value`	Double
`best_bid_order_maker`	String
`best_bid_order_platform`	String
`best_bid_order_salt`	String
`best_bid_order_signature`	String
`best_bid_order_started_at`	Instant
`best_bid_order_status`	String
`best_bid_order_take_price`	Double
`best_bid_order_take_price_usd`	Double
`best_bid_order_take_type_contract`	String
`best_bid_order_take_type_token_id`	String
`best_bid_order_take_type_type`	String
`best_bid_order_take_value`	Double
`best_bid_order_taker`	String
`best_sell_order_cancelled`	Boolean
`best_sell_order_created_at`	Instant
`best_sell_order_data_fee`	Double
`best_sell_order_data_type`	String
`best_sell_order_db_updated_at`	Instant
`best_sell_order_ended_at`	Instant
`best_sell_order_fill`	Double
`best_sell_order_id`	String
`best_sell_order_last_updated_at`	Instant
`best_sell_order_make_price`	Double
`best_sell_order_make_price_usd`	Double
`best_sell_order_make_stock`	Double
`best_sell_order_make_type_contract`	String
`best_sell_order_make_type_token_id`	String
`best_sell_order_make_type_type`	String
`best_sell_order_make_value`	Double
`best_sell_order_maker`	String
`best_sell_order_platform`	String
`best_sell_order_salt`	String
`best_sell_order_signature`	String
`best_sell_order_started_at`	Instant
`best_sell_order_status`	String
`best_sell_order_take_price`	Double
`best_sell_order_take_price_usd`	Double
`best_sell_order_take_type_contract`	String
`best_sell_order_take_type_token_id`	String
`best_sell_order_take_type_type`	String
`best_sell_order_take_value`	Double
`best_sell_order_taker`	String

collection

Column	Type	Keys
`id`	String	PK
`best_bid_order_cancelled`	Boolean
`best_bid_order_created_at`	Instant
`best_bid_order_data_fee`	Double
`best_bid_order_data_type`	String
`best_bid_order_db_updated_at`	Instant
`best_bid_order_ended_at`	Instant
`best_bid_order_fill`	Double
`best_bid_order_id`	String
`best_bid_order_last_updated_at`	Instant
`best_bid_order_make_price`	Double
`best_bid_order_make_price_usd`	Double
`best_bid_order_make_stock`	Double
`best_bid_order_make_type_contract`	String
`best_bid_order_make_type_token_id`	String
`best_bid_order_make_type_type`	String
`best_bid_order_make_value`	Double
`best_bid_order_maker`	String
`best_bid_order_platform`	String
`best_bid_order_salt`	String
`best_bid_order_signature`	String
`best_bid_order_started_at`	Instant
`best_bid_order_status`	String
`best_bid_order_take_price`	Double
`best_bid_order_take_price_usd`	Double
`best_bid_order_take_type_contract`	String
`best_bid_order_take_type_token_id`	String
`best_bid_order_take_type_type`	String
`best_bid_order_take_value`	Double
`best_bid_order_taker`	String
`best_sell_order_cancelled`	Boolean
`best_sell_order_created_at`	Instant
`best_sell_order_data_fee`	Double
`best_sell_order_data_type`	String
`best_sell_order_db_updated_at`	Instant
`best_sell_order_ended_at`	Instant
`best_sell_order_fill`	Double
`best_sell_order_id`	String
`best_sell_order_last_updated_at`	Instant
`best_sell_order_make_price`	Double
`best_sell_order_make_price_usd`	Double
`best_sell_order_make_stock`	Double
`best_sell_order_make_type_contract`	String
`best_sell_order_make_type_token_id`	String
`best_sell_order_make_type_type`	String
`best_sell_order_make_value`	Double
`best_sell_order_maker`	String
`best_sell_order_platform`	String
`best_sell_order_salt`	String
`best_sell_order_signature`	String
`best_sell_order_started_at`	Instant
`best_sell_order_status`	String
`best_sell_order_take_price`	Double
`best_sell_order_take_price_usd`	Double
`best_sell_order_take_type_contract`	String
`best_sell_order_take_type_token_id`	String
`best_sell_order_take_type_type`	String
`best_sell_order_take_value`	Double
`best_sell_order_taker`	String
`blockchain`	String
`meta_created_at`	Instant
`meta_description`	String
`meta_external_link`	String
`meta_external_uri`	String
`meta_fee_recipient`	String
`meta_language`	String
`meta_name`	String
`meta_original_meta_uri`	String
`meta_rights`	String
`meta_rights_uri`	String
`meta_seller_fee_basis_points`	Double
`name`	String
`owner`	String
`parent`	String
`self`	Boolean
`statistics_floor_price_value`	Double
`statistics_floor_price_value_usd`	Double
`statistics_highest_sale_value`	Double
`statistics_highest_sale_value_usd`	Double
`statistics_item_count`	Long
`statistics_owner_count`	Long
`statistics_total_volume_value`	Double
`statistics_total_volume_value_usd`	Double
`symbol`	String
`type`	String

item_creator

Column	Type	Keys
`account`	String	PK
`item_id`	String	PKFK
`value`	Double

item_attribute

Column	Type	Keys
`key`	String	PK
`item_id`	String	PKFK
`format`	String
`type`	String
`value`	String

item_content

Column	Type	Keys
`_fivetran_id`	String	PK
`item_id`	String	FK
`available`	Boolean
`file_name`	String
`height`	Long
`mime_type`	String
`representation`	String
`size`	Long
`type`	String
`url`	String
`width`	Long

item_tag

Column	Type	Keys
`tags`	String	PK
`item_id`	String	PKFK

item_genre

Column	Type	Keys
`genre`	String	PK
`item_id`	String	PKFK

item_restriction

Column	Type	Keys
`restriction`	String	PK
`item_id`	String	PKFK

item_origin_order

Column	Type	Keys
`origin`	String	PK
`item_id`	String	PKFK
`best_bid_order_cancelled`	Boolean
`best_bid_order_created_at`	Instant
`best_bid_order_data_fee`	Double
`best_bid_order_data_type`	String
`best_bid_order_db_updated_at`	Instant
`best_bid_order_ended_at`	Instant
`best_bid_order_fill`	Double
`best_bid_order_id`	String
`best_bid_order_last_updated_at`	Instant
`best_bid_order_make_price`	Double
`best_bid_order_make_price_usd`	Double
`best_bid_order_make_stock`	Double
`best_bid_order_make_type_contract`	String
`best_bid_order_make_type_token_id`	String
`best_bid_order_make_type_type`	String
`best_bid_order_make_value`	Double
`best_bid_order_maker`	String
`best_bid_order_platform`	String
`best_bid_order_salt`	String
`best_bid_order_signature`	String
`best_bid_order_started_at`	Instant
`best_bid_order_status`	String
`best_bid_order_take_price`	Double
`best_bid_order_take_price_usd`	Double
`best_bid_order_take_type_contract`	String
`best_bid_order_take_type_token_id`	String
`best_bid_order_take_type_type`	String
`best_bid_order_take_value`	Double
`best_bid_order_taker`	String
`best_sell_order_cancelled`	Boolean
`best_sell_order_created_at`	Instant
`best_sell_order_data_fee`	Double
`best_sell_order_data_type`	String
`best_sell_order_db_updated_at`	Instant
`best_sell_order_ended_at`	Instant
`best_sell_order_fill`	Double
`best_sell_order_id`	String
`best_sell_order_last_updated_at`	Instant
`best_sell_order_make_price`	Double
`best_sell_order_make_price_usd`	Double
`best_sell_order_make_stock`	Double
`best_sell_order_make_type_contract`	String
`best_sell_order_make_type_token_id`	String
`best_sell_order_make_type_type`	String
`best_sell_order_make_value`	Double
`best_sell_order_maker`	String
`best_sell_order_platform`	String
`best_sell_order_salt`	String
`best_sell_order_signature`	String
`best_sell_order_started_at`	Instant
`best_sell_order_status`	String
`best_sell_order_take_price`	Double
`best_sell_order_take_price_usd`	Double
`best_sell_order_take_type_contract`	String
`best_sell_order_take_type_token_id`	String
`best_sell_order_take_type_type`	String
`best_sell_order_take_value`	Double
`best_sell_order_taker`	String

item

Column	Type	Keys
`id`	String	PK
`collection_id`	String	FK
`best_bid_order_cancelled`	Boolean
`best_bid_order_created_at`	Instant
`best_bid_order_data_fee`	Double
`best_bid_order_data_type`	String
`best_bid_order_db_updated_at`	Instant
`best_bid_order_ended_at`	Instant
`best_bid_order_fill`	Double
`best_bid_order_id`	String
`best_bid_order_last_updated_at`	Instant
`best_bid_order_make_price`	Double
`best_bid_order_make_price_usd`	Double
`best_bid_order_make_stock`	Double
`best_bid_order_make_type_contract`	String
`best_bid_order_make_type_token_id`	String
`best_bid_order_make_type_type`	String
`best_bid_order_make_value`	Double
`best_bid_order_maker`	String
`best_bid_order_platform`	String
`best_bid_order_salt`	String
`best_bid_order_signature`	String
`best_bid_order_started_at`	Instant
`best_bid_order_status`	String
`best_bid_order_take_price`	Double
`best_bid_order_take_price_usd`	Double
`best_bid_order_take_type_blockchain`	String
`best_bid_order_take_type_contract`	String
`best_bid_order_take_type_token_id`	String
`best_bid_order_take_type_type`	String
`best_bid_order_take_value`	Double
`best_bid_order_taker`	String
`best_sell_order_cancelled`	Boolean
`best_sell_order_created_at`	Instant
`best_sell_order_data_fee`	Double
`best_sell_order_data_type`	String
`best_sell_order_db_updated_at`	Instant
`best_sell_order_ended_at`	Instant
`best_sell_order_fill`	Double
`best_sell_order_id`	String
`best_sell_order_last_updated_at`	Instant
`best_sell_order_make_price`	Double
`best_sell_order_make_price_usd`	Double
`best_sell_order_make_stock`	Double
`best_sell_order_make_type_contract`	String
`best_sell_order_make_type_token_id`	String
`best_sell_order_make_type_type`	String
`best_sell_order_make_value`	Double
`best_sell_order_maker`	String
`best_sell_order_platform`	String
`best_sell_order_salt`	String
`best_sell_order_signature`	String
`best_sell_order_started_at`	Instant
`best_sell_order_status`	String
`best_sell_order_take_price`	Double
`best_sell_order_take_price_usd`	Double
`best_sell_order_take_type_blockchain`	String
`best_sell_order_take_type_contract`	String
`best_sell_order_take_type_token_id`	String
`best_sell_order_take_type_type`	String
`best_sell_order_take_value`	Double
`best_sell_order_taker`	String
`blockchain`	String
`collection`	String
`contract`	String
`deleted`	Boolean
`last_sale_buyer`	String
`last_sale_currency_contract`	String
`last_sale_currency_token_id`	String
`last_sale_currency_type`	String
`last_sale_date`	Instant
`last_sale_price`	Double
`last_sale_seller`	String
`last_sale_value`	Double
`last_updated_at`	Instant
`lazy_supply`	Long
`meta_created_at`	Instant
`meta_description`	String
`meta_external_uri`	String
`meta_language`	String
`meta_name`	String
`meta_original_meta_uri`	String
`meta_rights`	String
`meta_rights_uri`	String
`minted_at`	Instant
`self`	Boolean
`sellers`	Long
`supply`	String
`token_id`	String
`total_stock`	Long

activity

Column	Type	Keys
`id`	String	PK
`collection_id`	String	FK
`item_id`	String	FK
`amount_usd`	Double
`blockchain_info_block_hash`	String
`blockchain_info_block_number`	Long
`blockchain_info_log_index`	Long
`blockchain_info_transaction_hash`	String
`buyer`	String
`buyer_order_hash`	String
`contract`	String
`date`	Instant
`from_source`	String
`hash`	String
`last_updated_at`	Instant
`make_contract`	String
`make_token_id`	String
`make_type`	String
`make_type_contract`	String
`make_type_token_id`	String
`make_type_type`	String
`make_value`	Double
`maker`	String
`nft_type_contract`	String
`nft_type_token_id`	String
`nft_type_type`	String
`nft_value`	Double
`owner`	String
`payment_type_contract`	String
`payment_type_token_id`	String
`payment_type_type`	String
`payment_value`	Double
`price`	Double
`price_usd`	Double
`reverted`	Boolean
`sell_type`	String
`seller`	String
`seller_order_hash`	String
`source`	String
`take_blockchain`	String
`take_contract`	String
`take_token_id`	String
`take_type`	String
`take_type_blockchain`	String
`take_type_contract`	String
`take_type_token_id`	String
`take_type_type`	String
`take_value`	Double
`token_id`	String
`transaction_hash`	String
`type`	String
`value`	String