Archives of Photographic PLates for Astronomical USE

Relation between plates and logpages (applause_dr4.plate_logpage)

The table has 261769 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 DR4, 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, and from the archives of the Vatican Observatory.


Name Type UCD Unit Description
plate_id int

Plate identification number

logpage_id int

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 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