Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||
| tenant_id | VARCHAR | 36 | null |
|
|
|||
| transaction_type | VARCHAR | 40 | null |
|
|
|||
| amount_signed | DECIMAL | 14,2 | null |
|
|
|||
| currency | VARCHAR | 3 | USD |
|
|
|||
| status | VARCHAR | 20 | POSTED |
|
|
|||
| occurred_at | DATETIME | 26 | null |
|
|
|||
| reference_type | VARCHAR | 40 | √ | null |
|
|
||
| reference_id | VARCHAR | 36 | √ | null |
|
|
||
| claim_id | VARCHAR | 36 | √ | null |
|
|
||
| batch_id | VARCHAR | 36 | √ | null |
|
|
||
| invoice_id | VARCHAR | 36 | √ | null |
|
|
||
| remittance_id | VARCHAR | 36 | √ | null |
|
|
||
| payer_id | VARCHAR | 36 | √ | null |
|
|
||
| client_id | VARCHAR | 36 | √ | null |
|
|
||
| encounter_id | VARCHAR | 36 | √ | null |
|
|
||
| staff_user_id | VARCHAR | 36 | √ | null |
|
|
||
| external_reference | VARCHAR | 120 | √ | null |
|
|
||
| source_system | VARCHAR | 60 | √ | null |
|
|
||
| metadata_json | LONGTEXT | 2147483647 | √ | null |
|
|
||
| created_at | DATETIME | 26 | CURRENT_TIMESTAMP(6) |
|
|
|||
| updated_at | DATETIME | 26 | √ | null |
|
|
||
| created_by | VARCHAR | 255 | √ | null |
|
|
||
| updated_by | VARCHAR | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_billing_tx_batch | Performance | Asc | batch_id |
| idx_billing_tx_claim | Performance | Asc | claim_id |
| idx_billing_tx_client | Performance | Asc | client_id |
| idx_billing_tx_invoice | Performance | Asc | invoice_id |
| idx_billing_tx_payer | Performance | Asc | payer_id |
| idx_billing_tx_reference | Performance | Asc/Asc | reference_type + reference_id |
| idx_billing_tx_remittance | Performance | Asc | remittance_id |
| idx_billing_tx_staff_user | Performance | Asc | staff_user_id |
| idx_billing_tx_tenant_date | Performance | Asc/Asc | tenant_id + occurred_at |
| idx_billing_tx_type | Performance | Asc | transaction_type |