DICO_RES

Definition

The DICO_RES table contains information about reservations of quota made on distributed counters

Description

The DICO_RES table contains the values of the reservations of quota made on distributed counters. Each reservation has a lifetime that corresponds to the lifetime of the related charging operation or charging session.

Technical Data

Schema Version	5.0.6
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The DICO_RES table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
OID	PK_DICO_RES					The identifier of the reservation of quota made on the distributed counter
ALLO_OID				ALLO (OID)		The identifier of the shared allowance holding the distributed counter concerned by the reservation of quota
HOLD_OID						The identifier of the holder of the reservation made on the distributed counter More...
COUN_KEY				COUNTER (COUN_KEY)		The identification key of the distributed counter concerned by the reservation of quota
ALLO_PARTITION_ID	PK_DICO_RES					The identifier of the database partition that contains the shared allowance holding the distributed counter concerned by the reservation of quota
SUAC_OID	PK_DICO_RES			SUBSCRIBER_ACCOUNT (OID)		The identifier of the subscriber account related to the reservation of quota
PARTITION_ID	PK_DICO_RES					The identifier of the database partition that contains the subscriber account related to the reservation of quota
DICO_TYPE						The DICO_TYPE field indicates if the distributed counter is an increment or a decrement counter More...
CCN						Commit Change Number of the subscriber account related the reservation of quota
VALUE						The quantity of reserved quota

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The identifier of the reservation of quota made on the distributed counter
Type	DECIMAL(28), NOT NULL
Primary Key	PK_DICO_RES

ALLO_OID

Definition	The identifier of the shared allowance holding the distributed counter concerned by the reservation of quota
Type	DECIMAL(28), NOT NULL

HOLD_OID

Definition	The identifier of the holder of the reservation made on the distributed counter
Description	The identifier of the holder of the reservation made on the distributed counter, that can be: A charge activation of an allowance An allowance
Type	DECIMAL(28), NOT NULL

COUN_KEY

Definition	The identification key of the distributed counter concerned by the reservation of quota
Type	DECIMAL(28), NOT NULL

ALLO_PARTITION_ID

Definition	The identifier of the database partition that contains the shared allowance holding the distributed counter concerned by the reservation of quota
Type	DECIMAL(4), NOT NULL
Primary Key	PK_DICO_RES

SUAC_OID

Definition	The identifier of the subscriber account related to the reservation of quota
Type	DECIMAL(28), NOT NULL
Primary Key	PK_DICO_RES

PARTITION_ID

Definition	The identifier of the database partition that contains the subscriber account related to the reservation of quota
Type	DECIMAL(4), NOT NULL
Primary Key	PK_DICO_RES

DICO_TYPE

Definition	The DICO_TYPE field indicates if the distributed counter is an increment or a decrement counter
Format	The possible values are: 0: Decrement counter 1: Increment counter
Type	DECIMAL(1), NOT NULL
Default	0

CCN

Definition	Commit Change Number of the subscriber account related the reservation of quota
Type	DECIMAL(28), NOT NULL

VALUE

Definition	The quantity of reserved quota
Type	DECIMAL(28,6), NULL

Primary Key Details

See the primary key information:

PK_DICO_RES

Column(s)	ALLO_PARTITION_ID,PARTITION_ID,SUAC_OID,OID
Segment	COUNTER_INDX