MariaDB [alepopcrf]> show create table sessions; +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | sessions | CREATE TABLE `sessions` ( `SESSIONID` varchar(256) NOT NULL COMMENT 'Subscriber session identifier', `ORIGINHOST` varchar(52) NOT NULL COMMENT 'Remote peer host name', `DESTINATIONHOST` varchar(52) NOT NULL COMMENT 'PCRF server host name', `DESTINATIONREALM` varchar(52) NOT NULL COMMENT 'PCRF server realm name', `ORIGINREALM` varchar(52) NOT NULL COMMENT 'Remote peer realm name', `FRAMEDIPADDRESS` bigint(20) DEFAULT NULL COMMENT 'IP address allocated by PCEF for session (Updated only in parent session)', `STARTDATETIME` datetime NOT NULL COMMENT 'Date and time when session is started', `LASTUPDATETIME` datetime NOT NULL COMMENT 'Date and time when session is last updated', `POLICYNAME` varchar(255) DEFAULT NULL COMMENT 'Policy name assigned to ongoing session', `SUBSCRIPTIONINDEX` int(20) DEFAULT NULL COMMENT 'Subscription identifier', `SUBSCRIBERID` varchar(128) DEFAULT NULL COMMENT 'subscriber identifier', `MSISDN` varchar(16) DEFAULT NULL COMMENT 'MSISDN received in request ', `IMSI` varchar(16) DEFAULT NULL COMMENT 'IMSI received in request ', `SIPURI` varchar(256) DEFAULT NULL COMMENT 'SIP URI received in request', `USERNAI` varchar(256) DEFAULT NULL COMMENT 'USER NAI received in request', `PARENTSESSIONID` varchar(256) DEFAULT NULL COMMENT 'Parent session Idenitifier (Present in child sessions)', `SESSIONSTATUS` int(11) DEFAULT NULL COMMENT '1 - Session is active,2 - Session is inactive', `APPLICATIONID` int(11) NOT NULL DEFAULT 0 COMMENT 'Application Id for reference point (e.g. 16777238)', `ECI` varchar(16) DEFAULT NULL, `USAGEMONITORKEY` varchar(128) DEFAULT NULL, `ACCTINPUTOCTETS` bigint(20) DEFAULT 0, `ACCTOUTPUTOCTETS` bigint(20) DEFAULT 0, `ACCTTOTALOCTETS` bigint(20) DEFAULT 0, `DISCOUNTEDACCTINPUTOCTETS` bigint(20) DEFAULT 0 COMMENT 'Discounted Input Octets in case discount is applied', `DISCOUNTEDACCTOUTPUTOCTETS` bigint(20) DEFAULT 0 COMMENT 'DisCounted output Octets in case of DisCount Applied', `DISCOUNTEDACCTTOTALOCTETS` bigint(20) DEFAULT 0 COMMENT 'DisCounted Total Octets in case of DisCount Applied', `BALANCEDEDUCTEDINLASTSESSION` double DEFAULT 0 COMMENT 'Balance deducted in last session', `BALANCEDEDUCTED` double DEFAULT 0 COMMENT 'Balance dedeucted from external system', `BALANCEADJUSTED` double DEFAULT 0 COMMENT 'Balance adjusted from external system', `LASTQUOTAALLOCATED` double DEFAULT 0 COMMENT 'Quota allocated in latest request', `QUOTACHARGED` bigint(20) DEFAULT 0 COMMENT 'Quota Charge from external system', `REQUESTNUMBER` int(11) NOT NULL DEFAULT 0, `USAGEACCUMULATOR` varchar(255) DEFAULT NULL COMMENT 'Total data usage done within ongoing session', `ASSETNAME` varchar(256) DEFAULT NULL COMMENT 'Stores matched Asset Name-Asset Id', `ASSETDISCOUNT` bigint(20) DEFAULT 0 COMMENT 'Discount Percentage which has to applied', `ACCUMULATORTYPE` varchar(256) DEFAULT NULL COMMENT 'Stores comma separated type for Usage Asset', `CATEGORY` varchar(256) DEFAULT NULL COMMENT 'Stores Policy Types For Speed or Application Category', `IP_CAN_TYPE` int(11) DEFAULT 0 COMMENT 'Stores the type of IP Connectivity Access Network in which the user is connected', `RAT_TYPE` int(11) DEFAULT -1 COMMENT 'Stores Radio Access Type by which the user is connected', `ROLLOVERREFERENCE` varchar(256) DEFAULT NULL COMMENT 'Stores comma separated type for Rollover Indexes reference', `SESSIONEXPIRYTIME` datetime DEFAULT NULL COMMENT 'date and time when session is Supposed to be Expire', `DATAPASSUSED` varchar(256) DEFAULT NULL COMMENT 'Stores data pass usagetransaction index from which quota is allocated', `CUSTOMFIELD1` varchar(16) DEFAULT NULL COMMENT 'generic custom field for project specific implementation', `CUSTOMFIELD2` varchar(16) DEFAULT NULL COMMENT 'generic custom field for project specific implementation', `CUSTOMFIELD3` varchar(16) DEFAULT NULL COMMENT 'generic custom field for project specific implementation', `CUSTOMFIELD4` varchar(16) DEFAULT NULL COMMENT 'generic custom field for project specific implementation', `CUSTOMFIELD5` varchar(16) DEFAULT NULL COMMENT 'generic custom field for project specific implementation', `BEARERIDENTIFIER` varchar(64) DEFAULT NULL COMMENT 'Stores Bearer Identifier value from Request List', `POLICYALLOCATED` varchar(1024) DEFAULT NULL COMMENT 'Stores the Policy Names Used for Install and remove', `CURRENTACCUMULATORUSAGE` bigint(20) DEFAULT 0 COMMENT 'Used when Accumulator EDR is turn on to dump CurrentAccumulatorUsage', `SGSNADDRESS` varchar(64) DEFAULT NULL COMMENT 'Stores 3GPP-SGSN-Address from Request List', `CONGESTIONSTATUS` int(11) DEFAULT NULL, `RXSESSIONID` varchar(256) DEFAULT NULL COMMENT 'Stores reference of RX session Id', `QCI` int(11) DEFAULT 0 COMMENT 'Stores QCI Values for RX/GX Session comes in request', `EMERGENCYSESSION` int(2) DEFAULT 0 COMMENT 'Idendification param for Emergency Session', `CHARGINGTYPE` varchar(16) DEFAULT NULL COMMENT 'Pay As You Go Online Offline Flag', `3GPPRATTYPE` int(11) DEFAULT -1 COMMENT 'Stores 3GPP Radio Access Type by which the user is connected', `DEVICEIDENTIFIER` varchar(120) DEFAULT NULL COMMENT 'Subscriber device identifier', `QUOTACHARGEDEDUCTEDINLASTSESSION` bigint(20) DEFAULT 0 COMMENT 'Balance Charged in last session', `PRODUCTCATALOGUEOFFER` varchar(256) DEFAULT NULL COMMENT 'Stores OfferNames', `PARENTDATAPASS` int(11) DEFAULT 0 COMMENT 'Parent Data Pass Index For Shared Pass', `SERVICEID` int(11) DEFAULT 0, PRIMARY KEY (`SESSIONID`), UNIQUE KEY `UQ_ORIGINREALM_FRAMEDIPADDRESS` (`FRAMEDIPADDRESS`,`ORIGINREALM`), KEY `SESSIONPARENTSESSIONID` (`PARENTSESSIONID`), KEY `SESSIONAPPLICATIONID` (`APPLICATIONID`), KEY `SESSIONLASTUPDATETIME` (`LASTUPDATETIME`), KEY `SESSIONEXPIRYTIME_IDX` (`SESSIONEXPIRYTIME`), KEY `SUBSCRIPTIONINDEX_IDX` (`SUBSCRIPTIONINDEX`), KEY `ORIGINREALM_IDX` (`ORIGINREALM`), KEY `SESSIONSTATUS_IDX` (`SESSIONSTATUS`), KEY `SESSIONSMSISDN_IDX` (`MSISDN`), KEY `SESSION_QCI` (`QCI`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=' THESE TABLE STORES ONGOING GX SESSIONS IN THE DATABASE WITH THE IP ASSIGNED TO SESSION' | +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec)