field_work_type

836 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
field_work_type_id serial 10 √ nextval('field_work_type_field_work_type_id_seq'::regclass)
field_work_task.field_work_type_id field_work_task_field_work_type_id_foreign R
farm_id uuid 2147483647 √ null
farm.farm_id field_work_type_farm_id_foreign R
field_work_name varchar 255 √ null
field_work_type_translation_key varchar 255 √ null
created_by_user_id varchar 255 √ '1'::character varying
users.user_id field_work_type_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id field_work_type_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
deleted bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
field_work_type_pkey Primary key Asc field_work_type_id
field_work_type_field_work_name_field_work_type_translation_key Must be unique Asc/Asc/Asc field_work_name + field_work_type_translation_key + farm_id

Relationships

Close relationships within degrees of separation