Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||||||
| withdrawal_id | int8 | 19 | null |
|
|
Which nursery withdrawal the plants came from. |
||||||
| planting_site_id | int8 | 19 | null |
|
|
Which planting site received the delivery. |
||||||
| created_by | int8 | 19 | null |
|
|
Which user created the delivery. |
||||||
| created_time | timestamptz | 35,6 | null |
|
|
When the delivery was created. |
||||||
| modified_by | int8 | 19 | null |
|
|
Which user most recently modified the delivery. |
||||||
| modified_time | timestamptz | 35,6 | null |
|
|
When the delivery was most recently modified. |
||||||
| reassigned_by | int8 | 19 | √ | null |
|
|
Which user recorded the reassignment of plants in this delivery. Null if this delivery has no reassignment. |
|||||
| reassigned_time | timestamptz | 35,6 | √ | null |
|
|
When the reassignment was recorded. Null if this delivery has no reassignment. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| deliveries_pkey | Primary key | Asc | id |
| deliveries_planting_site_id_id_key | Must be unique | Asc/Asc | planting_site_id + id |
| deliveries_withdrawal_id_key | Must be unique | Asc | withdrawal_id |