CREATE TABLE 'door_devices'
(
  'id' int PRIMARY KEY,
  'hex_id' varchar(255),
  'symm_key' varchar(255),
  'name' varchar(255),
  'active' tinyint
);

CREATE TABLE 'door_events'
(
  'id' int PRIMARY KEY,
  'device_id' int,
  'counter' int,
  'percentage' int,
  'degrees' int,
  'open' tinyint,
  'battery' int,
  'created_at' varchar(255)
);

ALTER TABLE 'door_events' ADD FOREIGN KEY ('device_id') REFERENCES 'door_devices' ('id');