subscription_prepaid
Prepaid blocks added to subscriptions. Lists their current consumption state, up to date to the last billing run.
| Column name | Description | Data type |
|---|---|---|
| company | Reference to company.
Reference to prepaid_type. Reference to prepaid_voucher. |
smallint |
| prepaid | Primary key. | integer |
| subscription | Reference to subscription. | integer |
| prepaid_type | Reference to prepaid_type. | character varying (8) * |
| units_purchased | numeric (23,3) | |
| unit_used | numeric (23,3) | |
| start_time | timestamp with time zone * | |
| end_time | timestamp with time zone * | |
| creation_time | timestamp without time zone * | |
| purchase_price | numeric (10,2) * | |
| payment | Reference to payment. | integer * |
| prepaid_voucher | Reference to prepaid_voucher. | text * |