kisti
Tables (3)
IoT_Index (Untitled)
- data_id (id) — mediumtext — Primary key — NOT NULL
- trajectory_order (Field)
road_Info
- road_name (RN) — varchar(10) — Primary key — NOT NULL
- road_code (RN_CD) — varchar(30) — Primary key — NOT NULL
- latitude (lat) — double — Primary key — NOT NULL
- longitude (lng) — double — Primary key — NOT NULL
- road_name (RN2) — varchar(10) — Foreign key → road_index.road_name — NOT NULL
- road_code (RN_CD2) — varchar(30 — Foreign key → road_index.road_code — NOT NULL
- hour — varchar(2) — Foreign key → road_index.hour — NOT NULL
- octree_id (oct_id) — varchar(10) — Foreign key → road_index.octree_id — NOT NULL
road_index
- road_name (RN) — varchar(10) — Primary key — NOT NULL
- road_code (RN_CD) — varchar(30 — Primary key — NOT NULL
- hour — varchar(2) — Primary key — NOT NULL
- octree_id (oct_id) — varchar(10) — Primary key — NOT NULL