location

29620 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
location_id uuid 2147483647 uuid_generate_v1()
animal.location_id animal_location_id_foreign R
animal_batch.location_id animal_batch_location_id_foreign R
barn.location_id barn_location_id_foreign C
buffer_zone.location_id buffer_zone_location_id_foreign C
ceremonial_area.location_id ceremonial_area_location_id_foreign C
custom_location.location_id custom_location_location_id_foreign R
farm.default_initial_location_id farm_default_initial_location_id_foreign R
farm_site_boundary.location_id farm_site_boundary_location_id_foreign C
fence.location_id fence_location_id_foreign C
field.location_id field_field_id_foreign R
figure.location_id figure_location_id_foreign R
garden.location_id garden_location_id_foreign C
gate.location_id gate_location_id_foreign C
greenhouse.location_id greenhouse_location_id_foreign C
irrigation_task.location_id irrigation_task_location_id_foreign R
location_defaults.location_id location_defaults_location_id_foreign R
location_tasks.location_id activityfields_field_id_foreign R
natural_area.location_id natural_area_location_id_foreign C
organic_history.location_id organic_history_location_id_foreign R
pin.location_id pin_location_id_foreign C
planting_management_plan.location_id planting_management_plan_location_id_foreign R
residence.location_id residence_location_id_foreign C
shiftTask.location_id shifttask_field_id_foreign R
soil_sample_location.location_id soil_sample_location_location_id_foreign C
surface_water.location_id ground_water_location_id_foreign C
water_valve.location_id water_valve_location_id_foreign C
watercourse.location_id creek_location_id_foreign C
farm_id uuid 2147483647 null
farm.farm_id location_farm_id_foreign R
name varchar 255 null
notes text 2147483647 null
deleted bool 1 false
created_by_user_id varchar 255 null
users.user_id location_created_by_user_id_foreign R
updated_by_user_id varchar 255 null
users.user_id location_updated_by_user_id_foreign R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
location_pkey Primary key Asc location_id

Relationships