빅데이터 군집주행 차량제어

테이블 (7)

Table Color Def (Untitled)

  • Oracle (Key) — Black(Default) — 기본 키 — NOT NULL
  • MongoDB (Field) — Green

accidentlist

  • accidentnum — varchar2(15) — 기본 키 — NOT NULL
  • accidentdate — varchar2(30)
  • accidentday — varchar2(10)
  • address — varchar2(100)
  • content — varchar2(30)
  • deathcnt — varchar2(20
  • heavycnt — vachar2(20)
  • midcnt — varchar2(20)
  • lightcnt — varchar2(20)
  • roadcondition — varchar2(30)
  • weather — varchar2(15)
  • gender — varchar2(20)
  • age — varchar2(20)
  • injury — varchar2(30)

admin

  • id — varchar2(10) — 기본 키 — NOT NULL
  • password — varchar2(30)
  • token — varchar2(300)

carlist

  • carnum — varchar2(30) — 기본 키 — NOT NULL
  • status — varchar2(40)
  • savedate — date
  • token — varchar2(300)

member

  • idx — number — 기본 키 — NOT NULL
  • userid — varchar2(40) — 기본 키 — NOT NULL
  • name — varchar2(20)
  • password — varchar2(20)
  • phone — varchar2(15)
  • birth — varchar2(10)
  • gender — varchar2(10)
  • token — varchar2(300)
  • face — varchar2(20)
  • login — date

sensorData

  • userid — varchar2(40) — 외래 키 → member.userid — NOT NULL
  • carnum (carnum2) — varchar2(30) — 외래 키 → carlist.carnum — NOT NULL
  • sensorType — varchar2(50)
  • sensorData — varchar2(50)
  • saveDate — date

serverlog

  • msg
  • saveDate