drug_remaining_outcome_code

-1 rows


Description

After a drug has been induced to an animal, the fate of the remaining drug in the vial is recorded. This table contains a list of types supported by the system. For example DISC = “Discard”

Columns

Column Type Size Nulls Auto Default Children Parents Comments
drug_remaining_outcome_code varchar 10 null
drug_administered.drug_remaining_outcome_code fk_drug_administered__drug_remaining_outcome_code R

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

The short description of a remaining drug outcome type.
long_description varchar 250 √ null

The long description of a remaining drug outcome type.
display_order int4 10 null

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

A boolean indicator to determine if a remaining drug outcome type is active.
create_user_id varchar 32 null

The id of the user that created the remaining drug outcome type.
create_utc_timestamp timestamp 29,6 null

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

The timestamp when the remaining drug outcome type was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_drgrmotccd Primary key Asc drug_remaining_outcome_code

Relationships

Close relationships within degrees of separation