| Field Index | SQL Mapping |
| Type | Field Name |
|---|---|
| poid | PIN_FLD_POID |
| timestamp | PIN_FLD_CREATED_T |
| timestamp | PIN_FLD_MOD_T |
| string | PIN_FLD_READ_ACCESS |
| string | PIN_FLD_WRITE_ACCESS |
| string | PIN_FLD_CREATE_ACCESS |
| poid | PIN_FLD_ACCOUNT_OBJ |
| decimal | PIN_FLD_CYCLE_TOPPED_AMT |
| timestamp | PIN_FLD_LAST_TOPUP_T |
| poid | PIN_FLD_PAYINFO_OBJ |
| decimal | PIN_FLD_TOPUP_AMT |
| decimal | PIN_FLD_TOPUP_CAP |
| poid | PIN_FLD_GROUP_OBJ |
| poid | PIN_FLD_BILLINFO_OBJ |
| int | PIN_FLD_GROUP_INDEX |
| int | PIN_FLD_RESOURCE_ID |
| int | PIN_FLD_TOPUP_INTERVAL |
| timestamp | PIN_FLD_NEXT_TOPUP_T |
| int | PIN_FLD_NUM_TOPUPS |
| int | PIN_FLD_NUM_TOPUPS_DONE |
| enum | PIN_FLD_STATUS |
| poid | PIN_FLD_BAL_GRP_OBJ |
| enum | PIN_FLD_TYPE |
| Type | Field Name | Table | Column Name |
|---|---|---|---|
| base-class | /topup | topup_t | |
| poid | PIN_FLD_POID | poid* | |
| timestamp | PIN_FLD_CREATED_T | created_t | |
| timestamp | PIN_FLD_MOD_T | mod_t | |
| string | PIN_FLD_READ_ACCESS | read_access | |
| string | PIN_FLD_WRITE_ACCESS | wrtie_access | |
| string | PIN_FLD_CREATE_ACCESS | create_access | |
| poid | PIN_FLD_ACCOUNT_OBJ | account_obj* | |
| decimal | PIN_FLD_CYCLE_TOPPED_AMT | cycle_topped_amt | |
| timestamp | PIN_FLD_LAST_TOPUP_T | last_topup_t | |
| poid | PIN_FLD_PAYINFO_OBJ | payinfo_obj* | |
| decimal | PIN_FLD_TOPUP_AMT | topup_amt | |
| decimal | PIN_FLD_TOPUP_CAP | topup_cap | |
| poid | PIN_FLD_GROUP_OBJ | group_obj* | |
| poid | PIN_FLD_BILLINFO_OBJ | billinfo_obj* | |
| int | PIN_FLD_GROUP_INDEX | group_index | |
| int | PIN_FLD_RESOURCE_ID | resource_id | |
| int | PIN_FLD_TOPUP_INTERVAL | topup_interval | |
| timestamp | PIN_FLD_NEXT_TOPUP_T | next_topup_t | |
| int | PIN_FLD_NUM_TOPUPS | num_topups | |
| int | PIN_FLD_NUM_TOPUPS_DONE | topups_done | |
| enum | PIN_FLD_STATUS | status | |
| poid | PIN_FLD_BAL_GRP_OBJ | bal_grp_obj* | |
| enum | PIN_FLD_TYPE | topup_type | Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size. |
| Field Index | This Class |