dronework

Tables (9)

channel

  • channel_id — VARCHAR(100) — Primary key — NOT NULL
  • event_id — VARCHAR(100) — Foreign key → event.event_id
  • stream_key — VARCHAR(200)
  • assigned_device_type — VARCHAR(30)
  • assigned_status — VARCHAR(30)
  • record_status — VARCHAR(30)
  • assigned_user_name — VARCHAR(100)
  • live_url — VARCHAR(500)
  • application — VARCHAR(100)
  • drone_application — VARCHAR(100)
  • live_postfix — VARCHAR(100)

drone

  • drone_id — UUID — Primary key — NOT NULL
  • station_id — UUID — Foreign key → station.station_id
  • serial — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100)
  • manufacturer_name — VARCHAR(100)
  • model_name — VARCHAR(100)
  • owner_name — VARCHAR(100)
  • owner_phone — VARCHAR(50)
  • owner_title — VARCHAR(100)
  • register_date — BIGINT

drone_alarm

  • alarm_id — VARCHAR(100) — Primary key — NOT NULL
  • drone_serial — VARCHAR(100) — Foreign key → drone.serial
  • level — VARCHAR(20)
  • module — INTEGER
  • error_key — VARCHAR(100)
  • message_en — VARCHAR(500)
  • domain — INTEGER
  • created_at — TIMESTAMP

drone_osd_history

  • id — BIGSERIAL — Primary key — NOT NULL
  • drone_serial — VARCHAR(100) — Foreign key → drone.serial
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • elevation — DECIMAL(10,2)
  • heading — DECIMAL(10,2)
  • horizontal_speed — DECIMAL(10,2)
  • vertical_speed — DECIMAL(10,2)
  • home_distance — DECIMAL(10,2)
  • battery_percent — INTEGER
  • mode_code — INTEGER
  • created_at — TIMESTAMP

event

  • event_id — VARCHAR(100) — Primary key — NOT NULL
  • title — VARCHAR(200)
  • created_at — TIMESTAMP

flight_task_progress

  • id — BIGSERIAL — Primary key — NOT NULL
  • station_serial — VARCHAR(100) — Foreign key → station.serial
  • status — VARCHAR(30)
  • percent — INTEGER
  • created_at — TIMESTAMP

point

  • point_id — VARCHAR(100) — Primary key — NOT NULL
  • event_id — VARCHAR(100) — Foreign key → event.event_id
  • point_type — VARCHAR(30)
  • lat — DECIMAL(10,7)
  • lng — DECIMAL(10,7)
  • memo — TEXT
  • register_user_name — VARCHAR(100)
  • is_owner — BOOLEAN

station

  • station_id — UUID — Primary key — NOT NULL
  • event_id — VARCHAR(100) — Foreign key → event.event_id
  • serial — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100)
  • model_name — VARCHAR(100)
  • lat — DECIMAL(10,7)
  • lng — DECIMAL(10,7)
  • tag — VARCHAR(100)
  • bound_data_time — BIGINT

station_osd_history

  • id — BIGSERIAL — Primary key — NOT NULL
  • station_serial — VARCHAR(100) — Foreign key → station.serial
  • temperature — DECIMAL(10,2)
  • wind_speed — DECIMAL(10,2)
  • rainfall — INTEGER
  • cover_state — INTEGER
  • putter_state — INTEGER
  • drone_charge_percent — INTEGER
  • drone_charge_state — INTEGER
  • sub_device_serial — VARCHAR(100)
  • sub_device_online_status — INTEGER
  • mode_code — INTEGER
  • created_at — TIMESTAMP