Archives of Photographic PLates for Astronomical USE

Relation between plates and logpages (applause_dr3.plate_logpage)

Description

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.

Attribution

If you have made substantial use of the data provided by APPLAUSE DR3, 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 Nürnberg/Erlangen), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory. Plate material also has been made available from Thüringer Landessternwarte Tautenburg.

Columns

Name Type UCD Unit Description
plate_id int meta.id Plate identification number
logpage_id int meta.id Log-page identification number, associated with the plate
logpage_order short meta.number Sequence number of the log-page, associated with the plate
timestamp_insert timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of insert
timestamp_update timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of last update