Copyright © 2024, Oracle and/or its affiliates.
Field Index SQL Mapping

Class /zonemap

Object to store information of zones and data contained in zones. A zone can be a geographical location and can have sub-zones. For example, phone numbers and IP addresses can be grouped into zones and zones can form hierarchies. Zonemap is used by the rate plan selector of a product.

Notes

  • This object can be read by the owner or any billing group leader who is an ancestor of the owner.
  • This object can be modified only by the owner.
  • This object can be created by anyone.

Links



Field Index

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
string PIN_FLD_DESCR
string PIN_FLD_NAME
poid PIN_FLD_ACCOUNT_OBJ
enum PIN_FLD_ZONEMAP_SEARCH_TYPE
enum PIN_FLD_ZONEMAP_DATA_TYPE
buffer PIN_FLD_ZONEMAP_DATA_RAW
buffer PIN_FLD_ZONEMAP_DATA_DERIVED


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_DESCR

A brief description of the zonemap object.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 1024 bytes

Links

string PIN_FLD_NAME

Unique name for this zone map. Used to associate the zone map with a certain product.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to the account object that owns this zonemap.

Notes

  • Required on object creation
  • Cannot be modified

Links

enum PIN_FLD_ZONEMAP_SEARCH_TYPE

Field that specifies the search criteria of the data in the zone map. PIN_ZONEMAP_PREFIX specifies prefix search; PIN_ZONEMAP_EXACT specifies whole string match.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_ZONEMAP_DATA_TYPE

Indicators of the zone map data storage schema. For example, value of PIN_ZONEMAP_DATA_FLIST(default) indicates that the zone map is stored as a buffered flist. Value of PIN_ZONEMAP_DATA_XML indicates that the zone map data is stored as a XML document.

Notes

  • Can be specified on object creation
  • Can be modified

Links

buffer PIN_FLD_ZONEMAP_DATA_RAW

Field that stores the zone map data in a buffer in a format dictated by the PIN_FLD_DATA_TYPE field. When the data is extracted from the buffer, it will be in either flist or well-formed XML format.

Notes

  • Can be specified on object creation
  • Can be modified

Links

buffer PIN_FLD_ZONEMAP_DATA_DERIVED

Internal representation of zone map data. The original zone map hierarchy is pre-compiled and re-organized centering around the data so that the search for zone lineage based on a given string will be efficient.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /zonemap zonemap_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
string PIN_FLD_DESCR descr
string PIN_FLD_NAME name
poid PIN_FLD_ACCOUNT_OBJ account_obj*
enum PIN_FLD_ZONEMAP_SEARCH_TYPE zonemap_search_type
enum PIN_FLD_ZONEMAP_DATA_TYPE zonemap_data_type
buffer PIN_FLD_ZONEMAP_DATA_RAW zonemap_data_raw_t zonemap_raw_buffer*
buffer PIN_FLD_ZONEMAP_DATA_DERIVED zonemap_data_derived_t zonemap_derived_buffer*
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