预拨号predialtask表说明.sql

用于收费语音服务的电话充值业务

SQL> desc predialtask
Name             Type          Nullable Default Comments
---------------- ------------- -------- ------- --------
SERIALNUM        VARCHAR2(20)
CALLORDER        NUMBER
SERVICEBEGINTIME VARCHAR2(20)
SERVICESTOPTIME  VARCHAR2(20)
DIALBEGINTIME    VARCHAR2(20)
DIALENDTIME      VARCHAR2(20)
TIMEINTERVAL     NUMBER        Y        0
INTERVALTYPE     NUMBER        Y        0
CALLER           VARCHAR2(20)
ORIGCALLER       VARCHAR2(20)
CALLED           VARCHAR2(20)
ORIGCALLED       VARCHAR2(20)
PRIVATEDATA      VARCHAR2(255)
USERDATA         VARCHAR2(255) Y
DEFAULTINTERVAL  NUMBER                 3
REDIALINTERVAL   VARCHAR2(255) Y
REDIALCOUNT      NUMBER                 5
TYPE             NUMBER
SERVICEID        NUMBER
ANSWERTYPE       NUMBER
PRIORITY         NUMBER
STATUS           NUMBER

SQL> select *from predialtask;

SERIALNUM                                          CALLORDER SERVICEBEGINTIME     SERVICESTOPTIME      DIALBEGINTIME        DIALENDTIME                                     TIMEINTERVAL                            INTERVALTYPE CALLER               ORIGCALLER           CALLED               ORIGCALLED           PRIVATEDATA                                                                      USERDATA                                                                                                 DEFAULTINTERVAL REDIALINTERVAL                                                                                               REDIALCOUNT                                    TYPE                               SERVICEID                              ANSWERTYPE                                PRIORITY                                  STATUS
-------------------- --------------------------------------- -------------------- -------------------- -------------------- -------------------- --------------------------------------- --------------------------------------- -------------------- -------------------- -------------------- -------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------- -------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ---------------------------------------
96f1hrrl37g2                                              10 2004-05-06 18:00:00  2004-05-06 20:00:00  2004-05-06 18:00:00  2004-05-06 20:00:00                                        0                                       0 4                    9681065685050        116996128            11699668             ^h:\flow\qinai.\vox\xx1\1.vox^116996128^ ^1065685050^                                                                                                                                                   3 20                                                                                                                     8                                       1                                       0                                       0                                       0                                       0
hpf1hrug0mg2                                              10 2004-03-13 10:35:00  1970-01-01 10:00:00  2004-03-13 10:35:00  1970-01-01 10:00:00                                        0                                       0 0                    9681001065662503     116996128            11699668             ^h:\flow\qinai.\vox\xx6\2.vox^116996128^ ^1001065662503^                                                                                                                                                3 20                                                                                                                     8                                       1                                       0                                       0                                       0                                       0
d6f1hrm047g2                                              10 2004-03-05 09:27:00  1970-01-01 10:00:00  2004-03-05 09:27:00  1970-01-01 10:00:00                                        0                                       0 1                    9681065685050        116996128            11699668             ^h:\flow\qinai.\vox\xx4\2.vox^116996128^ ^1065685050^                                                                                                                                                   3 20                                                                                                                     8                                       1                                       0                                       0                                       0                                       0
4k01rrto37g2                                              10 2004-03-05 09:20:00  1970-01-01 10:00:00  2004-03-05 09:20:00  1970-01-01 10:00:00                                        0                                       0 1                    9681065685050        116996128            11699668             ^h:\flow\qinai.\vox\xx2\3.vox^116996128^ ^1065685050^                                                                                                                                                   3 20                                                                                                                     8                                       1                                       0                                       0                                       0                                       0