Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| payment_id | int8 | 19 | null |
|
|
||||||
| bank_name | varchar | 100 | √ | null |
|
|
|||||
| id_code | varchar | 2147483647 | √ | null |
|
|
|||||
| origin_account | varchar | 50 | √ | null |
|
|
|||||
| mp_payment_id | int8 | 19 | √ | null |
|
|
|||||
| mp_bank_transfer_id | varchar | 50 | √ | null |
|
|
|||||
| financial_institution | varchar | 100 | √ | null |
|
|
|||||
| payment_method_id | varchar | 30 | √ | null |
|
|
|||||
| status | varchar | 30 | √ | null |
|
|
|||||
| status_detail | varchar | 50 | √ | null |
|
|
|||||
| date_approved | timestamptz | 35,6 | √ | null |
|
|
|||||
| payer_identification_type | varchar | 10 | √ | null |
|
|
|||||
| payer_identification_number | varchar | 20 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| payment_transfer_detail_pkey | Primary key | Asc | payment_id |
| payment_transfer_detail_mp_payment_id_key | Must be unique | Asc | mp_payment_id |

