Tell patients and family members affiliated with the plan

CREATE TABLE 'planes' (
  'codplan' int(11) NOT NULL,
  'nomplan' text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'dirigido' text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'costoplan' float(12,2) NOT NULL,
  'especactivas' varchar(80) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'statusplan' varchar(15) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE 'pacientes' (
  'codpaciente' int(11) NOT NULL,
  'idenpaciente' varchar(35) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'cedpaciente' varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'nompaciente' varchar(70) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'apepaciente' varchar(70) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'sexopaciente' varchar(10) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'fnacpaciente' date NOT NULL,
  'tlfpaciente' varchar(25) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'estadopaciente' varchar(30) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'ocupacionpaciente' varchar(80) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'id_provincia' int(10) NOT NULL,
  'id_departamento' int(10) NOT NULL,
  'direcpaciente' text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'codplan' int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE 'cargafamiliar' (
  'codfamiliar' int(11) NOT NULL,
  'cedpaciente' varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'dnifamiliar' varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'nomfamiliar' varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'parentescofamiliar' varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  'fnacfamiliar' date NOT NULL,
  'fechaingresofamiliar' date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;