wildlife

-1 rows


Description

WILDLIFE can be a participant on a CASE_FILE, specifically for CASE_FILE with a CASE_CODE of “HWCR” (Human / Wildlife Conflict)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
wildlife_guid uuid 2147483647 case_management.uuid_generate_v4()
action.wildlife_guid fk_action__wildlife_guid R
drug_administered.wildlife_guid fk_drug_administered__wildlife_guid R
ear_tag.wildlife_guid fk_ear_tag__wildlife_guid R

System generated unique key for an animal. This key should never be exposed to users via any system utilizing the tables.
case_file_guid uuid 2147483647 null
case_file.case_file_guid fk_wildlife__case_file_guid R

System generated unique key for a case. This key should never be exposed to users via any system utilizing the tables.
threat_level_code varchar 10 √ null
threat_level_code.threat_level_code fk_wildlife__threat_level_code R

A human readable code used to identify a threat level type.
sex_code varchar 10 √ null
sex_code.sex_code fk_wildlife__sex_code R

A human readable code used to identify a sex type.
age_code varchar 10 √ null
age_code.age_code fk_wildlife__age_code R

A human readable code used to identify an age type.
hwcr_outcome_code varchar 10 √ null
hwcr_outcome_code.hwcr_outcome_code fk_wildlife__hwcr_outcome_code R

A human readable code used to identify an HWCR outcome type.
species_code varchar 10 null

A human readable code used to identify a species. The COS Complaint Management is the authorative source for the screen labels and descriptions of the codes.
create_user_id varchar 32 null

The id of the user that created the wildlife record.
create_utc_timestamp timestamp 29,6 null

The timestamp when the wildlife record was created. The timestamp is stored in UTC with no Offset.
update_user_id varchar 32 null

The id of the user that updated the wildlife record.
update_utc_timestamp timestamp 29,6 null

The timestamp when the wildlife record was updated. The timestamp is stored in UTC with no Offset.
active_ind bool 1 √ null

A boolean indicator to determine if the wildlife record is active.
identifying_features varchar 4000 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_wildlife_guid Primary key Asc wildlife_guid

Relationships

Close relationships within degrees of separation