# reference_signing_entity

## Description

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

```sql
CREATE TABLE `reference_signing_entity` (
  `reference_signing_entity_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `reference_payment_entity_id` mediumint unsigned NOT NULL,
  `company_code` varchar(8) COLLATE utf8mb4_general_ci NOT NULL,
  `tax_entity_company_code` varchar(8) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_name` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
  `vat_number` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `company_registration_number` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(180) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reference_sap_profit_center_id` mediumint unsigned NOT NULL,
  PRIMARY KEY (`reference_signing_entity_id`),
  KEY `fk_reference_signing_entity_payment_entity` (`reference_payment_entity_id`),
  KEY `fk_reference_sap_profit_center_signing_entity` (`reference_sap_profit_center_id`),
  CONSTRAINT `fk_reference_sap_profit_center_signing_entity` FOREIGN KEY (`reference_sap_profit_center_id`) REFERENCES `reference_sap_profit_center` (`reference_sap_profit_center_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_reference_signing_entity_payment_entity` FOREIGN KEY (`reference_payment_entity_id`) REFERENCES `reference_payment_entity` (`reference_payment_entity_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 |
| ------------------------------ | ------------------ | ------- | -------- | ---------------- | --------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------- | ------- |
| address                        | varchar(180)       |         | true     |                  |                                                                                                           |                                                               |         |
| company_code                   | varchar(8)         |         | false    |                  |                                                                                                           |                                                               |         |
| company_registration_number    | varchar(30)        |         | true     |                  |                                                                                                           |                                                               |         |
| legal_name                     | varchar(180)       |         | false    |                  |                                                                                                           |                                                               |         |
| reference_payment_entity_id    | mediumint unsigned |         | false    |                  |                                                                                                           | [reference_payment_entity](reference_payment_entity.md)       |         |
| reference_sap_profit_center_id | mediumint unsigned |         | false    |                  |                                                                                                           | [reference_sap_profit_center](reference_sap_profit_center.md) |         |
| reference_signing_entity_id    | mediumint unsigned |         | false    | auto_increment   | [contract](contract.md) [contract_history](contract_history.md) [contract_template](contract_template.md) |                                                               |         |
| tax_entity_company_code        | varchar(8)         |         | true     |                  |                                                                                                           |                                                               |         |
| vat_number                     | varchar(30)        |         | true     |                  |                                                                                                           |                                                               |         |

## Constraints

| Name                                          | Type        | Definition                                                                                                           |
| --------------------------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------- |
| PRIMARY                                       | PRIMARY KEY | PRIMARY KEY (reference_signing_entity_id)                                                                            |
| fk_reference_sap_profit_center_signing_entity | FOREIGN KEY | FOREIGN KEY (reference_sap_profit_center_id) REFERENCES reference_sap_profit_center (reference_sap_profit_center_id) |
| fk_reference_signing_entity_payment_entity    | FOREIGN KEY | FOREIGN KEY (reference_payment_entity_id) REFERENCES reference_payment_entity (reference_payment_entity_id)          |

## Indexes

| Name                                          | Definition                                                                                     |
| --------------------------------------------- | ---------------------------------------------------------------------------------------------- |
| PRIMARY                                       | PRIMARY KEY (reference_signing_entity_id) USING BTREE                                          |
| fk_reference_sap_profit_center_signing_entity | KEY fk_reference_sap_profit_center_signing_entity (reference_sap_profit_center_id) USING BTREE |
| fk_reference_signing_entity_payment_entity    | KEY fk_reference_signing_entity_payment_entity (reference_payment_entity_id) USING BTREE       |

## Relations

![er](reference_signing_entity.svg)

---

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