hwcr_complaint

-1 rows


Description

A complaint that a caller believes could involve a conflict between Humans and Wildlife.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
hwcr_complaint_guid uuid 2147483647 uuid_generate_v4()
attractant_hwcr_xref.hwcr_complaint_guid FK_attrhwcrx_hwcrcmplnt R

System generated unique key for a hwcr complaint. This key should never be exposed to users via any system utilizing the tables.
other_attractants_text varchar 4000 √ null

Provides a more detailed description when the attractant of type “OTHER” is included.
create_user_id varchar 32 null

The id of the user that created the HWCR complaint.
create_utc_timestamp timestamp 29,6 null

The timestamp when the HWCR complaint 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 HWCR complaint.
update_utc_timestamp timestamp 29,6 null

The timestamp when the HWCR complaint was updated. The timestamp is stored in UTC with no Offset.
complaint_identifier varchar 20 null
complaint.complaint_identifier FK_hwcrcmplnt_complaint R

Natural key for a complaint generated by webEOC.
species_code varchar 10 null
species_code.species_code FK_hwcrcmplnt_speciescd R

A human readable code used to identify a wildlife species.
hwcr_complaint_nature_code varchar 10 √ null
hwcr_complaint_nature_code.hwcr_complaint_nature_code FK_hwcrcmplnt_cmpltntrcd R

A human readable code used to identify the nature of the Human Wildlife Conflict.

Indexes

Constraint Name Type Sort Column(s)
PK_hwcrcmplnt Primary key Asc hwcr_complaint_guid
UQ_hwcrcmplnt Must be unique Asc complaint_identifier

Relationships

Close relationships within degrees of separation