# contract_exclusion

## Description

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

```sql
CREATE TABLE `contract_exclusion` (
  `contract_exclusion_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `contract_id` mediumint unsigned NOT NULL,
  `exclusions` json NOT NULL,
  PRIMARY KEY (`contract_exclusion_id`),
  UNIQUE KEY `uidx_contract_id` (`contract_id`),
  CONSTRAINT `fk_contract_exclusion_contract` FOREIGN KEY (`contract_id`) REFERENCES `contract` (`contract_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```

</details>

## Columns

| Name                  | Type               | Default | Nullable | Extra Definition | Children | Parents                 | Comment |
| --------------------- | ------------------ | ------- | -------- | ---------------- | -------- | ----------------------- | ------- |
| contract_exclusion_id | mediumint unsigned |         | false    | auto_increment   |          |                         |         |
| contract_id           | mediumint unsigned |         | false    |                  |          | [contract](contract.md) |         |
| exclusions            | json               |         | false    |                  |          |                         |         |

## Constraints

| Name                           | Type        | Definition                                                  |
| ------------------------------ | ----------- | ----------------------------------------------------------- |
| PRIMARY                        | PRIMARY KEY | PRIMARY KEY (contract_exclusion_id)                         |
| fk_contract_exclusion_contract | FOREIGN KEY | FOREIGN KEY (contract_id) REFERENCES contract (contract_id) |
| uidx_contract_id               | UNIQUE      | UNIQUE KEY uidx_contract_id (contract_id)                   |

## Indexes

| Name             | Definition                                            |
| ---------------- | ----------------------------------------------------- |
| PRIMARY          | PRIMARY KEY (contract_exclusion_id) USING BTREE       |
| uidx_contract_id | UNIQUE KEY uidx_contract_id (contract_id) USING BTREE |

## Relations

![er](contract_exclusion.svg)

---

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