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