Child pages
  • IngestTool Database

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Database Layout:

Tables:

Anchor
IngestRecords
IngestRecords
IngestRecords

Columns:

  • id
    • PK
    • numeric(10,0)
    • not null
  • state
    • FK to IngestStates(PK)
    • numeric(10,0)
    • not null
  • access
    • varchar(1024)
    • not null

IngestStates

Columns:

  • id
    • PK
    • numeric(10,0)
    • not null
  • abbrev
    • varchar(255)
    • not null
  • description
    • varchar(1024)
    • not null

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:

  • record
    • FK to IngestRecords(PK)
    • numeric(10,0)
    • not null
  • event
    • FK to IngestEventTypes(PK)
    • numeric(10,0)
    • not null
  • ts
    • date
    • not null
  • details
    • varchar(4000)
    • nullable

...

— 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

IngestRecords

Columns:

  • id
    • PK
    • numeric(10,0)
    • not null
  • state
    • FK to IngestStates(PK)
    • numeric(10,0)
    • not null
  • access
    • varchar(1024)
    • not null

IngestStates

Columns:

  • id
    • PK
    • numeric(10,0)
    • not null
  • abbrev
    • varchar(255)
    • not null
  • description
    • varchar(1024)
    • not null

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