TGS - Data model

The full official name of the Profile as used in their branding and documentation.

profileInfos.profileTypeId

The primary operational category or business model of the Profile (e.g. DAO, project, investor, government). Refer to standardized list of Profile types.

profileInfos.profileSectorId

The primary industry, use case, or problem space the Profile operates in or serves. Refer to standardized list of sectors and subsectors.

profileInfos.profileStatusId

The current operational state of the Profile (e.g. Active, Inactive, Closed). Refer to the standardized list of status options.

profileInfos.foundingDate

The date when the Profile was first established, registered, or publicly announced. Use ISO 8601 format (YYYY-MM-DD) when possible. Can usually be shortened to Month and Year.

profileInfos.logo

Provide a full rectangle logo (wordmark + icon) that works on a white background and be transparent. Preferably an SVG image file. If it is a PNG, it should have a minimum resolution of 256px height.

profileInfos.descriptionShort

Provide an objective overview of the Profile's primary purpose, product, or service. Avoid subjective claims, marketing language, or unnecessary technical jargon. Focus on clear, factual information. Limit to 200 characters.

profileInfos.descriptionLong

A more detailed overview of the Profile, including its mission, target audience, and key features or offerings. Limit to 500 characters and avoid subjective claims.

profileInfos.tagLine

A brief, memorable phrase or slogan used by the Profile to convey its mission or value proposition. If the tagline is in all caps or contains irregular spaces or line breaks, reformat it to a single line, single spaced, and sentence case.

profileInfos.rootId

A link to the root

Unique Identifier - Of the profile.

profileInfos.icon

Provide a square profile icon that works on a white background and be transparent. Preferably an SVG image file. If it is a PNG, it should have a minimum resolution of 256px height.

profileInfos.descriptionMarketing

A promotional description aiming to attract and engage potential users or customers. This field allows persuasive language and value driven messaging that highlights the Profile's unique selling points and market advantages. Content should be engaging while remaining factually accurate.

products.name

The official name of the product as used in its branding, marketing, and user-facing materials.

products.productTypeId

The primary category or function of the product (e.g. exchange, wallet, lending platform). Refer to standardized list of product types.

products.description

A concise, objective statement explaining what the product does and who it is for.

products.productStatusId

The current development or access stage of the product (e.g. Beta, Live, Deprecated).

products.isMainProduct

A boolean value indicating whether the product is the Profile's primary or flagship offering.

products.launchDate

The date when the product was first launched or made publicly available. Use ISO 8601 format (YYYY-MM-DD) when possible.

products.supportsProducts

Lists all the products that this product explicitly supports. This also describes a direction of support, for example a wallet may support a chain, but a chain does not support a wallet. Not used for on-chain deployments.

products.rootId

​

Unique Identifier - Of the product.

assets.name

The official name of the Asset as used in its branding, marketing, and trading materials.

​

assets.ticker

The unique trading symbol used to represent the Asset on exchanges and trading platforms. Use only capital letters and numbers.

assets.icon

A square PNG but ideally an SVG image file representing the Asset's icon or logo, with a transparent background and a minimum resolution of 128x128 pixels.

assets.description

A concise, one-sentence summary of the Asset's key characteristics, use case, or value proposition. Limit to 200 characters and avoid subjective claims.

assets.assetTypeId

The primary category or function of the Asset (e.g. Currency, Utility, Security) and what is does.

​

assets.address

The unique smart contract address of the Asset on the blockchain it is deployed on. Use a standard blockchain explorer to validate the address.

assets.rootId

A reference to the Profile associated with the Asset, using the Profile's unique identifier or name.

assets.assetStatusId

The current development or access stage of the asset. Refer to the standardized list of asset status options.

Unique Identifier

The legal name of the Entity as registered with the relevant regulatory bodies or government agencies.

entities.tradeName

Any additional trading names, brands, or trademarks associated with the Entity, separate from its legal name.

entities.entityTypeId

The legal structure or registration category of the Entity (e.g. LLC, Foundation, Corporation).

entities.dateOfIncorporation

The date when the Entity was legally registered or incorporated. Use ISO 8601 format (YYYY-MM-DD) when possible.

entities.localRegistrationNumber

The registration number assigned to the Entity by the relevant regulatory body or government agency, if applicable.

entities.taxIdentificationNumber

The unique tax identification number assigned to the Entity by the relevant tax authority, if applicable.

entities.address

The registered physical address of the Entity, including street, city, state/province (if applicable), and postal code.

entities.countryId

The country in which the Entity is legally registered or incorporated, using the ISO 3166-1 alpha-2 country code format.

entities.leiNumber

The Legal Entity Identifier (LEI) code assigned to the Entity by the Global Legal Entity Identifier Foundation (GLEIF), if applicable.

Unique Identifier - Of the entity.

entities.rootId

​

socials.socialTypeId

The specific social media platform the URL belongs to (e.g. Twitter, Facebook, Discord). Refer to the standardized list of social media platforms.

The handle associated with the Profile's social media account on the specified platform. This should match the handle displayed on the social media profile page and is often at the end of the URL.

Unique Identifier

socials.tableId

Foreign key

socials.rowId

A pointer that points to a row in one of a few core table names.

socials.socialStatusId

The current operational state of the social. Refer to the standardized list of status options.

