ERD Schema of the Edge3 Database¶

Here is the current database schema diagram for the Edge3 provider tables.

Warning

The ER diagram shows the snapshot of the database structure valid for version 5.0.0 and it should be treated as an internal detail. It might be changed at any time and you should not directly access the database to retrieve information from it or modify the data. The main purpose of this diagram is to help with troubleshooting and understanding of the internal Edge3 DB architecture in case you have any problems with the database.

        erDiagram
edge_job {
 VARCHAR(250) dag_id PK
   INTEGER map_index PK
   VARCHAR(250) run_id PK
   VARCHAR(250) task_id PK
   INTEGER try_number PK
   VARCHAR(2048) command 
   INTEGER concurrency_slots 
   VARCHAR(64) edge_worker 
   TIMESTAMP last_update 
   VARCHAR(256) queue 
   TIMESTAMP queued_dttm 
   VARCHAR(20) state 
   VARCHAR(64) team_name 
}
edge_logs {
 VARCHAR(250) dag_id PK
   TIMESTAMP log_chunk_time PK
   INTEGER map_index PK
   VARCHAR(250) run_id PK
   VARCHAR(250) task_id PK
   INTEGER try_number PK
   TEXT log_chunk_data 
}
edge_worker {
 VARCHAR(64) worker_name PK
   INTEGER concurrency 
   TIMESTAMP first_online 
   INTEGER jobs_active 
   TIMESTAMP last_update 
   VARCHAR(1024) maintenance_comment 
   VARCHAR(256) queues 
   VARCHAR(20) state 
   JSON sysinfo 
   VARCHAR(64) team_name 
}