hwcr_complaint_nature_code

-1 rows


Description

Modifier that further describes the nature of Human Wildlife Conflict complaints. (E.g. DEADNV = Dead wildlife - no violation suspected; TRAP = Wildlife in trap)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
hwcr_complaint_nature_code varchar 10 null
hwcr_complaint.hwcr_complaint_nature_code FK_hwcrcmplnt_cmpltntrcd R

A human readable code used to identify the nature of the Human Wildlife Conflict.
short_description varchar 50 null

The short description of the nature of the Human Wildlife Conflict code.
long_description varchar 250 √ null

The long description of the nature of the Human Wildlife Conflict code.
display_order int4 10 null

The order in which the values of the nature of the Human Wildlife Conflict code table should be displayed when presented to a user in a list.
active_ind bool 1 null

A boolean indicator to determine if the nature of the Human Wildlife Conflict code is active.
create_user_id varchar 32 null

The id of the user that created the human wildlife conflict nature code.
create_utc_timestamp timestamp 29,6 null

The timestamp when the human wildlife conflict nature code 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 human wildlife conflict nature code.
update_utc_timestamp timestamp 29,6 null

The timestamp when the human wildlife conflict nature code was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_cmpltntrcd Primary key Asc hwcr_complaint_nature_code

Relationships

Close relationships within degrees of separation