roots.slug

A URL-friendly version of the Profile's name, used for creating unique, readable URLs and internal references. The slug is automatically generated from the Profile's name, consisting of lowercase letters, numbers, and hyphens.

Unique Identifier

roots.urlMain

The main URL of the profile.

The name of a tag which is a reference to something. This something is defined by its description and type.

tags.tagTypeId

A reference to a connected table that contains a type. A type of tag provides some context as to what a tag is and also contains a description.

tags.description

A description of this tag which provides a short explanation over what this unique tag is about

Unique Identifier

tags.isArchived

A boolean that indicates if a tag is archived.

smartContractDeployments.deploymentTypeId

Categorizes the type of deployment based on the smart contract’s main purpose. For example, if the contract is primarily used to mint an asset, it will be tagged as ‘mint’.

​

smartContractDeployments.deployedOnId

Specifies which blockchain a smart contract is deployed on. If a product or asset does not have a smart contract, meaning it is not deployed on any blockchain, leave this field blank.

smartContractDeployments.assetStandardId

The technical standard or protocol specification that the smart contract implements. If the standard cannot be identified, leave this field blank.

Unique Identifier

smartContracts.deploymentId

The Deployment ID links individual smart contracts to their parent deployment record. A deployment can contain multiple related smart contracts (like a protocol's core contracts), but each blockchain deployment must have its own unique deployment record.

​

The official identifier or label for the smart contract as used in project documentation and blockchain explorers. If no name is given, leave it blank.

smartContracts.address

The unique blockchain address where the smart contract is deployed. Format must match the relevant blockchain's address structure.

​

smartContracts.deploymentDate

The date when the smart contract was deployed to the blockchain. Use ISO 8601 format (YYYY-MM-DD). Note: This will be automated in the future.

​

Unique Identifier

urls.urlTypeId

Categorizes the purpose and content of a URL based on its table group in the TGS. The URL type must align with both the content it links to and the context of its parameter group (Profile/Product/Asset/Entity/Social).

urls.url

This is a URL that links to different types, it must always start with a "http://" or "https://".

Unique Identifier

urls.tableId

​

urls.rowId

​

productAssetRelationships.productId

A product entry that maintains a defined relationship with one or more assets through integration, display, or functional requirements.

productAssetRelationships.assetId

An asset entry that functions within a specific product through integration, serving purposes defined by its Asset Type parameter.

productAssetRelationships.assetSupportTypeId

A classification of the functional relationship between a product and an asset, indicating how the asset is utilized within the product's operations.

Unique Identifier

Auto-incrementing primary key for the asset standard

The name of the technical standard (e.g. ERC20 or SPL)

assetStandards.definition

Detailed description of the standard's purpose and characteristics

assetStandards.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the asset status

The name of the status (e.g. Active or Deprecated)

assetStatuses.definition

Description of what this status means for an asset

assetStatuses.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the support type

Name of the support relationship type

assetSupportTypes.definition

Description of how this type of support functions between assets

assetSupportTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the product type

Name of the product category

productTypes.definition

Description of what this product type encompasses

productTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the asset type

Name of the asset category

assetTypes.definition

Description of what this type of asset represents

assetTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the entity type

Name of the entity structure type

entityTypes.definition

Description of what this type of entity structure represents

entityTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the product status

Name of the product status

productStatuses.definition

Description of what this status means for a product

productStatuses.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the profile sector

Name of the business/operation sector

profileSectors.definition

Description of what this sector encompasses

profileSectors.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the profile status

Name of the profile status

profileStatuses.definition

Description of what this status means for a profile

profileStatuses.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the profile type

Name of the profile type

profileTypes.definition

Description of what this type of profile represents

profileTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the social media type

Name of the social media platform

socialTypes.definition

Description of the social media platform type

socialTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the deployment type

Name of the deployment type

deploymentTypes.definition

Description of what this deployment type represents

deploymentTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the tag type

Name of the tag category

tagTypes.definition

Description of what this type of tag represents

tagTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the URL type

Name of the URL category

urlTypes.definition

Description of what this type of URL represents

urlTypes.slug

Slug, should not contain any spaces and be the same, if not very similar that the name

Auto-incrementing primary key for the country

Official name of the country

The short hand code for the country

supportsProducts.productId

​

supportsProducts.supportsProductId

​

Unique Identifier

derivativeAssets.derivativeAssetId

​

derivativeAssets.baseAssetId

​

Unique Identifier

productDeployments.productId

​

productDeployments.deploymentId

​

Unique Identifier

assetDeployments.deploymentId

​

assetDeployments.assetId

​

Unique Identifier

Unique Identifier

coreTableNames.tableName

​

Unique Identifier

​

​

socialStatuses.definition

​

Unique Identifier

rootRelationships.childRootId

The child in the relationship, meaning that this is the root that sits underneath the parent.

rootRelationships.parentRootId

The parent in the root relationship, often this profile acts as the over arching brand to other roots.

rootRelationships.relationshipTypeId

What is the type of relationship, links to the type table.

Unique Identifier

The short hand name which defines the type of the relationship between the parent and the child profiles.

rootRelationshipTypes.slug

The slug of the name, so it can be used in URLs and other places.

rootRelationshipTypes.definition

The definition of the relationship