equipment_code

-1 rows


Description

Used to track pieces of equipment that could be deployed out in the field. For example BRSNR = “Bear Snare”

Columns

Column Type Size Nulls Auto Default Children Parents Comments
equipment_code varchar 10 null
equipment.equipment_code fk_equipment__equipment_code R

A human readable code used to identify an equipment type.
short_description varchar 50 null

The short description of an equipment type.
long_description varchar 250 √ null

The long description of an equipment type.
display_order int4 10 null

The order in which the values of the equipment type should be displayed when presented to a user in a list.
active_ind bool 1 null

A boolean indicator to determine if an equipment type is active.
create_user_id varchar 32 null

The id of the user that created the equipment type.
create_utc_timestamp timestamp 29,6 null

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

The timestamp when the equipment type was updated. The timestamp is stored in UTC with no Offset.
is_trap_ind bool 1 true

Indicates if the EQUIPMENT_CODE value represents a trap. Default to ‘true’. For EQUIPMENT_CODE values such as Signage or Trail cameras the value is ‘false’
has_quantity_ind bool 1 false

Indicates if the type of equipment allows a quantity to be speciofied. Default to ‘false’.

Indexes

Constraint Name Type Sort Column(s)
PK_equipmntcd Primary key Asc equipment_code

Relationships

Close relationships within degrees of separation