logmap

Tables (5)

device_info_history_table

  • serial_number — varchar(100) — NOT NULL
  • train_number — VARCHAR(100)
  • device_type — int(11) — Foreign key → device_type_table.i — NOT NULL
  • VERSION — varchar(100) — NOT NULL
  • STATUS — varchar(500) — NOT NULL
  • details — VARCHAR(500)
  • updated_at — timestamp — NOT NULL

device_info_table

  • serial_number — varchar(100) — Primary key — NOT NULL
  • train_number — varchar(100) — Foreign key → train_number_table.number
  • device_type — int(11) — Foreign key → device_type_table.i — NOT NULL
  • VERSION — varchar(100) — NOT NULL
  • STATUS — varchar(500) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

device_type_table

  • i — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL

train_number_table

  • train_type — int(11) — Foreign key → train_type_table.i — NOT NULL
  • number — varchar(100) — NOT NULL

train_type_table

  • i — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL