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