Newer
Older
GHFX_REFACTOR / SQL / V0_0_130__POSITION_TBL.sql
xiaowei on 11 Jan 2018 334 bytes 上传脚本
create table POSITION
(
  DBID        NUMBER(19) primary key not null,
  LATITUDE    FLOAT,
  LONGITUDE   FLOAT,
  RECEIVETIME DATE,
  USERNAME    VARCHAR2(255 CHAR),
  PATROLER_ID NUMBER(19) constraint FK5B3889292AF6A055 references PATROLER (DBID),
  TASK_ID     NUMBER(19) constraint FK5B38892999A43323 references TASKINFO (DBID)
);