Timeseries tables

Table Type Source Period Parameters Description
SAT_MASS_REPORT raw 12 Satellite Mass Report Storage
MANOEUVRE_HISTORY raw 2d0h0m0s 5 Manoeuvre Acceleration History Storage
APEX_LOG raw 10m0s 10 APEX Execution Log
MANOEUVRE_PREDICTION raw 6 Manoeuvre Prediction Storage
TC_STORE raw 10m0s 69 Telecommand events low level storage
ORBIT4ANT raw 1m0s 7 OEM Orbit Prediction Storage
TM_STORE_STATS raw 12 Custom stats table for telemetry
SCHEDULE_TML_ACTIONS raw 2 Schedule Timeline Actions Storage
PREDICTED_ORBIT raw 1m0s 7 Geo Location Orbit State Vectors Storage
TM_STORE storage 10m0s 13 Telemetry low level storage
TM_STATS stats 2 Custom stats table for telemetry
EV_STORE raw 1h41m0s 11 EPS-SG Events
APEX_INSTANCES raw 10m0s 9 APEX Procedure Instance defintions
SCHEDULE_ACTIVITIES raw 13 Schedule History Activities Storage
GEO_EVENTS raw 10m0s 7 Executable Schedule Storage
TM_KEYCODES sys 3 Custom stats table for telemetry
MOC_ARCHIVE_EVENTS raw 10m0s 12 MOC_ARCHIVE_EVENTS Report
TC_ACK_STORE raw 10m0s 23 Telecommand events low level storage

Source specific timeseries tables

Sid Table Type Source Period Parameters Description
SGA1 TC raw 30m0s 6371 None
SGA1 TM raw 30m0s 119577 None
SGA1 TC raw 30m0s 6371 None
SGA1 TM raw 30m0s 119577 None

System tables

NameDescription
EVENTS CHART events
EVENT_SUBSCRIPTIONS Store details of which email updates each user has requested
FDF_EVENTS Flight dynamics events ingested from GEOEVENTS files
JOBS This table contains backend processing jobs which are either scheduled for processing, in process or have failed
ORB_HISTO Satellite positions read from daily FDF file
PROCESSES Processes spawned by worker to execute jobs
PRODUCTS Record ingested products
REPORTS Store overview of results of scheduler algorithms
SUBSCRIPTIONS Store details of which email updates each user has requested
USERS Users who wish to receive email updates from CHART (maybe replaced using the Django users system)