soil_amendment_task_products

1912 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('soil_amendment_task_products_id_seq'::regclass)
soil_amendment_task_products_purpose_relationship.task_products_id soil_amendment_task_products_purpose_relationship_task_products R
task_id int4 10 null
task.task_id soil_amendment_task_products_task_id_foreign R
product_id int4 10 √ null
product.product_id soil_amendment_task_products_product_id_foreign R
weight numeric 36,12 √ null
weight_unit text 2147483647 √ null
volume numeric 36,12 √ null
volume_unit text 2147483647 √ null
application_rate_weight_unit text 2147483647 √ null
application_rate_volume_unit text 2147483647 √ null
percent_of_location_amended numeric 36,12 √ null
total_area_amended numeric 36,12 √ null
deleted bool 1 false
created_by_user_id varchar 255 '1'::character varying
users.user_id soil_amendment_task_products_created_by_user_id_foreign R
updated_by_user_id varchar 255 '1'::character varying
users.user_id soil_amendment_task_products_updated_by_user_id_foreign R
created_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone
updated_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone

Indexes

Constraint Name Type Sort Column(s)
soil_amendment_task_products_pkey Primary key Asc id
task_product_uniqueness_composite Must be unique Asc/Asc task_id + product_id

Relationships

Close relationships within degrees of separation