Field Index | SQL Mapping |
Type | Field Name | Table | Column Name |
---|---|---|---|
base-class | /history_subscriber_contract | history_subscriber_contract_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_SUBSCRIBER_CONTRACT_OBJ | contract_obj* | |
poid | PIN_FLD_ACCOUNT_OBJ | account_obj* | |
timestamp | PIN_FLD_EFFECTIVE_T | effective_t | |
timestamp | PIN_FLD_CONTRACT_START_T | contract_start_t | |
timestamp | PIN_FLD_CONTRACT_END_T | contract_end_t | |
timestamp | PIN_FLD_EFFECTIVE_END_T | effective_end_t | |
string | PIN_FLD_DESCR | descr | |
int | PIN_FLD_EARLY_TERMINATION_ALLOWED | early_termination_allowed | |
int | PIN_FLD_RENEW_FLAGS | renew_flags | |
string | PIN_FLD_SUBSCRIPTION_TERMS_NAME | subscription_terms_name | |
poid | PIN_FLD_SUBSCRIPTION_TERMS_OBJ | subscription_terms_obj* | |
poid | PIN_FLD_PLAN_CONTRACT_OBJ | plan_contract_obj* | |
poid | PIN_FLD_GROUP_CONTRACT_OBJ | group_contract_obj* | |
poid | PIN_FLD_PRICING_OBJ | pricing_obj* | |
poid | PIN_FLD_AUTO_RENEW_PRICING_OBJ | auto_renew_pricing_obj* | |
poid | PIN_FLD_AUTO_RENEW_SUBS_TERMS_OBJ | auto_renew_subs_terms_obj* | |
timestamp | PIN_FLD_TERMINATION_GRACE_START_T | termination_grace_start_t | |
timestamp | PIN_FLD_TERMINATION_GRACE_END_T | termination_grace_end_t | |
int | PIN_FLD_PACKAGE_ID | package_id | |
enum | PIN_FLD_STATUS | status | |
int | PIN_FLD_CONTRACT_FLAGS | contract_flags | |
int | PIN_FLD_STATUS_FLAGS | status_flags | |
enum | PIN_FLD_PENALTY_OPTIONS | penalty_options | |
decimal | PIN_FLD_PENALTY_AMOUNT | penalty_amount | |
poid | PIN_FLD_PREV_CONTRACT_OBJ | prev_contract_obj* | |
timestamp | PIN_FLD_PREV_CONTRACT_START_T | prev_contract_start_t | |
timestamp | PIN_FLD_PREV_CONTRACT_END_T | prev_contract_end_t | |
poid | PIN_FLD_NEXT_CONTRACT_OBJ | next_contract_obj* | |
timestamp | PIN_FLD_NEXT_CONTRACT_START_T | next_contract_start_t | |
timestamp | PIN_FLD_NEXT_CONTRACT_END_T | next_contract_end_t | |
timestamp | PIN_FLD_MINIMUM_CONTRACT_END_T | minimum_contract_end_t | 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 |