These pages document the database schema of Photo Organizer.
The specific pages for the database elements (tables, views, sequences, indexes and functions) will contain the history of the database all the way back to the 2.05 release of Photo Organizer.
- Databases schema is up to date with the current 2.33c release.
- Verify final schema with schema as reported by SQL dump of 2.34.
- A few cross references between tables, views, sequences, indexes and functions may be missing.
- Follow up on documentation of functions. There are some tentative descriptions that need verifying.
- For all tables, describe their use in the source code. What are the procedures for updating and using tables?
- All views need documentation on what they do and what their purpose is.
- Create a coherent picture of how photos are handled. Make a link between database and the physical reality.
Retrieving the current schema of your PO installation
To get the current database schema out of PostgreSQL you can use pg_dump:
$ pg_dump --schema po_db > po.schema
A dump of po-2.33c can be found here.
Another way to inspect your PO database is by using pgAccess. → Not available for current versions of PostgreSQL it seems.
bulk_update_ruleremoved in 2.32 currencyremoved in 2.34 dcraw_optionsremoved in 2.34 imagemagick_composite_optionsremoved in 2.34 imagemagick_optionsremoved in 2.34 photo_formatremoved in 2.19 photo_itemremoved in 2.34 photo_spoolerremoved in 2.34 preferencesremoved in 2.34 printer_spoolerremoved in 2.15 shop_categoryremoved in 2.34 shop_itemremoved in 2.34 shop_item_generator_ruleremoved in 2.34 shop_orderremoved in 2.34 shop_transactionremoved in 2.34 shop_transaction_statusremoved in 2.34 submissionremoved in 2.34 submission_statusremoved in 2.34 system_preferencesremoved in 2.34 Strike-through Text
is_photo_for_saleremoved in 2.34
bulk_update_rule_id_sequenceremoved in 2.32 bulk_upload_id_sequenceremoved in 2.31 currency_id_sequenceremoved in 2.34 dcraw_options_id_sequenceremoved in 2.34 export_id_sequenceremoved in 2.31 imagemagick_composite_options_id_sequenceremoved in 2.34 imagemagick_options_id_sequenceremoved in 2.34 photo_format_id_sequenceremoved in 2.19 photo_item_id_sequenceremoved in 2.34 photo_spooler_id_sequenceremoved in 2.34 preferences_id_sequenceremoved in 2.34 printer_spooler_id_sequenceremoved in 2.15 shop_category_id_sequenceremoved in 2.34 shop_item_generator_rule_id_sequenceremoved in 2.34 shop_order_id_sequenceremoved in 2.34 shop_transaction_id_sequenceremoved in 2.34 shop_transaction_status_id_sequenceremoved in 2.34