Newer
Older
GHFX_REFACTOR / SQL / V0_0_122__ACCIDENT_TBL.sql
xiaowei on 11 Jan 2018 454 bytes 上传脚本
create table ACCIDENT
(
  DBID         NUMBER(19) primary key not null,
  ACCIDENTTIME TIMESTAMP(6),
  DESCRIBE     VARCHAR2(255 CHAR),
  LATITUDE     FLOAT,
  LOCALE       VARCHAR2(255 CHAR),
  LONGITUDE    FLOAT,
  PATROLERNAME VARCHAR2(255 CHAR),
  PATROLER_ID  NUMBER(19) constraint FKAEE7420F2AF6A055 references PATROLER (DBID),
  TASK_ID      NUMBER(19) constraint FKAEE7420F99A43323 references TASKINFO (DBID),
  RESULT       VARCHAR2(255 CHAR)
);