# article_embedding_chunks

## Description

<details>
<summary><strong>Table Definition</strong></summary>

```sql
CREATE TABLE `article_embedding_chunks` (
  `chunk_id` char(36) NOT NULL DEFAULT (uuid()),
  `article_id` char(36) NOT NULL,
  `chunk_index` int unsigned NOT NULL,
  `heading` varchar(1000) DEFAULT NULL,
  `content` longtext NOT NULL,
  `token_count` int unsigned NOT NULL,
  `chunking_version` varchar(64) NOT NULL,
  `source_hash` char(64) NOT NULL,
  `embedding` vector(2048) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`chunk_id`) /*T![clustered_index] CLUSTERED */,
  UNIQUE KEY `uq_article_embedding_chunks_article_index` (`article_id`,`chunk_index`),
  VECTOR INDEX `idx_article_embedding_chunks_embedding`((VEC_COSINE_DISTANCE(`embedding`)))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
```

</details>

## Columns

| Name             | Type          | Default              | Nullable | Extra Definition  | Children | Parents | Comment |
| ---------------- | ------------- | -------------------- | -------- | ----------------- | -------- | ------- | ------- |
| chunk_id         | char(36)      | uuid()               | false    | DEFAULT_GENERATED |          |         |         |
| article_id       | char(36)      |                      | false    |                   |          |         |         |
| chunk_index      | int unsigned  |                      | false    |                   |          |         |         |
| heading          | varchar(1000) |                      | true     |                   |          |         |         |
| content          | longtext      |                      | false    |                   |          |         |         |
| token_count      | int unsigned  |                      | false    |                   |          |         |         |
| chunking_version | varchar(64)   |                      | false    |                   |          |         |         |
| source_hash      | char(64)      |                      | false    |                   |          |         |         |
| embedding        | vector(2048)  |                      | false    |                   |          |         |         |
| created_at       | datetime(6)   | CURRENT_TIMESTAMP(6) | false    |                   |          |         |         |

## Constraints

| Name                                      | Type        | Definition                                                                     |
| ----------------------------------------- | ----------- | ------------------------------------------------------------------------------ |
| PRIMARY                                   | PRIMARY KEY | PRIMARY KEY (chunk_id)                                                         |
| uq_article_embedding_chunks_article_index | UNIQUE      | UNIQUE KEY uq_article_embedding_chunks_article_index (article_id, chunk_index) |

## Indexes

| Name                                      | Definition                                                                                 |
| ----------------------------------------- | ------------------------------------------------------------------------------------------ |
| PRIMARY                                   | PRIMARY KEY (chunk_id) USING BTREE                                                         |
| uq_article_embedding_chunks_article_index | UNIQUE KEY uq_article_embedding_chunks_article_index (article_id, chunk_index) USING BTREE |
| idx_article_embedding_chunks_embedding    | KEY idx_article_embedding_chunks_embedding (embedding) USING BTREE                         |

## Relations

```mermaid
erDiagram


"article_embedding_chunks" {
  char_36_ chunk_id PK
}
```

---

> Generated by [tbls](https://github.com/k1LoW/tbls)