로그맵
테이블 (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