deliveries

-1 rows


Description

Incoming deliveries of new seedlings to a planting site. Mostly exists to link plantings and nursery withdrawals.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
plantings.delivery_id plantings_planting_site_id_delivery_id_fkey R
withdrawal_id int8 19 null
withdrawals.id deliveries_withdrawal_id_fkey C

Which nursery withdrawal the plants came from.
planting_site_id int8 19 null
plantings.planting_site_id plantings_planting_site_id_delivery_id_fkey R
planting_sites.id deliveries_planting_site_id_fkey C

Which planting site received the delivery.
created_by int8 19 null
users.id deliveries_created_by_fkey R

Which user created the delivery.
created_time timestamptz 35,6 null

When the delivery was created.
modified_by int8 19 null
users.id deliveries_modified_by_fkey R

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
users.id deliveries_reassigned_by_fkey R

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

Relationships

Close relationships within degrees of separation