The Grid - Public Docs

The Grid - Public Docs

TGS - Data model

TGS Change Log

0.7 - In progress

Assets

Add Asset status

Migrate deployed on + contracts to new tables below

Products:

Add Product docs

Rename productSupports to supportsProducts

Migrate deployed on + contracts to new tables below

New tables:

Deployments

deploymentType

deployedOn

isOfStandard

Contracts

deployment (belongs to a deployments table)

name

address

deploymentDate

Product Asset Relationships

This contains info about the relationship between products and assets. Eg Bitcoin is the native asset to bitcoin network. Circle Stablecoin issuance, is a ‘issues’ an asset USDC.

Product

Asset

Type (see Type of Support below )

Derivative Assets

To hold info on assets that are Derivatives of others

derivativeAsset (link to the parent asset → EG wBTC or Stablecoins)

baseAsset (link to the child asset, what sits under it → EG BTC) in the example above

New Enum tables

Asset Status

Deployment Types

AssetSupport Types

Nerd stuff:

Move urls into URLs table

Introduce a new Root concept (technical)

0.6 - COMPLETE

Added tags (more info coming!)

0.5 - COMPLETE

Products → products.assetSupport rename to → products.mainAsset

Functionality / connections the same

Products → Add → products.productSupports field:

Multiselect - Table ProductSupports: ID_PRODUCT, ID_SUPPORTED_PRODUCT

Examples:

Chainalysis (onchain investigation) supports many L1s + L2s + L3s

Quick node (node hosting) supports many L1s + L2s + L3s

Wallets & Custodians for asset management supports many L1s + L2s + L3s

⁠

https://linear.app/the-grid/issue/TGS-10/add-supported-networks-to-products⁠

Import list of countries

https://datahub.io/core/country-list⁠

Should now be a select list in the database in Entity.

⁠

https://linear.app/the-grid/issue/TGS-9/add-list-of-countries-into-tgs⁠

⁠

Removed Subsector

0.4 - COMPLETE.

Added fields:

profiles.tagLine → New field as is a ‘self promotion’ field. (in DB)

assets.shortDescription → New field as forgot to put in one on assets at the start. (in DB)

Updated spelling of:

Entitiy → Entity (table)

Updated VAT to Tax Identification Number → entities.taxIdentificationNumber to ensure more general

Name of Date of Incorperation → Date of incorporation

Parameter ID of entities.dateOfIncoroperation → entities.dateOfIncorporation

Parameter ID of entities.localRegestrationNumber → entities.localRegistrationNumber

Parameter ID of asset.shortDescription → assets.shortDescription

Parameter ID of producst.assetSupport → products.assetSupport

Description of Entity Name > Legal Name of the project, it is often different from Project Name. → Legal Name of the project, it is often different from Product or Profile Name. (we do not have a Project category in the table)

Removed IDs and helper tables from TGS as type helper tables are not helpful

9 April 2024

added Validation steps to:

Documentation URL (Profile)

Asset Type (Asset)

Deployed On (Asset)

URL (Socials)

Type of Socials (Socials)

Name (Socials)

Icon (Asset)

changed description of Deployed On (Asset): A link to which product (blockchain) is this asset deployed on? → On which blockchain is the asset built?