Archives of Photographic PLates for Astronomical USE

Relation between plates and logpages (applause_dr3.plate_logpage)

The table has 226646 rows, 5 columns.

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