Database Properties
Database Type: PostgreSQL - 13.1 (Debian 13.1-1.pgdg100+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| batch_photos | 0 | 4 | 7 | 0 | Table | Information about photos of batches. |
| batch_withdrawals | 0 | 3 | 6 | 0 | Table | Number of seedlings withdrawn from each originating batch as part of a withdrawal. |
| batch_quantity_history | 0 | 4 | 10 | 0 | Table | Record of changes of seedling quantities in each nursery batch. |
| batch_sub_locations | 0 | 7 | 3 | 0 | Table | Which batches are stored in which sub-locations. |
| withdrawal_purposes | 1 | 0 | 2 | 5 | Table | (Enum) Reasons that someone can withdraw seedlings from a nursery. |
| withdrawals | 5 | 6 | 11 | 0 | Table | Top-level information about a withdrawal from a nursery. Does not contain withdrawal quantities; those are in the |
| batch_substrates | 2 | 0 | 2 | 6 | Table | (Enum) Substrates in which seedlings can be planted in a nursery. |
| withdrawal_photos | 0 | 2 | 2 | 0 | Table | Linking table between |
| batches | 10 | 10 | 33 | 0 | Table | Information about batches of seedlings at nurseries. |
| batch_details_history | 1 | 5 | 13 | 0 | Table | Record of changes of user-editable attributes of each nursery batch. |
| batch_details_history_sub_locations | 0 | 2 | 3 | 0 | Table | Record of changes to sub-locations of each nursery batch. |
| batch_quantity_history_types | 1 | 0 | 2 | 3 | Table | (Enum) Types of operations that can result in changes to remaining quantities of seedling batches. |