Changes between Version 20 and Version 21 of ippToPsps_Database

Timestamp:

Apr 4, 2012, 4:12:11 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -33 +33 @@
 
 || '''Field'''             || '''Type'''          || '''Null''' || '''Key''' || '''Default value'''       || '''Description''' ||
-|| timestamp         || timestamp     || NO   ||     || CURRENT_TIMESTAMP   ||       ||
-|| name              || varchar(30)   || NO   || PRI || NULL                ||       ||
-|| datastore_product || varchar(30)   || YES  ||     || NULL                ||       ||
-|| datastore_type    || varchar(30)   || YES  ||     || IPP_PSPS            ||       ||
-|| datastore_publish || tinyint(1)    || YES  ||     || 0                   ||       ||
-|| dvo_label         || varchar(100)  || YES  ||     || NULL                ||       ||
-|| dvo_location      || varchar(1000) || YES  ||     || NULL                ||       ||
-|| min_ra            || double        || YES  ||     || 0                   ||       ||
-|| max_ra            || double        || YES  ||     || 360                 ||       ||
-|| min_dec           || double        || YES  ||     || -30                 ||       ||
-|| max_dec           || double        || YES  ||     || 90                  ||       ||
-|| box_size          || double        || YES  ||     || 4                   ||       ||
-|| base_path         || varchar(1000) || YES  ||     || NULL                ||       ||
-|| data_release      || smallint(6)   || YES  ||     || 0                   ||       ||
-|| delete_local      || tinyint(1)    || YES  ||     || 0                   ||       ||
-|| delete_datastore  || tinyint(1)    || YES  ||     || 1                   ||       ||
-|| delete_dxlayer    || tinyint(1)    || YES  ||     || 1                   ||       ||
-|| epoch             || timestamp     || NO   ||     || 0000-00-00 00:00:00 ||       ||
-|| survey            || varchar(10)   || YES  ||     || NULL                ||       ||
-|| psps_survey       || varchar(10)   || YES  ||     || NULL                ||       ||
-|| queue_P2          || tinyint(1)    || YES  ||     || 1                   ||       ||
-|| queue_ST          || tinyint(1)    || YES  ||     || 0                   ||       ||
-|| queue_OB          || tinyint(1)    || YES  ||     || 0                   ||       ||
-|| active            || tinyint(1)    || YES  ||     || 1                   ||  defines whether this config is in active use or not ||
-
+|| timestamp         || timestamp     || NO   ||     || CURRENT_TIMESTAMP   || all clients update this timestamp regularly, like a heartbeat      ||
+|| name              || varchar(30)   || NO   || PRI || NULL                || the text name of this config      ||
+|| datastore_product || varchar(30)   || YES  ||     || NULL                || the datastore product, thus far only PSPS_test and PSPS_JHU have been used ||
+|| datastore_type    || varchar(30)   || YES  ||     || IPP_PSPS            || the datastore type. The defauls is only ever used ||
+|| datastore_publish || tinyint(1)    || YES  ||     || 0                   || 1 or 0 - should we publish or not? ||
+|| dvo_label         || varchar(100)  || YES  ||     || NULL                || the label for querying gpc1 to get contents of the DVO database  ||
+|| dvo_location      || varchar(1000) || YES  ||     || NULL                || the location of this DVO database on disk ||
+|| min_ra            || double        || YES  ||     || 0                   || the min RA of the box on the sky we should load from (in degrees) ||
+|| max_ra            || double        || YES  ||     || 360                 || the min RA of the box on the sky we should load from (in degrees) ||
+|| min_dec           || double        || YES  ||     || -30                 || the min RA of the box on the sky we should load from (in degrees) ||
+|| max_dec           || double        || YES  ||     || 90                  || the min RA of the box on the sky we should load from (in degrees) ||
+|| box_size          || double        || YES  ||     || 4                   || the min RA of the box on the sky we should load from (in degrees) ||
+|| base_path         || varchar(1000) || YES  ||     || NULL                || the size of the box (in degrees) that we should use to tile up the sky ||
+|| data_release      || smallint(6)   || YES  ||     || 0                   || data release to end up in PSPS meta tables ||
+|| delete_local      || tinyint(1)    || YES  ||     || 0                   || 0 or 1 - should we delete local data when ready? ||
+|| delete_datastore  || tinyint(1)    || YES  ||     || 1                   || 0 or 1 - should we delete from datastore when ready?||
+|| delete_dxlayer    || tinyint(1)    || YES  ||     || 1                   || 0 or 1 - should we delete from DXLayer when ready? ||
+|| epoch             || timestamp     || NO   ||     || 0000-00-00 00:00:00 || when queuing, this is taken as the beginning of time. Means we can reload surveys more than once - if we are careful ||
+|| survey            || varchar(10)   || YES  ||     || NULL                || what survey? eg 3PI, MDF (see available surveys in IN table [wiki:ippToPsps_Initialization here]) ||
+|| psps_survey       || varchar(10)   || YES  ||     || NULL                || PSPS survey, eg 'SA3' for SAS 3 year survey. Always a 3-character name ||
+|| queue_P2          || tinyint(1)    || YES  ||     || 1                   || 0 or 1 - should we queue P2 batches? ||
+|| queue_ST          || tinyint(1)    || YES  ||     || 0                   || 0 or 1 - should we queue ST batches? ||
+|| queue_OB          || tinyint(1)    || YES  ||     || 0                   || 0 or 1 - should we queue OB batches? ||
+|| active            || tinyint(1)    || YES  ||     || 1                   || defines whether this config is in active use or not ||