animal

1842 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('animal_id_seq'::regclass)
animal_group_relationship.animal_id animal_group_relationship_animal_id_foreign R
animal_use_relationship.animal_id animal_use_relationship_animal_id_foreign R
task_animal_relationship.animal_id task_animal_relationship_animal_id_foreign R
farm_id uuid 2147483647 null
farm.farm_id animal_farm_id_foreign R
default_type_id int4 10 √ null
default_animal_type.id animal_default_type_id_foreign R
custom_type_id int4 10 √ null
custom_animal_type.id animal_custom_type_id_foreign R
default_breed_id int4 10 √ null
default_animal_breed.id animal_default_breed_id_foreign R
custom_breed_id int4 10 √ null
custom_animal_breed.id animal_custom_breed_id_foreign R
sex_id int4 10 √ null
animal_sex.id animal_sex_id_foreign R
name varchar 255 √ null
birth_date timestamptz 35,6 √ null
identifier varchar 255 √ null
identifier_color_id int4 10 √ null
animal_identifier_color.id animal_identifier_color_id_foreign R
origin_id int4 10 √ null
animal_origin.id animal_origin_id_foreign R
dam varchar 255 √ null
sire varchar 255 √ null
brought_in_date timestamptz 35,6 √ null
weaning_date timestamptz 35,6 √ null
notes text 2147483647 √ null
deleted bool 1 false
created_by_user_id varchar 255 '1'::character varying
users.user_id animal_created_by_user_id_foreign R
updated_by_user_id varchar 255 '1'::character varying
users.user_id animal_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_animal_removal_reason_id_foreign R
removal_explanation varchar 255 √ null
removal_date timestamptz 35,6 √ null
identifier_type_id int4 10 √ null
animal_identifier_type.id animal_identifier_type_id_foreign R
identifier_type_other varchar 255 √ null
organic_status text 2147483647 'Non-Organic'::text
supplier varchar 255 √ null
price float4 8,8 √ null
location_id uuid 2147483647 √ null
location.location_id animal_location_id_foreign R

Indexes

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

Relationships

Close relationships within degrees of separation