farm

8556 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
farm_id uuid 2147483647 uuid_generate_v1()
animal.farm_id animal_farm_id_foreign R
animal_batch.farm_id animal_batch_farm_id_foreign R
animal_union_batch_id_view.farm_id Implied Constraint R
crop.farm_id crop_farm_id_foreign R
crop_variety.farm_id crop_variety_farm_id_foreign R
custom_animal_breed.farm_id custom_animal_breed_farm_id_foreign R
custom_animal_type.farm_id custom_animal_type_farm_id_foreign R
disease.farm_id disease_farm_id_foreign R
document.farm_id document_farm_id_foreign C
emailToken.farm_id emailtoken_farm_id_foreign C
farm_addon.farm_id farm_external_integration_farm_id_foreign R
farmDataSchedule.farm_id farmdataschedule_farm_id_foreign R
farmExpense.farm_id farmexpense_farm_id_foreign R
farmExpenseType.farm_id farmexpensetype_farm_id_foreign C
fertilizer.farm_id fertilizer_farm_id_foreign R
field_work_type.farm_id field_work_type_farm_id_foreign R
finance_report.farm_id finance_report_farm_id_foreign R
harvest_use_type.farm_id Implied Constraint R
irrigation_type.farm_id Implied Constraint R
location.farm_id location_farm_id_foreign R
nitrogenSchedule.farm_id nitrogenschedule_farm_id_foreign R
nomination.farm_id nomination_farm_id_foreign R
notification.farm_id notification_farm_id_foreign R
organicCertifierSurvey.farm_id organiccertifiersurvey_farm_id_foreign R
pesticide.farm_id pesticide_farm_id_foreign R
price.farm_id price_farm_id_foreign R
product.farm_id product_farm_id_foreign R
revenue_type.farm_id revenue_type_farm_id_foreign R
sale.farm_id fk_crop_sale_farm_id R
supportTicket.farm_id supportticket_farm_id_foreign R
task_type.farm_id tasktype_farm_id_foreign R
userFarm.farm_id userfarm_farm_id_foreign C
userLog.farm_id userlog_farm_id_foreign R
waterBalanceSchedule.farm_id waterbalanceschedule_farm_id_foreign R
yield.farm_id yield_farm_id_foreign R
farm_name varchar 255 null
address varchar 255 √ null
units jsonb 2147483647 √ '{"currency": "USD", "date_format": "MM/DD/YY", "measurement": "metric"}'::jsonb
grid_points jsonb 2147483647 √ null
deleted bool 1 false
farm_phone_number varchar 255 √ null
created_by_user_id varchar 255 √ '1'::character varying
users.user_id farm_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id farm_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
sandbox_farm bool 1 √ false
country_id int4 10 √ null
countries.id farm_country_id_foreign R
owner_operated bool 1 √ null
default_initial_location_id uuid 2147483647 √ null
location.location_id farm_default_initial_location_id_foreign R
utc_offset int4 10 √ null
farm_image_url varchar 255 √ null
farm_image_thumbnail_url varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
farm_pkey Primary key Asc farm_id

Relationships

Close relationships within degrees of separation