# Rarible schema ERD

Table and field reference for the Fivetran Rarible connector.

## Table & Field Reference

### collection_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature | String | PK |
| collection_id | String | PK, FK |

### collection_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| collection_id | String | PK, FK |

### collection_genre

| Column | Type | Keys |
| --- | --- | --- |
| genre | String | PK |
| collection_id | String | PK, FK |

### 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 | PK, FK |

### 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 | PK, 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_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 | PK, FK |
| value | Double |  |

### item_attribute

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| item_id | String | PK, FK |
| 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 | PK, FK |

### item_genre

| Column | Type | Keys |
| --- | --- | --- |
| genre | String | PK |
| item_id | String | PK, FK |

### item_restriction

| Column | Type | Keys |
| --- | --- | --- |
| restriction | String | PK |
| item_id | String | PK, FK |

### item_origin_order

| Column | Type | Keys |
| --- | --- | --- |
| origin | String | PK |
| item_id | String | PK, 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_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 |  |

## Relationships

- collection_feature(collection_id) → collection(id)
- collection_tag(collection_id) → collection(id)
- collection_genre(collection_id) → collection(id)
- collection_content(collection_id) → collection(id)
- collection_minter(collection_id) → collection(id)
- collection_volume(collection_id) → collection(id)
- collection_origin_order(collection_id) → collection(id)
- item_creator(item_id) → item(id)
- item_attribute(item_id) → item(id)
- item_content(item_id) → item(id)
- item_tag(item_id) → item(id)
- item_genre(item_id) → item(id)
- item_restriction(item_id) → item(id)
- item_origin_order(item_id) → item(id)
- item(collection_id) → collection(id)
- activity(item_id) → item(id)
- activity(collection_id) → collection(id)