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