로그맵

테이블 (5)

device_info_history_table

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

device_info_table

  • serial_number — varchar(100) — 기본 키 — NOT NULL
  • train_number — varchar(100) — 외래 키 → train_number_table.number
  • device_type — int(11) — 외래 키 → device_type_table.i — NOT NULL
  • VERSION — varchar(100)
  • STATUS — varchar(500) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

device_type_table

  • i — int(11) — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL

train_number_table

  • train_type — int(11) — 외래 키 → train_type_table.i — NOT NULL
  • number — varchar(100) — NOT NULL

train_type_table

  • i — int(11) — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • group — varchar(100) — NOT NULL