# batch_histo

### Description

table d'historique de lancement des jobs

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_batch_histo | INT | 10 |  | √ | null |  |  | identifiant de l'historique
cod_batch | VARCHAR | 30 |  |  | null |  |
batch.cod_batch | fk_batch_histo_batch_cod_batch R
| code du batch
date_deb_batch_histo | DATETIME | 19 | √ |  | null |  |  | date de début du batch
date_fin_batch_histo | DATETIME | 19 | √ |  | null |  |  | date de fin de lancement
state_batch_histo | VARCHAR | 10 | √ |  | null |  |  | état du batch
detail_batch_histo | TEXT | 65535 | √ |  | null |  |  | détail de l'historique

Table contained 5 rows

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id_batch_histo
fk_batch_histo_batch_cod_batch | Performance | Asc | cod_batch

### Relationships