Content Comparison

id

uuid

Identifier in the system

✅

✅

name

varchar(255)

The name of the BRAND of INNM_DOSAGE

✅

✅

type

varchar(255)

Type of the record: BRAND or INNM_DOSAGE

✅

✅

manufacturer

jsonb

Manufacturer's data set: Name Country

✅

code_atc

jsonb

ATX code

✅

is_active

bool

Active in the system

✅

form

varchar(255)

Release form

✅

container

jsonb

Information about primary package of the Brand

✅

package_qty

int4

Quantity in the package

✅

package_min_qty

int4

Minimum quantity available for sale

✅

certificate

varchar(255)

Certificate

✅

certificate_expired_at

date

Expiration date of the certificate

✅

inserted_by

uuid

Identifier of the person who made the entry in the system

✅

✅

updated_by

uuid

Identifier of the person who edited the entry in the system

✅

✅

inserted_at

timestamp

When an entry was made to the system

✅

✅

updated_at

timestamp

When it was updated

✅

✅

daily_dosage

float8

Daily dose of the drug

✅

max_daily_dosage

float8

The maximum allowable daily dose of the drug

✅

max_request_dosage

int2

The maximum dose of the drug within one prescription

✅

mr_blank_type

varchar(64)

Type of prescription form. F-1 or F-3.

✅

dosage_form_is_dosed

bool

Indication of dosage of the dosage form

✅

form_pharm

varchar(255)

Pharmaceutical form

✅

drlz_sku_id

varchar(255)

identifier of a product out of external DRLZ register

✅