# json_contract_file_import_status

## Description

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

```sql
CREATE TABLE `json_contract_file_import_status` (
  `json_contract_file_import_status_id` int unsigned NOT NULL AUTO_INCREMENT,
  `ingestion_date` datetime NOT NULL,
  `contract_id` int DEFAULT NULL,
  `contract_name` varchar(180) DEFAULT NULL,
  `json_file_s3_path` varchar(1024) NOT NULL,
  `json_file_s3_version_id` varchar(1024) NOT NULL,
  `process_report_file_s3_path` varchar(1024) NOT NULL,
  `import_status` enum('success','partial_success','fail') NOT NULL,
  `failed_entities` varchar(512) DEFAULT NULL,
  `errors` text,
  `overwrite` tinyint(1) NOT NULL,
  `ingestion_duration` decimal(5,2) NOT NULL,
  `aws_username` varchar(256) DEFAULT NULL,
  `import_user` varchar(180) DEFAULT NULL,
  `jira_ticket` varchar(180) DEFAULT NULL,
  `account_id` int DEFAULT NULL,
  `imported_entities` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`json_contract_file_import_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb3
```

</details>

## Columns

| Name                                | Type                                     | Default | Nullable | Extra Definition | Children | Parents                 | Comment |
| ----------------------------------- | ---------------------------------------- | ------- | -------- | ---------------- | -------- | ----------------------- | ------- |
| account_id                          | int                                      |         | true     |                  |          | [account](account.md)   |         |
| aws_username                        | varchar(256)                             |         | true     |                  |          |                         |         |
| contract_id                         | int                                      |         | true     |                  |          | [contract](contract.md) |         |
| contract_name                       | varchar(180)                             |         | true     |                  |          |                         |         |
| errors                              | text                                     |         | true     |                  |          |                         |         |
| failed_entities                     | varchar(512)                             |         | true     |                  |          |                         |         |
| import_status                       | enum('success','partial_success','fail') |         | false    |                  |          |                         |         |
| import_user                         | varchar(180)                             |         | true     |                  |          |                         |         |
| imported_entities                   | varchar(1024)                            |         | true     |                  |          |                         |         |
| ingestion_date                      | datetime                                 |         | false    |                  |          |                         |         |
| ingestion_duration                  | decimal(5,2)                             |         | false    |                  |          |                         |         |
| jira_ticket                         | varchar(180)                             |         | true     |                  |          |                         |         |
| json_contract_file_import_status_id | int unsigned                             |         | false    | auto_increment   |          |                         |         |
| json_file_s3_path                   | varchar(1024)                            |         | false    |                  |          |                         |         |
| json_file_s3_version_id             | varchar(1024)                            |         | false    |                  |          |                         |         |
| overwrite                           | tinyint(1)                               |         | false    |                  |          |                         |         |
| process_report_file_s3_path         | varchar(1024)                            |         | false    |                  |          |                         |         |

## Constraints

| Name    | Type        | Definition                                        |
| ------- | ----------- | ------------------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (json_contract_file_import_status_id) |

## Indexes

| Name    | Definition                                                    |
| ------- | ------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY (json_contract_file_import_status_id) USING BTREE |

## Relations

![er](json_contract_file_import_status.svg)

---

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