Changes between Version 26 and Version 27 of ippToPsps_Database

Timestamp:

Apr 10, 2012, 1:07:38 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -80 +80 @@
 
 === The {{{box}}} table ===
+
+When queuing, the sky is split into equally sized boxes, the size of which is determined in the config in use. The {{{box}}} tables lists the RA/Dec centers of each box, as well as the box size, for each config that currently has items queued.
+
+
+{{{
++---------------------+-------+--------+-----------+------------+----------+
+| timestamp           | id    | config | ra_center | dec_center | box_side |
++---------------------+-------+--------+-----------+------------+----------+
+| 2012-04-03 16:47:35 | 41879 | new3pi |         2 |        -28 |        4 | 
+| 2012-04-03 16:47:35 | 41880 | new3pi |         2 |        -24 |        4 | 
+| 2012-04-03 16:47:35 | 41881 | new3pi |         2 |        -20 |        4 | 
+| 2012-04-03 16:47:35 | 41882 | new3pi |         2 |        -16 |        4 | 
+| 2012-04-03 16:47:35 | 41883 | new3pi |         2 |        -12 |        4 | 
+| 2012-04-03 16:47:35 | 41884 | new3pi |         2 |         -8 |        4 | 
+| 2012-04-03 16:47:35 | 41885 | new3pi |         2 |         -4 |        4 | 
+| 2012-04-03 16:47:35 | 41886 | new3pi |         2 |          0 |        4 | 
+| 2012-04-03 16:47:35 | 41887 | new3pi |         2 |          4 |        4 | 
+| 2012-04-03 16:47:35 | 41888 | new3pi |         2 |          8 |        4 | 
+| 2012-04-03 16:47:35 | 41889 | new3pi |         2 |         12 |        4 | 
+etc
+}}}
+
+The {{{config}}} column has a foreign key constraint with {{{name}}} from the {{{config}}} table. This means if a particular config is deleted from the {{{config}}} table then all related entries here in the {{{box}}} table will also be removed automatically.
+
+The {{{id}}} column is unique and is acts as a foreign key for the {{{pending}}} table, i.e. removal of a box here will remove all related entries in the pending table.
 === The {{{stripe}}} table ===