# reference_payoneer_program

## Description

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

```sql
CREATE TABLE `reference_payoneer_program` (
  `payoneer_program_id` int unsigned NOT NULL,
  `payoneer_program_name` varchar(255) NOT NULL,
  `funding_currency` char(3) NOT NULL,
  `reference_payment_type_id` smallint unsigned NOT NULL,
  PRIMARY KEY (`payoneer_program_id`),
  KEY `fk_reference_payoneer_program_reference_payment_type_id` (`reference_payment_type_id`),
  CONSTRAINT `fk_reference_payoneer_program_reference_payment_type_id` FOREIGN KEY (`reference_payment_type_id`) REFERENCES `reference_payment_type` (`reference_payment_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
```

</details>

## Columns

| Name                      | Type              | Default | Nullable | Children                                                                                                                                                                                                                                                  | Parents                                             | Comment |
| ------------------------- | ----------------- | ------- | -------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------- | ------- |
| funding_currency          | char(3)           |         | false    |                                                                                                                                                                                                                                                           |                                                     |         |
| payoneer_program_id       | int unsigned      |         | false    | [account_payee](account_payee.md) [payee](payee.md) [payment_entity_payoneer_program](payment_entity_payoneer_program.md) [payment_group_payment_account](payment_group_payment_account.md) [payment_group_payment_batch](payment_group_payment_batch.md) |                                                     |         |
| payoneer_program_name     | varchar(255)      |         | false    |                                                                                                                                                                                                                                                           |                                                     |         |
| reference_payment_type_id | smallint unsigned |         | false    |                                                                                                                                                                                                                                                           | [reference_payment_type](reference_payment_type.md) |         |

## Constraints

| Name                                                    | Type        | Definition                                                                                            |
| ------------------------------------------------------- | ----------- | ----------------------------------------------------------------------------------------------------- |
| PRIMARY                                                 | PRIMARY KEY | PRIMARY KEY (payoneer_program_id)                                                                     |
| fk_reference_payoneer_program_reference_payment_type_id | FOREIGN KEY | FOREIGN KEY (reference_payment_type_id) REFERENCES reference_payment_type (reference_payment_type_id) |

## Indexes

| Name                                                    | Definition                                                                                          |
| ------------------------------------------------------- | --------------------------------------------------------------------------------------------------- |
| PRIMARY                                                 | PRIMARY KEY (payoneer_program_id) USING BTREE                                                       |
| fk_reference_payoneer_program_reference_payment_type_id | KEY fk_reference_payoneer_program_reference_payment_type_id (reference_payment_type_id) USING BTREE |

## Relations

![er](reference_payoneer_program.svg)

---

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