Database Layout:

Tables:

IngestRecords

Columns:

IngestStates

Columns:

ID is a Fixed List:

1) NEW – New ID Created
2) INGEST – Ingestion in progress
3) ERROR – Ingestion failed
4) DONE – Ingestion complete
5) TERMINATE – Termination requested
6) STOPPED – Ingestion prematurely terminated

IngestEvents

Columns:

IngestEventTypes

Columns:

ID is a Fixed List:

— standard state switches and operations —
1) NEW – New ID Created
2) INGEST – Initial ingestion started
3) ERROR – Ingestion terminated abnormally
4) DONE – Ingestion terminated normally
5) TERMINATE – Termination requested
6) STOPPED – Ingestion prematurely terminated

— non-state affecting commands —
100) STATUS – Current status requested

— errors and abnormal commands —
1000) INVALID_INGEST – An ingest process was started with an invalid ID
1001) INVALID_STATUS – A status request was made with an invalid ID
1002) CONCURRENT_INGEST – An ingest request was made while another ingest was in progress for this score
1003) REINGEST – An additional ingestion was started
1004) ACCESS_DENIED – An ingest request was made with an invalid access code