CREATE TABLE drug
(
  id int NOT NULL,
  is_brand bit,
  company nvarchar(165),
  strength nvarchar(255),
  form nvarchar(281),
  strength_uom nvarchar(255),
  route nvarchar(281),
  status nvarchar(50),
  packageTypeId int,
  ID_MOL int NOT NULL,
  ID_MUL nvarchar(1) NOT NULL,
  ID_ROUTE int NOT NULL,
  provider_id int,
  short_name nvarchar(220),
  long_name nvarchar(330),
  active_ingredient nvarchar(281),
  generic_name nvarchar(300)
);
CREATE TABLE drug_image
(
  id int NOT NULL,
  provider_id int,
  drug_id int NOT NULL,
  name nvarchar(255),
  file_name nvarchar(255),
  is_drug_image bit
);
CREATE TABLE package_type
(
  packageTypeId int NOT NULL,
  name nvarchar(110),
  shortname nvarchar(10)
);



