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