logtool

Tables (8)

bt_connection

  • object_id — INTEGER
  • event_id — INTEGER — NOT NULL
  • ts — TEXT — NOT NULL
  • connected — INTEGER — NOT NULL

bt_pair_info

  • object_id — INTEGER
  • event_id — INTEGER — NOT NULL
  • ts — TEXT — NOT NULL
  • user_phone — TEXT
  • user_mac — TEXT

call_log

  • object_id — INTEGER
  • event_id — INTEGER — NOT NULL
  • ts — TEXT — NOT NULL
  • direction — TEXT — NOT NULL
  • peer_phone — TEXT
  • call_time — TEXT

car_door_event

  • object_id — INTEGER
  • event_id — INTEGER — NOT NULL
  • ts — TEXT — NOT NULL
  • door_side — INTEGER — NOT NULL
  • door_state — TEXT — NOT NULL

case_list

  • case_id — TEXT
  • case_name — TEXT — NOT NULL
  • created_date — TEXT — NOT NULL
  • car_info — TEXT
  • vin_number — TEXT
  • original_path — TEXT
  • case_store_path — TEXT
  • firmware_info — TEXT

event_master

  • event_id — INTEGER
  • event_type — TEXT — NOT NULL

gear_info

  • object_id — INTEGER
  • event_id — INTEGER — NOT NULL
  • ts — TEXT — NOT NULL
  • gear — TEXT — NOT NULL

message_log

  • object_id — INTEGER
  • event_id — INTEGER — NOT NULL
  • ts — TEXT — NOT NULL
  • peer_phone — TEXT
  • content — TEXT