Assets Providers

Semantic Contract

Definitions

Column	Description
id	Unique identifier of the Asset Provider.
name	Name of the Asset Provider.
asset_type_id	Reference to the Asset Types.
currency_id	Reference to Currencies.

Sample & Implementation

A list of Asset Providers
id	name	asset_type_id	currency_id
a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d	Stripe	1	1
b2c3d4e5-f6a7-4b8c-9d0e-1f2a3b4c5d6e	PayPal	1	2
c3d4e5f6-a7b8-4c9d-0e1f-2a3b4c5d6e7f	Internal	2	1
d4e5f6a7-b8c9-4d0e-1f2a-3b4c5d6e7f8a	Wise	3	2
e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b	Revolut	1	2
f6a7b8c9-d0e1-4f2a-3b4c-5d6e7f8a9b0c	Internal	3	2
a7b8c9d0-e1f2-4a3b-4c5d-6e7f8a9b0c1d	Stripe	2	1
b8c9d0e1-f2a3-4b4c-5d6e-7f8a9b0c1d2e	PayPal	1	3
c9d0e1f2-a3b4-4c5d-6e7f-8a9b0c1d2e3f	Internal	1	2
d0e1f2a3-b4c5-4d6e-7f8a-9b0c1d2e3f4a	Internal	1	1
e1f2a3b4-c5d6-4e7f-8a9b-0c1d2e3f4a5b	Mercury	2	2
f2a3b4c5-d6e7-4f8a-9b0c-1d2e3f4a5b6c	Brex	3	2
a3b4c5d6-e7f8-4a9b-0c1d-2e3f4a5b6c7d	Internal	3	3
b4c5d6e7-f8a9-4b0c-1d2e-3f4a5b6c7d8e	Internal	4	2
c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e9f	Stripe	2	4
d6e7f8a9-b0c1-4d2e-3f4a-5b6c7d8e9f0a	PayPal	4	1
e7f8a9b0-c1d2-4e3f-4a5b-6c7d8e9f0a1b	Internal	3	2
f8a9b0c1-d2e3-4f4a-5b6c-7d8e9f0a1b2c	Wise	1	2
a9b0c1d2-e3f4-4a5b-6c7d-8e9f0a1b2c3d	HSBC	2	2
b0c1d2e3-f4a5-4b6c-7d8e-9f0a1b2c3d4e	Revolut	1	1
c1d2e3f4-a5b6-4c7d-8e9f-0a1b2c3d4e5f	Stripe	4	4
d2e3f4a5-b6c7-4d8e-9f0a-1b2c3d4e5f6a	PayPal	3	4
e3f4a5b6-c7d8-4e9f-0a1b-2c3d4e5f6a7b	Internal	2	2
f4a5b6c7-d8e9-4f0a-1b2c-3d4e5f6a7b8c	UBS	3	3
a5b6c7d8-e9f0-4a1b-2c3d-4e5f6a7b8c9d	Internal	1	1

CREATE TABLE IF NOT EXISTS assets_providers (
    id UUID PRIMARY KEY,
    name VARCHAR NOT NULL,
    asset_type_id INTEGER NOT NULL,
    currency_id INTEGER NOT NULL,
    FOREIGN KEY (asset_type_id) REFERENCES asset_types(id),
    FOREIGN KEY (currency_id) REFERENCES currencies(id)
)

Data Format

Field

Type

Dependencies

Asset Types
Currencies

Semantic Contract

Definitions

Sample & Implementation

Data Format

Dependencies

On this page