Newer
Older
EMS_SZ / SQL / V0_0_122__ACCIDENT_TBL.sql
root on 15 Jun 2016 454 bytes final
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)
);