drug_administered

-1 rows


Description

While an officer is responding to a LEAD they may need to record that a WILDLIFE had a DRUG_ADMINISTERED. This table keeps track of the type and amount of drugs administered, along with what happened to any remaining drug that was not used.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
drug_administered_guid uuid 2147483647 case_management.uuid_generate_v4()

System generated unique key for an drug that was administered to an animal. This key should never be exposed to users via any system utilizing the tables.
wildlife_guid uuid 2147483647 null
wildlife.wildlife_guid fk_drug_administered__wildlife_guid R

System generated unique key for an animal. This key should never be exposed to users via any system utilizing the tables.
drug_code varchar 10 null
drug_code.drug_code fk_drug_administered__drug_code R

A human readable code used to identify a drug type.
drug_method_code varchar 10 null
drug_method_code.drug_method_code fk_drug_administered__drug_method_code R

A human readable code used to identify a drug injection method type.
drug_remaining_outcome_code varchar 10 √ null
drug_remaining_outcome_code.drug_remaining_outcome_code fk_drug_administered__drug_remaining_outcome_code R

A human readable code used to identify a remaining drug outcome type.
vial_number varchar 50 null

A vial number that relates to a seperate drug inventory system.
drug_used_amount varchar 50 null

The amount of drug used
create_user_id varchar 32 null

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

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

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

A boolean indicator to determine if the drug_administered record is active.
additional_comments_text text 2147483647 √ null

Includes comments on immobilization outcomes, any adverse reactions, and drug storage or discarding.

Indexes

Constraint Name Type Sort Column(s)
PK_drug_administered_guid Primary key Asc drug_administered_guid

Relationships

Close relationships within degrees of separation