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