Archives of Photographic PLates for Astronomical USE

Logpage table (applause_dr2.plate_logpage)

The table has 154676 rows, 5 columns.


The plate_logpage table stores links between plates and logbook pages / plate envelopes. Each row in this table corresponds to a plate-page pair. A plate can have multiple related pages and a logbook page can have multiple related plates.


If you have made substantial use of the data provided by APPLAUSE DR2, kindly include this acknowledgement

Funding for APPLAUSE has been provided by DFG (German Research Foundation, Grant), Leibniz Institute for Astrophysics Potsdam (AIP), Dr. Remeis Sternwarte Bamberg (University Nuernberg/Erlangen), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory.


Name Type UCD Unit Description
plate_id int

Plate identification number

logpage_id int

Log-page identification number

logpage_order short meta.cryptic

Log-page order associated with the specific plate

timestamp_insert char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of insert

timestamp_update char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of last update