# legacy_contract

## Description

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

```sql
CREATE TABLE `legacy_contract` (
  `legacy_contract_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `contract_id` mediumint unsigned NOT NULL,
  `oa_contract_id` int DEFAULT NULL,
  PRIMARY KEY (`legacy_contract_id`),
  UNIQUE KEY `unique_legacy_contract` (`contract_id`,`oa_contract_id`),
  KEY `fk_legacy_contract_contract` (`contract_id`),
  KEY `idx_oa_contract_id` (`oa_contract_id`),
  CONSTRAINT `fk_legacy_contract_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_id        | mediumint unsigned |         | false    |                  |          | [contract](contract.md) |         |
| legacy_contract_id | mediumint unsigned |         | false    | auto_increment   |          |                         |         |
| oa_contract_id     | int                |         | true     |                  |          |                         |         |

## Constraints

| Name                        | Type        | Definition                                                      |
| --------------------------- | ----------- | --------------------------------------------------------------- |
| PRIMARY                     | PRIMARY KEY | PRIMARY KEY (legacy_contract_id)                                |
| fk_legacy_contract_contract | FOREIGN KEY | FOREIGN KEY (contract_id) REFERENCES contract (contract_id)     |
| unique_legacy_contract      | UNIQUE      | UNIQUE KEY unique_legacy_contract (contract_id, oa_contract_id) |

## Indexes

| Name                        | Definition                                                                  |
| --------------------------- | --------------------------------------------------------------------------- |
| PRIMARY                     | PRIMARY KEY (legacy_contract_id) USING BTREE                                |
| fk_legacy_contract_contract | KEY fk_legacy_contract_contract (contract_id) USING BTREE                   |
| idx_oa_contract_id          | KEY idx_oa_contract_id (oa_contract_id) USING BTREE                         |
| unique_legacy_contract      | UNIQUE KEY unique_legacy_contract (contract_id, oa_contract_id) USING BTREE |

## Relations

![er](legacy_contract.svg)

---

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