| is_deleted | boolean | If this record should be considered soft deleted |
| issue_record_id | varbinary | Unique identifier for the issue record |
| patient_id | varbinary | Unique identifier for the patient associated with this issue |
| drug_record_id | varbinary | Unique identifier for the associated drug record |
| consultation_id | varbinary | Identifier of the consultation associated with this issue, if applicable |
| is_cancelled | boolean | Indicates if the prescription issue has been cancelled |
| code_id | bigint | Identifier for the clinical code associated with this medication issue |
| consultation_source_code_id | bigint | Identifier for the consultation source code |
| dosage | varchar | Dosage instructions for the medication as recorded at the point of issue |
| course_duration_in_days | bigint | The duration of the medication course in days |
| effective_datetime | timestamp(6) with time zone | The date the issue became effective |
| issue_method_description | varchar | Description of the method used to issue the prescription |
| prescription_type_description | varchar | Description of the prescription type |
| estimated_nhs_cost | decimal(10,4) | Estimated NHS cost of the issued medication |
| max_next_issue_days | bigint | Maximum number of days before the next issue is permitted |
| min_next_issue_days | bigint | Minimum number of days before the next issue is permitted |
| is_prescribed_as_contraceptive | boolean | Indicates if the medication is prescribed as a contraceptive |
| is_privately_prescribed | boolean | Indicates if the medication is privately prescribed |
| quantity | decimal(9,3) | Total quantity of medication issued |
| quantity_multiplicand | decimal(9,3) | Multiplicand component of the quantity calculation |
| quantity_multiplier | decimal(9,3) | Multiplier component of the quantity calculation |
| quantity_multiplier_uom | varchar | Unit of measure for the quantity multiplier |
| quantity_representation | varchar | Human-readable representation of the quantity |
| quantity_unit | varchar | Unit of measure for the total issued quantity |
| review_date | date | Date the medication is due for review |
| local_mixture_name | varchar | Name of the local mixture, populated when the issue relates to a locally prepared mixture |
| cancellation_datetime | timestamp(6) with time zone | Date the issue was cancelled; NULL if not cancelled |
| dmd_product_code_id | bigint | dm+d (Dictionary of Medicines and Devices) product code identifier for the medication |
| organisation | varchar | An identifier for the source of data (an organisation) relating to a given GP practice |
| transform_datetime | timestamp(6) with time zone | The date that the data was made available in the model with a relevant change |
| model_updated_datetime | timestamp(6) with time zone | The date that the model record was last updated in the source system |
