animal_batch

385 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('animal_batch_id_seq'::regclass)
animal_batch_group_relationship.animal_batch_id animal_batch_group_relationship_animal_batch_id_foreign R
animal_batch_sex_detail.animal_batch_id animal_batch_sex_detail_batch_id_foreign R
animal_batch_use_relationship.animal_batch_id animal_batch_use_relationship_animal_batch_id_foreign R
task_animal_batch_relationship.animal_batch_id task_animal_batch_relationship_animal_batch_id_foreign R
farm_id uuid 2147483647 null
farm.farm_id animal_batch_farm_id_foreign R
default_type_id int4 10 √ null
default_animal_type.id animal_batch_default_type_id_foreign R
custom_type_id int4 10 √ null
custom_animal_type.id animal_batch_custom_type_id_foreign R
default_breed_id int4 10 √ null
default_animal_breed.id animal_batch_default_breed_id_foreign R
custom_breed_id int4 10 √ null
custom_animal_breed.id animal_batch_custom_breed_id_foreign R
name varchar 255 √ null
notes text 2147483647 √ null
count int4 10 null
deleted bool 1 false
created_by_user_id varchar 255 '1'::character varying
users.user_id animal_batch_created_by_user_id_foreign R
updated_by_user_id varchar 255 '1'::character varying
users.user_id animal_batch_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
photo_url varchar 255 √ null
animal_removal_reason_id int4 10 √ null
animal_removal_reason.id animal_batch_animal_removal_reason_id_foreign R
removal_explanation varchar 255 √ null
removal_date timestamptz 35,6 √ null
organic_status text 2147483647 'Non-Organic'::text
supplier varchar 255 √ null
price float4 8,8 √ null
dam varchar 255 √ null
sire varchar 255 √ null
brought_in_date timestamptz 35,6 √ null
birth_date timestamptz 35,6 √ null
origin_id int4 10 √ null
animal_origin.id animal_batch_origin_id_foreign R
location_id uuid 2147483647 √ null
location.location_id animal_batch_location_id_foreign R

Indexes

Constraint Name Type Sort Column(s)
animal_batch_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation