-- Create table
create table VOC_RECORD_INFO
(
RECORD_ID VARCHAR2(13) not null,
LABEL_ID VARCHAR2(4),
REC_STARTTIME DATE not null,
REC_ENDTIME DATE not null,
REC_TIMELEN NUMBER(9),
PHONE VARCHAR2(20),
CHANNEL_ID NUMBER(4),
CONTENT VARCHAR2(100),
FILENAME VARCHAR2(50),
DTMF VARCHAR2(50),
CALLDIR VARCHAR2(8),
CALLID VARCHAR2(20),
CALLERID VARCHAR2(20),
CALLEDID VARCHAR2(20),
DRIVERS VARCHAR2(2),
ABS_PATH VARCHAR2(50)
)
tablespace USERS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create table VOC_RECORD_INFO
(
RECORD_ID VARCHAR2(13) not null,
LABEL_ID VARCHAR2(4),
REC_STARTTIME DATE not null,
REC_ENDTIME DATE not null,
REC_TIMELEN NUMBER(9),
PHONE VARCHAR2(20),
CHANNEL_ID NUMBER(4),
CONTENT VARCHAR2(100),
FILENAME VARCHAR2(50),
DTMF VARCHAR2(50),
CALLDIR VARCHAR2(8),
CALLID VARCHAR2(20),
CALLERID VARCHAR2(20),
CALLEDID VARCHAR2(20),
DRIVERS VARCHAR2(2),
ABS_PATH VARCHAR2(50)
)
tablespace USERS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);