빅데이터 군집주행 차량제어
테이블 (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