Smart center
Tables (4)
Commands
- command_id — VARCHAR(50) — Primary key
- command_type — VARCHAR(50) — NOT NULL
- device_serial_number — VARCHAR(50) — NOT NULL
- file_type — VARCHAR(50) — NOT NULL
- action — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- timestamp — TIMESTAMP — NOT NULL
Responses
- response_id — VARCHAR(50) — Primary key
- command_id — VARCHAR(50) — Foreign key → Commands.command_id
- status — VARCHAR(50) — NOT NULL
- details — TEXT
- data_size — INT
- file_location — VARCHAR(50)
- timestamp — TIMESTAMP — NOT NULL
- retry — INT
States
- state_id — VARCHAR(50) — Primary key
- command_id — VARCHAR(50) — Foreign key → Commands.command_id
- state — VARCHAR(50) — NOT NULL
- power_status — VARCHAR(10) — NOT NULL
- network_status — VARCHAR(50) — NOT NULL
- percent — INT
- timestamp — TIMESTAMP — NOT NULL
- Field
Transfers
- transfer_id — VARCHAR(50) — Primary key
- command_id — VARCHAR(50) — Foreign key → Commands.command_id
- data_length — INT — NOT NULL
- checksum — VARCHAR(50) — NOT NULL
- sequence_number — INT — NOT NULL
- transmission_id — VARCHAR(50) — NOT NULL
- end_of_data_flag — BOOLEAN — NOT NULL
- timestamp — TIMESTAMP — NOT NULL