# report_payment

## Description

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

```sql
CREATE TABLE `report_payment` (
  `report_payment_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `target_type` varchar(64) DEFAULT NULL,
  `target_id` mediumint unsigned NOT NULL,
  `report_type` enum('approval') NOT NULL,
  `report_export_url` varchar(180) NOT NULL,
  `created_by` varchar(180) NOT NULL,
  `created_at` datetime NOT NULL,
  `last_modified_by` varchar(180) NOT NULL,
  `last_modified` datetime NOT NULL,
  PRIMARY KEY (`report_payment_id`),
  UNIQUE KEY `uidx_report_payment` (`target_type`,`target_id`,`report_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
```

</details>

## Columns

| Name              | Type               | Default | Nullable | Extra Definition | Children | Parents | Comment |
| ----------------- | ------------------ | ------- | -------- | ---------------- | -------- | ------- | ------- |
| created_at        | datetime           |         | false    |                  |          |         |         |
| created_by        | varchar(180)       |         | false    |                  |          |         |         |
| last_modified     | datetime           |         | false    |                  |          |         |         |
| last_modified_by  | varchar(180)       |         | false    |                  |          |         |         |
| report_export_url | varchar(180)       |         | false    |                  |          |         |         |
| report_payment_id | mediumint unsigned |         | false    | auto_increment   |          |         |         |
| report_type       | enum('approval')   |         | false    |                  |          |         |         |
| target_id         | mediumint unsigned |         | false    |                  |          |         |         |
| target_type       | varchar(64)        |         | true     |                  |          |         |         |

## Constraints

| Name                | Type        | Definition                                                           |
| ------------------- | ----------- | -------------------------------------------------------------------- |
| PRIMARY             | PRIMARY KEY | PRIMARY KEY (report_payment_id)                                      |
| uidx_report_payment | UNIQUE      | UNIQUE KEY uidx_report_payment (target_type, target_id, report_type) |

## Indexes

| Name                | Definition                                                                       |
| ------------------- | -------------------------------------------------------------------------------- |
| PRIMARY             | PRIMARY KEY (report_payment_id) USING BTREE                                      |
| uidx_report_payment | UNIQUE KEY uidx_report_payment (target_type, target_id, report_type) USING BTREE |

## Relations

![er](report_payment.svg)

---

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