> ## Documentation Index
> Fetch the complete documentation index at: https://docs.topsort.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Description du Schéma

export const LastUpdatedFr = ({date}) => {
  const label = "Dernière mise à jour:";
  return <>
      <style>{`
        .last-updated-component {
          display: inline-flex;
          align-items: center;
          gap: 8px;
          padding: 10px 16px;
          border-radius: 8px;
          margin-top: 12px;
          margin-bottom: 16px;
          font-size: 14px;
          background-color: rgba(0, 0, 0, 0.05);
          border: 1px solid rgba(0, 0, 0, 0.12);
          color: rgba(0, 0, 0, 0.75);
          line-height: 1;
        }

        .last-updated-component svg {
          flex-shrink: 0;
          vertical-align: middle;
        }

        .last-updated-component span {
          display: inline-flex !important;
          align-items: center !important;
          line-height: 1 !important;
        }

        [data-theme="dark"] .last-updated-component {
          background-color: #3a3a3a;
          border: 2px solid #888888;
          color: #ffffff;
        }

        [data-theme="dark"] .last-updated-component svg {
          stroke: #ffffff;
        }
      `}</style>
      <div className="last-updated-component">
        <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round">
          <circle cx="12" cy="12" r="10" />
          <polyline points="12 6 12 12 16 14" />
        </svg>
        <span>
          <strong style={{
    fontWeight: 600
  }}>{label}</strong> 
          <time dateTime={date}>{date}</time>
        </span>
      </div>
    </>;
};

## Core Identification

| Field               | Type       | Description                                           |
| ------------------- | ---------- | ----------------------------------------------------- |
| `id`                | **UUID**   | Unique identifier for the standardized product record |
| `source_product_id` | **STRING** | Product ID from the original catalog submission       |
| `marketplace_id`    | **UUID**   | Identifier for the submitting marketplace or vendor   |

## Product Information

| Field         | Type       | Description                            |
| ------------- | ---------- | -------------------------------------- |
| `title`       | **STRING** | Cleaned and standardized product title |
| `description` | **STRING** | Standardized product description       |

## Brand Data

| Field                  | Type       | Description                                           |
| ---------------------- | ---------- | ----------------------------------------------------- |
| `raw_brand_name`       | **STRING** | Brand name as received in the original catalog        |
| `brand_id`             | **UUID**   | Recognized canonical brand ID                         |
| `standard_brand_name`  | **STRING** | Standardized brand name associated with the brand ID  |
| `standard_brand_score` | **FLOAT**  | Standardized brand score associated with the brand ID |

## Category Classification

| Field                     | Type       | Description                                                   |
| ------------------------- | ---------- | ------------------------------------------------------------- |
| `raw_category_name`       | **STRING** | Original category label from the catalog                      |
| `category_id`             | **UUID**   | Mapped category ID from the standardized taxonomy             |
| `standard_category_path`  | **STRING** | Full category path (e.g., Electronics → Phones → Smartphones) |
| `standard_category_score` | **FLOAT**  | Standardized brand score associated with the category path    |

## Deduplication and Quality

| Field               | Type        | Description                                                               |
| ------------------- | ----------- | ------------------------------------------------------------------------- |
| `master_product_id` | **UUID**    | Unified product ID representing deduplicated variants of the same product |
| `is_duplicate`      | **BOOLEAN** | Indicates whether the product is a duplicate of an existing item          |
| `confidence_score`  | **FLOAT**   | Confidence score (0–1) indicating certainty in the standardization        |

## Metadata

| Field        | Type          | Description                                   |
| ------------ | ------------- | --------------------------------------------- |
| `created_at` | **TIMESTAMP** | Timestamp when the product was processed      |
| `updated_at` | **TIMESTAMP** | Last updated time for the standardized record |

***

<LastUpdatedFr date="2025-11-18" />