create table TASKINFO
(
  DBID        NUMBER(19) primary key not null,
  DEPLOYTIME  TIMESTAMP(6),
  DESCIRPTION VARCHAR2(255 CHAR),
  FINISHTIME  TIMESTAMP(6),
  STREET      VARCHAR2(255 CHAR),
  TASKSTATE   VARCHAR2(255 CHAR),
  USERNAME    VARCHAR2(255 CHAR),
  PATROLER_ID NUMBER(19) constraint FK163D3FB32AF6A055 references PATROLER (DBID)
);