users

9755 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id varchar 255 uuid_generate_v1()
animal.created_by_user_id animal_created_by_user_id_foreign R
animal.updated_by_user_id animal_updated_by_user_id_foreign R
animal_batch.created_by_user_id animal_batch_created_by_user_id_foreign R
animal_batch.updated_by_user_id animal_batch_updated_by_user_id_foreign R
animal_batch_sex_detail.created_by_user_id animal_batch_sex_detail_created_by_user_id_foreign R
animal_batch_sex_detail.updated_by_user_id animal_batch_sex_detail_updated_by_user_id_foreign R
animal_group.created_by_user_id animal_group_created_by_user_id_foreign R
animal_group.updated_by_user_id animal_group_updated_by_user_id_foreign R
crop.created_by_user_id crop_created_by_user_id_foreign R
crop.updated_by_user_id crop_updated_by_user_id_foreign R
crop_variety.created_by_user_id crop_variety_created_by_user_id_foreign R
crop_variety.updated_by_user_id crop_variety_updated_by_user_id_foreign R
custom_animal_breed.created_by_user_id custom_animal_breed_created_by_user_id_foreign R
custom_animal_breed.updated_by_user_id custom_animal_breed_updated_by_user_id_foreign R
custom_animal_type.created_by_user_id custom_animal_type_created_by_user_id_foreign R
custom_animal_type.updated_by_user_id custom_animal_type_updated_by_user_id_foreign R
disease.created_by_user_id disease_created_by_user_id_foreign R
disease.updated_by_user_id disease_updated_by_user_id_foreign R
document.created_by_user_id document_created_by_user_id_foreign R
document.updated_by_user_id document_updated_by_user_id_foreign R
emailToken.user_id emailtoken_user_id_foreign C
farm.created_by_user_id farm_created_by_user_id_foreign R
farm.updated_by_user_id farm_updated_by_user_id_foreign R
farm_addon.created_by_user_id farm_addon_created_by_user_id_foreign R
farm_addon.updated_by_user_id farm_addon_updated_by_user_id_foreign R
farmDataSchedule.user_id user_id R
farmExpense.created_by_user_id farmexpense_created_by_user_id_foreign R
farmExpense.updated_by_user_id farmexpense_updated_by_user_id_foreign R
farmExpenseType.created_by_user_id farmexpensetype_created_by_user_id_foreign R
farmExpenseType.updated_by_user_id farmexpensetype_updated_by_user_id_foreign R
fertilizer.created_by_user_id fertilizer_created_by_user_id_foreign R
fertilizer.updated_by_user_id fertilizer_updated_by_user_id_foreign R
field_work_task.created_by_user_id field_work_task_created_by_user_id_foreign R
field_work_task.updated_by_user_id field_work_task_updated_by_user_id_foreign R
field_work_type.created_by_user_id field_work_type_created_by_user_id_foreign R
field_work_type.updated_by_user_id field_work_type_updated_by_user_id_foreign R
finance_report.created_by_user_id finance_report_created_by_user_id_foreign R
finance_report.updated_by_user_id finance_report_updated_by_user_id_foreign R
irrigation_type.created_by_user_id irrigation_type_created_by_user_id_foreign R
irrigation_type.updated_by_user_id irrigation_type_updated_by_user_id_foreign R
location.created_by_user_id location_created_by_user_id_foreign R
location.updated_by_user_id location_updated_by_user_id_foreign R
location_defaults.created_by_user_id location_defaults_created_by_user_id_foreign R
location_defaults.updated_by_user_id location_defaults_updated_by_user_id_foreign R
management_plan.created_by_user_id management_plan_created_by_user_id_foreign R
management_plan.updated_by_user_id management_plan_updated_by_user_id_foreign R
management_plan_group.created_by_user_id management_plan_group_created_by_user_id_foreign R
management_plan_group.updated_by_user_id management_plan_group_updated_by_user_id_foreign R
nomination.created_by_user_id nomination_created_by_user_id_foreign R
nomination.updated_by_user_id nomination_updated_by_user_id_foreign R
nomination_status.created_by_user_id nomination_status_created_by_user_id_foreign R
nomination_status.updated_by_user_id nomination_status_updated_by_user_id_foreign R
nomination_type.created_by_user_id nomination_type_created_by_user_id_foreign R
nomination_type.updated_by_user_id nomination_type_updated_by_user_id_foreign R
nomination_workflow.created_by_user_id nomination_workflow_created_by_user_id_foreign R
nomination_workflow.updated_by_user_id nomination_workflow_updated_by_user_id_foreign R
notification.created_by_user_id notification_created_by_user_id_foreign R
notification.updated_by_user_id notification_updated_by_user_id_foreign R
notification_user.created_by_user_id notification_user_created_by_user_id_foreign R
notification_user.updated_by_user_id notification_user_updated_by_user_id_foreign R
notification_user.user_id notification_user_user_id_foreign R
organic_history.created_by_user_id organic_history_created_by_user_id_foreign R
organic_history.updated_by_user_id organic_history_updated_by_user_id_foreign R
organicCertifierSurvey.created_by_user_id organiccertifiersurvey_created_by_user_id_foreign R
organicCertifierSurvey.updated_by_user_id organiccertifiersurvey_updated_by_user_id_foreign R
password.user_id password_user_id_foreign R
pesticide.created_by_user_id pesticide_created_by_user_id_foreign R
pesticide.updated_by_user_id pesticide_updated_by_user_id_foreign R
product.created_by_user_id product_created_by_user_id_foreign R
product.updated_by_user_id product_updated_by_user_id_foreign R
release_badge.user_id release_badge_user_id_foreign R
revenue_type.created_by_user_id revenue_type_created_by_user_id_foreign R
revenue_type.updated_by_user_id revenue_type_updated_by_user_id_foreign R
sale.created_by_user_id sale_created_by_user_id_foreign R
sale.updated_by_user_id sale_updated_by_user_id_foreign R
shift.created_by_user_id shift_created_by_user_id_foreign R
shift.updated_by_user_id shift_updated_by_user_id_foreign R
shiftTask.created_by_user_id shifttask_created_by_user_id_foreign R
shiftTask.updated_by_user_id shifttask_updated_by_user_id_foreign R
showedSpotlight.user_id showedspotlight_user_id_foreign R
soil_amendment_task_products.created_by_user_id soil_amendment_task_products_created_by_user_id_foreign R
soil_amendment_task_products.updated_by_user_id soil_amendment_task_products_updated_by_user_id_foreign R
supportTicket.created_by_user_id supportticket_created_by_user_id_foreign R
supportTicket.updated_by_user_id supportticket_updated_by_user_id_foreign R
task.assignee_user_id task_assignee_foreign R
task.created_by_user_id activitylog_created_by_user_id_foreign R
task.owner_user_id user_id R
task.updated_by_user_id activitylog_updated_by_user_id_foreign R
task_type.created_by_user_id tasktype_created_by_user_id_foreign R
task_type.updated_by_user_id tasktype_updated_by_user_id_foreign R
userFarm.user_id user_id R
userLog.user_id userlog_user_id_foreign R
first_name varchar 255 null
last_name varchar 255 ''::character varying
profile_picture varchar 255 null
email varchar 255 null
phone_number varchar 255 null
user_address varchar 255 null
notification_setting jsonb 2147483647 '{"alert_pest": true, "alert_weather": true, "alert_worker_finish": true, "alert_before_planned_date": true, "alert_action_after_scouting": true}'::jsonb
created_at timestamptz 35,6 CURRENT_TIMESTAMP
updated_at timestamptz 35,6 CURRENT_TIMESTAMP
language_preference varchar 5 'en'::character varying
status_id int4 10 1
user_status.status_id users_status_foreign R
gender text 2147483647 'PREFER_NOT_TO_SAY'::text
birth_year int4 10 null
do_not_email bool 1 false
sandbox_user bool 1 false

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc user_id
users_email_unique Must be unique Asc email

Relationships