protocol_drugs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
drug_stocks.protocol_drug_id fk_rails_5230adeadd R
name varchar 2147483647 null
dosage varchar 2147483647 null
rxnorm_code varchar 2147483647 √ null
protocol_id uuid 2147483647 √ null
protocols.id fk_rails_dbcef01693 R
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
deleted_at timestamp 29,6 √ null
drug_category varchar 2147483647 √ null
stock_tracked bool 1 false

Indexes

Constraint Name Type Sort Column(s)
protocol_drugs_pkey Primary key Asc id
index_protocol_drugs_on_deleted_at Performance Asc deleted_at

Relationships

Close relationships within degrees of separation