File: med_protocol.sql

package info (click to toggle)
gnumed-server 22.31-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 46,268 kB
  • sloc: sql: 1,217,633; python: 15,878; sh: 1,590; makefile: 20
file content (5 lines) | stat: -rw-r--r-- 653 bytes parent folder | download | duplicates (8)
1
2
3
4
5
 create table au.med_protocol_element ( narrative text, generic text, adjuvant text, dosage_form text , ufk_drug text not null, drug_db text not null, atc_code text not null, is_cr boolean default false, dosage numeric[] not null , period interval not null, dosage_unit text null, is_paed boolean default false, paed_dose numeric default null, paed_factor text default 'mg/kg' , directions text, is_prn boolean default false) inherits (audit.audit_fields ) ;
 create table au.med_protocol ( pk serial primary key, name text ) inherits (audit.audit_fields);
 alter table au.med_protocol_element add fk_med_protocol integer references au.med_protocol;