Changes between Version 16 and Version 17 of ippToPsps_Database

Timestamp:

Apr 2, 2012, 5:36:26 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -59 +59 @@
 === The {{{batch}}} table ===
 
-A very important table, {{{batch}}} stores TODO
+{{{batch}}} contains an entry for every batch, regardless of type, that has ever been processed or attempted to be processed through {{{ippToPsps}}}. The {{{detection}}}, {{{stack}}} and {{{object}}} tables all have foreign key relationships with this table using the {{{batch_id}}} column. {{{batch_id}}} is an auto-incrementing integer and ends up forming the batch name of the final file submitted to PSPS.
 
-{{{batch_id}}} is an auto-incrementing integer column. This number ends up as the actual batch name in the final file submitted to PSPS
 Setting the {{{purged}}} column to 1 will mean this batch will be removed from the datastore and local disk by {{{cleanup.py}}} regardless of load status. See [wiki:ippToPsps#Purging here].
 === The {{{detection}}} table ===