KR Core - Medication (partial)
Tables (13)
medicationrequest
- oid — integer — Primary key — NOT NULL
- id — character
medicationrequest_based_on
- medicationrequest_id — integer — Foreign key → medicationrequest.oid — NOT NULL
- medication_request_based_on — character
medicationrequest_category
- id — integer — Primary key — NOT NULL
- medicationrequest_id — integer — Foreign key → medicationrequest.oid — NOT NULL
- text — character
medicationrequest_category_coding
- medicationrequest_dosage_instruction_id — integer — Foreign key → medicationrequest_category.medicationrequest_id — NOT NULL
- system — character
- code — character
medicationrequest_course_of_therapy_type_coding
- medicationrequest_id — integer — Foreign key → medicationrequest.oid — NOT NULL
- system — character
- code — character
medicationrequest_dosage_instruction
- id — integer — Primary key — NOT NULL
- medicationrequest_id — integer — Foreign key → medicationrequest.oid — NOT NULL
medicationrequest_dosage_instruction_additional_instruction
- id — integer — Primary key — NOT NULL
- medicationrequest_dosage_instruction_id — integer — Foreign key → medicationrequest_dosage_instruction.id — NOT NULL
- text — character
medicationrequest_dosage_instruction_additional_instruction_cod
- medicationrequest_dosage_instruction_additional_instruction_id — integer — Foreign key → medicationrequest_dosage_instruction_additional_instruction.id — NOT NULL
- system — character
- code — character
medicationrequest_dosage_instruction_as_needed_codeable_concept
- medicationrequest_dosage_instruction_id — integer — Foreign key → medicationrequest_dosage_instruction.id — NOT NULL
- system — character
- code — character
medicationrequest_dosage_instruction_dose_and_rate
- id — integer — Primary key — NOT NULL
- medicationrequest_dosage_instruction_id — integer — Foreign key → medicationrequest_dosage_instruction.id — NOT NULL
medicationrequest_dosage_instruction_dose_and_rate_type_coding
- medicationrequest_dosage_instruction_dose_and_rate_id — integer — Foreign key → medicationrequest_dosage_instruction_dose_and_rate.id — NOT NULL
- system — character
- code — character
medicationrequest_dosage_instruction_method_coding
- medicationrequest_dosage_instruction_id — integer — Foreign key → medicationrequest_dosage_instruction.id — NOT NULL
- system — character
- code — character
medicationrequest_dosage_instruction_route_coding
- medicationrequest_dosage_instruction_id — integer — Foreign key → medicationrequest_dosage_instruction.medicationrequest_id — NOT NULL
- system — character
- code — character