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 |
string | PIN_FLD_DESCR |
timestamp | PIN_FLD_END_T |
int | PIN_FLD_FLAGS |
string | PIN_FLD_NAME |
string | PIN_FLD_CODE |
string | PIN_FLD_PERMITTED |
array | PIN_FLD_PRODUCTS |
decimal | |
timestamp | |
int | |
timestamp | |
int | |
poid | |
decimal | |
timestamp | |
int | |
timestamp | |
int | |
decimal | |
enum | |
int | |
decimal | |
timestamp | |
int | |
timestamp | |
int | |
enum | |
int | |
int | |
int | |
poid | |
array | PIN_FLD_DISCOUNTS |
timestamp | |
int | |
timestamp | |
int | |
poid | |
timestamp | |
int | |
timestamp | |
int | |
decimal | |
enum | |
int | |
timestamp | |
int | |
timestamp | |
int | |
enum | |
int | |
timestamp | PIN_FLD_START_T |
poid | PIN_FLD_SUBSCRIPTION_TERMS_OBJ |
poid | PIN_FLD_ATTRIBUTE_OBJ |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /deal | deal_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* | |
string | PIN_FLD_DESCR | descr | |
timestamp | PIN_FLD_END_T | end_t | |
int | PIN_FLD_FLAGS | flags | |
string | PIN_FLD_NAME | name | |
string | PIN_FLD_CODE | code | |
string | PIN_FLD_PERMITTED | permitted | |
array | PIN_FLD_PRODUCTS | deal_products_t | |
decimal |
PIN_FLD_CYCLE_DISCOUNT
|
cycle_discount | |
timestamp |
PIN_FLD_CYCLE_END_T
|
cycle_end_t | |
int |
PIN_FLD_CYCLE_END_DETAILS
|
cycle_end_details | |
timestamp |
PIN_FLD_CYCLE_START_T
|
cycle_start_t | |
int |
PIN_FLD_CYCLE_START_DETAILS
|
cycle_start_details | |
poid |
PIN_FLD_PRODUCT_OBJ
|
product_obj* | |
decimal |
PIN_FLD_PURCHASE_DISCOUNT
|
purchase_discount | |
timestamp |
PIN_FLD_PURCHASE_END_T
|
purchase_end_t | |
int |
PIN_FLD_PURCHASE_END_DETAILS
|
purchase_end_details | |
timestamp |
PIN_FLD_PURCHASE_START_T
|
purchase_start_t | |
int |
PIN_FLD_PURCHASE_START_DETAILS
|
purchase_start_details | |
decimal |
PIN_FLD_QUANTITY
|
quantity | |
enum |
PIN_FLD_STATUS
|
status | |
int |
PIN_FLD_STATUS_FLAGS
|
status_flags | |
decimal |
PIN_FLD_USAGE_DISCOUNT
|
usage_discount | |
timestamp |
PIN_FLD_USAGE_END_T
|
usage_end_t | |
int |
PIN_FLD_USAGE_END_DETAILS
|
usage_end_details | |
timestamp |
PIN_FLD_USAGE_START_T
|
usage_start_t | |
int |
PIN_FLD_USAGE_START_DETAILS
|
usage_start_details | |
enum |
PIN_FLD_MODE
|
purchase_mode | |
int |
PIN_FLD_GRACE_PERIOD
|
grace_period | |
int |
PIN_FLD_RENEWAL_MODE
|
renewal_mode | |
int |
PIN_FLD_FLAGS
|
flags | |
poid |
PIN_FLD_BASE_PRODUCT_OBJ
|
base_product_obj* | |
array | PIN_FLD_DISCOUNTS | deal_discounts_t | |
timestamp |
PIN_FLD_CYCLE_END_T
|
cycle_end_t | |
int |
PIN_FLD_CYCLE_END_DETAILS
|
cycle_end_details | |
timestamp |
PIN_FLD_CYCLE_START_T
|
cycle_start_t | |
int |
PIN_FLD_CYCLE_START_DETAILS
|
cycle_start_details | |
poid |
PIN_FLD_DISCOUNT_OBJ
|
discount_obj* | |
timestamp |
PIN_FLD_PURCHASE_END_T
|
purchase_end_t | |
int |
PIN_FLD_PURCHASE_END_DETAILS
|
purchase_end_details | |
timestamp |
PIN_FLD_PURCHASE_START_T
|
purchase_start_t | |
int |
PIN_FLD_PURCHASE_START_DETAILS
|
purchase_start_details | |
decimal |
PIN_FLD_QUANTITY
|
quantity | |
enum |
PIN_FLD_STATUS
|
status | |
int |
PIN_FLD_STATUS_FLAGS
|
status_flags | |
timestamp |
PIN_FLD_USAGE_END_T
|
usage_end_t | |
int |
PIN_FLD_USAGE_END_DETAILS
|
usage_end_details | |
timestamp |
PIN_FLD_USAGE_START_T
|
usage_start_t | |
int |
PIN_FLD_USAGE_START_DETAILS
|
usage_start_details | |
enum |
PIN_FLD_MODE
|
purchase_mode | |
int |
PIN_FLD_GRACE_PERIOD
|
grace_period | |
timestamp | PIN_FLD_START_T | start_t | |
poid | PIN_FLD_SUBSCRIPTION_TERMS_OBJ | subscription_terms_obj* | |
poid | PIN_FLD_ATTRIBUTE_OBJ | attribute_obj* | 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 |