orientdb {db=mobile}> desc cdr_eno_20170312 CLASS 'cdr_eno_20170312' Records..............: 135876001 Default cluster......: cl_cdr_eno_20170312_p0 (id=453) Supported clusters...: cl_cdr_eno_20170312_p0(453), cl_cdr_eno_20170312_p1(454), cl_cdr_eno_20170312_p2(455), cl_cdr_eno_20170312_p3(456), cl_cdr_eno_20170312_p4(457), cl_cdr_eno_20170312_p5(458) Cluster selection....: round-robin Oversize.............: 0.0 PROPERTIES +----+---------------------------+--------+-----------------+---------+--------+--------+----+----+-------+-------+ |# |NAME |TYPE |LINKED-TYPE/CLASS|MANDATORY|READONLY|NOT-NULL|MIN |MAX |COLLATE|DEFAULT| +----+---------------------------+--------+-----------------+---------+--------+--------+----+----+-------+-------+ |0 |CELLIDENTITYMCC |STRING | |true |false |false | | |default| | |1 |INTERMEDIATESEQUENCENUMBER |STRING | |true |false |false | | |default| | |2 |CELLIDENTITYLAC |STRING | |true |false |false | | |default| | |3 |MSCLASSMARK |STRING | |true |false |false | | |default| | |4 |CALLDURATION |STRING | |true |false |false | | |default| | |5 |GENCALLID |STRING | |true |false |false | | |default| | |6 |EXCHANGEID |STRING | |true |false |false | | |default| | |7 |ORIGTERMMSCID |STRING | |true |false |false | | |default| | |8 |SERVEDIMEI |STRING | |true |false |false | | |default| | |9 |USEREMLPPPRIORITY |STRING | |true |false |false | | |default| | |10 |PABXNUMBER |STRING | |true |false |false | | |default| | |11 |CAUSEFORTERMINATION |STRING | |true |false |false | | |default| | |12 |CHARGEINDICATOR |STRING | |true |false |false | | |default| | |13 |TIMEQUALITY |STRING | |true |false |false | | |default| | |14 |ISDNBASICSERVICE |STRING | |true |false |false | | |default| | |15 |OUTGTRUNKGRPNAME |STRING | |true |false |false | | |default| | |16 |CELLIDENTITYCELL |STRING | |true |false |false | | |default| | |17 |SMTRANSMISSIONRESULT |STRING | |true |false |false | | |default| | |18 |SEQUENCENUMBER |STRING | |true |false |false | | |default| | |19 |CELLIDENTITYMNC |STRING | |true |false |false | | |default| | |20 |SUPLLSERV |STRING | |true |false |false | | |default| | |21 |MSACCESSRATE |STRING | |true |false |false | | |default| | |22 |FILENAME |STRING | |true |false |false | | |default| | |23 |RATEINDICATION |STRING | |true |false |false | | |default| | |24 |UNUSEDSS |STRING | |true |false |false | | |default| | |25 |INSERVICEKEY |STRING | |true |false |false | | |default| | |26 |SPEECHCODE |STRING | |true |false |false | | |default| | |27 |OTHERPARTYNUMBER |STRING | |true |false |false | | |default| | |28 |TRANSACTIONIDENTIFICATION |STRING | |true |false |false | | |default| | |29 |SERVEDIMSI |STRING | |true |false |false | | |default| | |30 |INTRANSPAR |STRING | |true |false |false | | |default| | |31 |LOCATIONNUMBER |STRING | |true |false |false | | |default| | |32 |CHARGEBANDNUMBER |STRING | |true |false |false | | |default| | |33 |TRACETYPE |STRING | |true |false |false | | |default| | |34 |INAOC |STRING | |true |false |false | | |default| | |35 |TRACEREFERENCE |STRING | |true |false |false | | |default| | |36 |OTHERPARTYSMS |STRING | |true |false |false | | |default| | |37 |CALLTRANSACTIONTYPE |STRING | |true |false |false | | |default| | |38 |INTGTRUNKGRPNAME |STRING | |true |false |false | | |default| | |39 |CELLIDENTITYFILLER |STRING | |true |false |false | | |default| | |40 |RECORDTYPE |STRING | |true |false |false | | |default| | |41 |ACCESSORYNUMBER |STRING | |true |false |false | | |default| | |42 |SERVEDMSISDN |STRING | |true |false |false | | |default| | |43 |INDIVBEARERSERVICENUMBER |STRING | |true |false |false | | |default| | |44 |OUTGTRUNKGRPCIC |STRING | |true |false |false | | |default| | |45 |OTHERPARTYNUMBERNPI |STRING | |true |false |false | | |default| | |46 |SERVICECENTERADDRESS |STRING | |true |false |false | | |default| | |47 |OTHERPARTYNUMBERTON |STRING | |true |false |false | | |default| | |48 |INDIVIDUALBEARERSERVICETYPE|STRING | |true |false |false | | |default| | |49 |SERVEDMSRN |STRING | |true |false |false | | |default| | |50 |TRANSMISSIONMODE |STRING | |true |false |false | | |default| | |51 |MCRDESTINATIONNUMBERSMS |STRING | |true |false |false | | |default| | |52 |ENV |STRING | |true |false |false | | |default| | |53 |INTGTRUNKGRPCIC |STRING | |true |false |false | | |default| | |54 |RADIONETWORKTYPE |STRING | |true |false |false | | |default| | |55 |INDIVTELESERVICENUMBER |STRING | |true |false |false | | |default| | |56 |DATEFORCHARGING |STRING | |true |false |false | | |default| | |57 |RECORDVERSION |STRING | |true |false |false | | |default| | |58 |INFLAG |STRING | |true |false |false | | |default| | |59 |PARTIALRECORDTYPE |STRING | |true |false |false | | |default| | |60 |OTHERMSRN |STRING | |true |false |false | | |default| | |61 |PRT_DATE |DATETIME| |true |false |false | | |default| | |62 |ORIGTERMBSCID |STRING | |true |false |false | | |default| | +----+---------------------------+--------+-----------------+---------+--------+--------+----+----+-------+-------+ INDEXES (3 altogether) +----+----------------------+---------------------------------------------------------------------------------------------------------------------------+ |# |NAME |PROPERTIES | +----+----------------------+---------------------------------------------------------------------------------------------------------------------------+ |0 |idx_cdr_eno_20170312_3|[SERVEDIMSI,PRT_DATE] | |1 |idx_cdr_eno_20170312_0|[ENV,ORIGTERMMSCID,CALLTRANSACTIONTYPE,SERVEDIMSI,PRT_DATE,OTHERPARTYNUMBER,CALLDURATION,EXCHANGEID,OTHERPARTYSMS,ACCESS...| |2 |idx_cdr_eno_20170312_1|[FILENAME] | +----+----------------------+---------------------------------------------------------------------------------------------------------------------------+