# job_batches

## 概要

<details>
<summary><strong>テーブル定義</strong></summary>

```sql
CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
```

</details>

## カラム一覧

| 名前 | タイプ | デフォルト値 | NULL許可 | 子テーブル | 親テーブル | コメント |
| ---- | ------ | ------------ | -------- | ---------- | ---------- | -------- |
| id | varchar(255) |  | false |  |  |  |
| name | varchar(255) |  | false |  |  |  |
| total_jobs | int |  | false |  |  |  |
| pending_jobs | int |  | false |  |  |  |
| failed_jobs | int |  | false |  |  |  |
| failed_job_ids | longtext |  | false |  |  |  |
| options | mediumtext |  | true |  |  |  |
| cancelled_at | int |  | true |  |  |  |
| created_at | int |  | false |  |  |  |
| finished_at | int |  | true |  |  |  |

## 制約一覧

| 名前 | タイプ | 定義 |
| ---- | ---- | ---------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (id) |

## INDEX一覧

| 名前 | 定義 |
| ---- | ---------- |
| PRIMARY | PRIMARY KEY (id) USING BTREE |

## ER図

![er](job_batches.svg)

---

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