Detalhes da Tabela
venda_parcela | Database: devprojetos_emissor | Conexão: Teste migração
Estrutura da Tabela
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| idParcela | int(11) | NO | |||
| vendaId | int(11) | NO | |||
| parcelaNumero | varchar(5) | NO | |||
| pagamentoTipo | tinyint(4) | NO | |||
| valor | decimal(10,2) | NO | |||
| vencimento | date | NO | |||
| chequeId | smallint(6) | YES | |||
| boletoId | int(11) | YES | |||
| dataCadastro | timestamp | NO | CURRENT_TIMESTAMP | ||
| pago | tinyint(1) | NO | 0 | ||
| mpPagamentoId | int(11) | YES |
Dados da Tabela (máx. 100 linhas)
| idParcela | vendaId | parcelaNumero | pagamentoTipo | valor | vencimento | chequeId | boletoId | dataCadastro | pago | mpPagamentoId |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 52.50 | 2025-10-22 | 2025-10-22 14:06:21 | 0 | |||
| 2 | 3 | 1 | 1 | 21.00 | 2025-12-01 | 2025-12-01 18:22:37 | 0 | |||
| 3 | 4 | 1 | 8 | 14.00 | 2025-12-01 | 2025-12-01 18:46:01 | 1 | |||
| 4 | 6 | 1 | 1 | 240.00 | 2026-05-19 | 2026-05-19 22:03:02 | 0 | |||
| 5 | 7 | 1 | 1 | 200.00 | 2026-05-19 | 2026-05-19 23:29:47 | 0 | |||
| 1 | 1 | 1 | 1 | 52.50 | 2025-10-22 | 2025-10-22 14:06:21 | 0 | |||
| 2 | 3 | 1 | 1 | 21.00 | 2025-12-01 | 2025-12-01 18:22:37 | 0 | |||
| 3 | 4 | 1 | 8 | 14.00 | 2025-12-01 | 2025-12-01 18:46:01 | 1 | |||
| 4 | 6 | 1 | 1 | 240.00 | 2026-05-19 | 2026-05-19 22:03:02 | 0 | |||
| 5 | 7 | 1 | 1 | 200.00 | 2026-05-19 | 2026-05-19 23:29:47 | 0 | |||
| 1 | 1 | 1 | 1 | 52.50 | 2025-10-22 | 2025-10-22 14:06:21 | 0 | |||
| 2 | 3 | 1 | 1 | 21.00 | 2025-12-01 | 2025-12-01 18:22:37 | 0 | |||
| 3 | 4 | 1 | 8 | 14.00 | 2025-12-01 | 2025-12-01 18:46:01 | 1 | |||
| 4 | 6 | 1 | 1 | 240.00 | 2026-05-19 | 2026-05-19 22:03:02 | 0 | |||
| 5 | 7 | 1 | 1 | 200.00 | 2026-05-19 | 2026-05-19 23:29:47 | 0 |