Cambio tipo de dato de Prestacion.Codigo y Prestador.CUIT de int a Varchar

[z.facultad/75.10/miklolife.git] / diagramas / der.dia

diff --git a/diagramas/der.dia b/diagramas/der.dia
index 299506d2b6c27f298accad6cbf29fdb1d159c8fc..b2805a1c766db91e38f276a71ba24d16b0f61214 100644 (file)
--- a/diagramas/der.dia
+++ b/diagramas/der.dia
@@ -92,7 +92,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Persona encargada de atender a los Solicitantes que quieren afiliarse.#</dia:string>
+        <dia:string>#Persona encargada de atender a los Solicitantes que quieren afiliarse. No se puede dar de baja si tiene Solicitantes asociados. Si se da de baja, hay que dar de baja en cascada a la tabla Persona#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -169,13 +169,13 @@
             <dia:string>#idPersona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPersona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -196,16 +196,16 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O1">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O1">
       <dia:attribute name="obj_pos">

-        <dia:point val="38.85,6.8"/>
+        <dia:point val="38.75,6.95"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="38.8,6.75;51.3,16.45"/>
+        <dia:rectangle val="38.7,6.9;51.3,16.6"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="38.85,6.8"/>
+        <dia:point val="38.75,6.95"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="12.4"/>
+        <dia:real val="12.5"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="9.5999999999999996"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="9.5999999999999996"/>


@@ -217,7 +217,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Clase abstracta para representar los datos y acciones comunes de una persona.#</dia:string>
+        <dia:string>#Clase abstracta para representar los datos y acciones comunes de una persona. No se puede dar de baja de forma directa, se da de baja al dar de baja un Afiliado, Solicitante o Promotor#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="true"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="true"/>


@@ -294,13 +294,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -317,7 +317,7 @@
             <dia:string>#tipoDocumento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#tipoDocumento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#enum(DNI,LC,LE,CI)#</dia:string>
+            <dia:string>#ENUM(DNI,LC,LE,CI)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -326,7 +326,7 @@
             <dia:string>#Tipo de documento.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Tipo de documento.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -340,7 +340,7 @@
             <dia:string>#nroDocumento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#nroDocumento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -349,7 +349,7 @@
             <dia:string>#Número de documento#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Número de documento#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -363,7 +363,7 @@
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -372,7 +372,7 @@
             <dia:string>#Primer y segundo nombre (en ese orden).#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Primer y segundo nombre (en ese orden).#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -386,7 +386,7 @@
             <dia:string>#apellido#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#apellido#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -395,7 +395,7 @@
             <dia:string>#Apellido completo.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Apellido completo.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -409,7 +409,7 @@
             <dia:string>#eMail#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#eMail#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -418,7 +418,7 @@
             <dia:string>#Dirección de correo electrónico de la persona.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Dirección de correo electrónico de la persona.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -432,16 +432,16 @@
             <dia:string>#fechaNacimiento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaNacimiento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Fecha de nacimiento (es una clase??? Para mí sí)#</dia:string>
+            <dia:string>#Fecha de nacimiento#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -455,7 +455,7 @@
             <dia:string>#sexo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#sexo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#enum(M,F)#</dia:string>
+            <dia:string>#ENUM(M,F)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -464,7 +464,7 @@
             <dia:string>#Género de la persona#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Género de la persona#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -478,16 +478,16 @@
             <dia:string>#idCap#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idCap#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -501,16 +501,16 @@
             <dia:string>#idDireccion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idDireccion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
           </dia:attribute>
           <dia:attribute name="value">

-            <dia:string>#PK#</dia:string>
+            <dia:string>#FK#</dia:string>

           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -528,19 +528,19 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O2">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O2">
       <dia:attribute name="obj_pos">

-        <dia:point val="21.6,23.05"/>
+        <dia:point val="29.45,23.75"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="21.55,23;30.3,31.1"/>
+        <dia:rectangle val="29.4,23.7;38.15,31"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="21.6,23.05"/>
+        <dia:point val="29.45,23.75"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="8.6500000000000004"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="8.6500000000000004"/>
       </dia:attribute>
       <dia:attribute name="elem_height">

-        <dia:real val="8"/>
+        <dia:real val="7.1999999999999993"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Afiliado#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Afiliado#</dia:string>


@@ -549,7 +549,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Persona afiliada a la obra social.#</dia:string>
+        <dia:string>#Persona afiliada a la obra social. Se da de baja lógica normalmente. Solo se puede dar de baja física si ningún Afiliado lo tiene como titular. Al darse de baja hay que borrar en cascada la tabla HistoriaPlan, Autorizacion, Persona y Solicitante (que lo tenga como titular)#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -626,13 +626,13 @@
             <dia:string>#idPersona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPersona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -649,16 +649,16 @@
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Identificador único de afiliado (con alguna codificación? int?).#</dia:string>
+            <dia:string>#Identificador único de afiliado#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -672,7 +672,7 @@
             <dia:string>#fechaAfiliacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaAfiliacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -681,7 +681,7 @@
             <dia:string>#Fecha en la que se lo dio de alta en el sistema.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Fecha en la que se lo dio de alta en el sistema.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -695,39 +695,16 @@
             <dia:string>#fechaBaja#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaBaja#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="value">
-            <dia:string>##</dia:string>
-          </dia:attribute>
-          <dia:attribute name="comment">
-            <dia:string>#Fecha en la que el afiliado solicita la baja#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="visibility">
-            <dia:enum val="0"/>
-          </dia:attribute>
-          <dia:attribute name="abstract">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="class_scope">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-        </dia:composite>
-        <dia:composite type="umlattribute">
-          <dia:attribute name="name">
-            <dia:string>#activo#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="type">
-            <dia:string>#bool#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#True si está en actividad (afiliado). (No convendría poner Plan = NULL en caso de no estar más afiliado?)#</dia:string>
+            <dia:string>#Fecha en la que el afiliado solicita la baja. NULL si está activo#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -741,7 +718,7 @@
             <dia:string>#moroso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#moroso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -750,7 +727,7 @@
             <dia:string>#Indica cuantos meses adeuda.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Indica cuantos meses adeuda.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -764,16 +741,16 @@
             <dia:string>#idPlan#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPlan#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -787,16 +764,16 @@
             <dia:string>#idTitular#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idTitular#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#NULL si es titular, si pertenece a un grupo familiar, se guarda el id del titular del grupo.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -814,19 +791,19 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O3">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O3">
       <dia:attribute name="obj_pos">

-        <dia:point val="-4.925,14.45"/>
+        <dia:point val="-4.975,17.65"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-4.975,14.4;3.425,18.5"/>
+        <dia:rectangle val="-5.025,17.6;3.375,23.3"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="-4.925,14.45"/>
+        <dia:point val="-4.975,17.65"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="8.3000000000000007"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="8.3000000000000007"/>
       </dia:attribute>
       <dia:attribute name="elem_height">

-        <dia:real val="4"/>
+        <dia:real val="5.5999999999999996"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Prestacion#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Prestacion#</dia:string>


@@ -835,7 +812,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Tipo de prestación que puede realizarse un afiliado.#</dia:string>
+        <dia:string>#Tipo de prestación que puede realizarse un afiliado. Tiene sólo baja lógica (excepto que se depure la base de datos, en cuyo caso hay que borrar, sólo si no tiene Autorizaciones y Coberturas asociadas, en cascada la tabla PrestadorPrestacion)#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -912,13 +889,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -930,21 +907,67 @@
             <dia:boolean val="false"/>
           </dia:attribute>
         </dia:composite>
             <dia:boolean val="false"/>
           </dia:attribute>
         </dia:composite>

+        <dia:composite type="umlattribute">
+          <dia:attribute name="name">
+            <dia:string>#codigo#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="type">
+            <dia:string>#VARCHAR(8)#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="value">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="comment">
+            <dia:string>#Código de prestación según el codificador#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="visibility">
+            <dia:enum val="2"/>
+          </dia:attribute>
+          <dia:attribute name="abstract">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="class_scope">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+        </dia:composite>

         <dia:composite type="umlattribute">
           <dia:attribute name="name">
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Nombre de la prestación (descripción breve).#</dia:string>
+            <dia:string>#Nombre de la prestación.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>
+          </dia:attribute>
+          <dia:attribute name="abstract">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="class_scope">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+        </dia:composite>
+        <dia:composite type="umlattribute">
+          <dia:attribute name="name">
+            <dia:string>#fechaBaja#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="type">
+            <dia:string>#DATE#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="value">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="comment">
+            <dia:string>#Si no es NULL, la Prestacion fue dada de baja en la fecha indicada por este campo.#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="visibility">
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -958,16 +981,16 @@
             <dia:string>#idCategoria#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idCategoria#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -988,13 +1011,13 @@
         <dia:point val="10.475,27"/>
       </dia:attribute>
       <dia:attribute name="obj_bb">
         <dia:point val="10.475,27"/>
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="10.425,26.95;20.075,33.45"/>
+        <dia:rectangle val="10.425,26.95;20.225,33.45"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
         <dia:point val="10.475,27"/>
       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_corner">
         <dia:point val="10.475,27"/>
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="9.5499999999999989"/>
+        <dia:real val="9.6999999999999993"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="6.4000000000000004"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="6.4000000000000004"/>


@@ -1006,7 +1029,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>##</dia:string>
+        <dia:string>#Plan de la obra social. Normalmente tiene baja lógica, pero puede darse de baja física si no tiene Afiliados asociados (y por lo tanto tampoco tiene asociados HistoriaPlan). Si se da de baja, hay que borrar en cascada la tabla Cobertura.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -1083,13 +1106,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -1106,7 +1129,7 @@
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1115,7 +1138,7 @@
             <dia:string>#Codigo de plan (nomenclador).#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Codigo de plan (nomenclador).#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1126,10 +1149,10 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#categoría#</dia:string>
+            <dia:string>#categoria#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#FLOAT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1138,7 +1161,7 @@
             <dia:string>#Categoría a la que pertenece (nomenclador).#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Categoría a la que pertenece (nomenclador).#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1152,7 +1175,7 @@
             <dia:string>#descripcion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#descripcion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1161,7 +1184,7 @@
             <dia:string>#Una breve descripción del plan.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Una breve descripción del plan.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1175,16 +1198,16 @@
             <dia:string>#permanenciaMinima#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#permanenciaMinima#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Tiempo#</dia:string>
+            <dia:string>#FLOAT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Permanencia mínima que debe cumplir en el plan antes de pasarse a otro.#</dia:string>
+            <dia:string>#Permanencia mínima (en meses) que debe cumplir en el plan antes de pasarse a otro. NULL si no tiene#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1195,19 +1218,19 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#activo#</dia:string>
+            <dia:string>#fechaBaja#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#bool#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Flag que indica si se el plan esta activo y por lo tanto se pueden tomar nuevas afiliaciones al mismo#</dia:string>
+            <dia:string>#Fecha en la que el plan se dio de baja. Si está activo es NULL.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1228,7 +1251,7 @@
         <dia:point val="1.5,-0.85"/>
       </dia:attribute>
       <dia:attribute name="obj_bb">
         <dia:point val="1.5,-0.85"/>
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="1.45,-0.9;9.85,4.8"/>
+        <dia:rectangle val="1.45,-0.9;9.85,5.6"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
         <dia:point val="1.5,-0.85"/>
       </dia:attribute>
       <dia:attribute name="elem_corner">
         <dia:point val="1.5,-0.85"/>


@@ -1237,7 +1260,7 @@
         <dia:real val="8.3000000000000007"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="8.3000000000000007"/>
       </dia:attribute>
       <dia:attribute name="elem_height">

-        <dia:real val="5.5999999999999996"/>
+        <dia:real val="6.4000000000000004"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Prestador#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Prestador#</dia:string>


@@ -1246,7 +1269,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Entidad prestadora de servicios para la obra social. Podría ser tanto una Clínica, como un centro de radiología o un médico particular.#</dia:string>
+        <dia:string>#Entidad prestadora de servicios para la obra social. Podría ser tanto una Clínica, como un centro de radiología o un médico particular. Tiene sólo baja lógica (excepto que se depure la base de datos, en cuyo caso hay que borrar, sólo si no tiene Autorizaciones asociadas, en cascada las tablas Direccion y PrestadorPrestacion)#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -1323,13 +1346,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -1346,7 +1369,7 @@
             <dia:string>#cuit#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#cuit#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#VARCHAR(11)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1369,16 +1392,39 @@
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Nombre legal de la entidad.#</dia:string>
+            <dia:string>#Nombre legal de la entidad (no puede ser NULL)#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>
+          </dia:attribute>
+          <dia:attribute name="abstract">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="class_scope">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+        </dia:composite>
+        <dia:composite type="umlattribute">
+          <dia:attribute name="name">
+            <dia:string>#fechaBaja#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="type">
+            <dia:string>#DATE#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="value">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="comment">
+            <dia:string>#Si no es NULL, el Prestador fue dado de baja en la fecha indicada por este campo.#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="visibility">
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1392,16 +1438,16 @@
             <dia:string>#idZona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idZona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1415,16 +1461,16 @@
             <dia:string>#idDireccion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idDireccion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1442,19 +1488,19 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O6">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O6">
       <dia:attribute name="obj_pos">

-        <dia:point val="33.525,-1"/>
+        <dia:point val="35.175,-1.2"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="33.475,-1.05;41.875,3.85"/>
+        <dia:rectangle val="35.125,-1.25;44.925,4.45"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="33.525,-1"/>
+        <dia:point val="35.175,-1.2"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="8.3000000000000007"/>
+        <dia:real val="9.6999999999999993"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
       </dia:attribute>
       <dia:attribute name="elem_height">

-        <dia:real val="4.8000000000000007"/>
+        <dia:real val="5.5999999999999996"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Cap#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Cap#</dia:string>


@@ -1463,7 +1509,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Centro de Atención Personalizada, es un punto de atención al cliente que cubre una o más Zonas y tiene uno o más Promotores.#</dia:string>
+        <dia:string>#Centro de Atención Personalizada, es un punto de atención al cliente que cubre una o más Zonas y tiene uno o más Promotores. Se puede dar de baja sólo si no tiene asociado Personas ni Zonas. Si se da de baja, hay que dar de baja en cascada la tabla Direccion.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -1540,13 +1586,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -1558,21 +1604,44 @@
             <dia:boolean val="false"/>
           </dia:attribute>
         </dia:composite>
             <dia:boolean val="false"/>
           </dia:attribute>
         </dia:composite>

+        <dia:composite type="umlattribute">
+          <dia:attribute name="name">
+            <dia:string>#codigo#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="type">
+            <dia:string>#VARCHAR(255)#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="value">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="comment">
+            <dia:string>#Código único de identificación del Cap.#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="visibility">
+            <dia:enum val="2"/>
+          </dia:attribute>
+          <dia:attribute name="abstract">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="class_scope">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+        </dia:composite>

         <dia:composite type="umlattribute">
           <dia:attribute name="name">
             <dia:string>#responsable#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
             <dia:string>#responsable#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Nombre del responsable (gerente) del CAP (lo usamos para algo!?!?!?!!).#</dia:string>
+            <dia:string>#Nombre del responsable (gerente) del CAP.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1586,16 +1655,16 @@
             <dia:string>#horario#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#horario#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Horario de atención (debería volar!?!?!?).#</dia:string>
+            <dia:string>#Horario de atención como un texto libre.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1609,16 +1678,16 @@
             <dia:string>#idDireccion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idDireccion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1636,16 +1705,16 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O7">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O7">
       <dia:attribute name="obj_pos">

-        <dia:point val="6.925,6.65"/>
+        <dia:point val="7.475,6.65"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="6.875,6.6;18.025,17.9"/>
+        <dia:rectangle val="7.425,6.6;20.725,17.9"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="6.925,6.65"/>
+        <dia:point val="7.475,6.65"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="11.049999999999999"/>
+        <dia:real val="13.199999999999999"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="11.200000000000001"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="11.200000000000001"/>


@@ -1657,7 +1726,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Cada vez que un Afiliado va a realizarse una Prestación, debe pedir una Autorización (sea Manual o Automática0.#</dia:string>
+        <dia:string>#Autorización para realizarse una Prestacion. No tiene bajas a menos que se depure la base de datos, en cuyo caso se debe borrar en cascada la tabla AutorizacionManual#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -1734,13 +1803,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -1757,7 +1826,7 @@
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1766,7 +1835,7 @@
             <dia:string>#Identificador único.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Identificador único.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1780,7 +1849,7 @@
             <dia:string>#porcentajeCobertura#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#porcentajeCobertura#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT(3)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1789,7 +1858,7 @@
             <dia:string>#Porcentaje de la prestacion cubierto por la Autorizacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Porcentaje de la prestacion cubierto por la Autorizacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1803,7 +1872,7 @@
             <dia:string>#fechaSolicitud#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaSolicitud#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1812,7 +1881,7 @@
             <dia:string>#Fecha en que fue solicitada la autorización.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Fecha en que fue solicitada la autorización.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1826,16 +1895,16 @@
             <dia:string>#fechaRealizacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaRealizacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Fecha en que efectivizada la autorización. Es decir el dia en que se rechazo o el dia en que el afiliado la utilizo.#</dia:string>
+            <dia:string>#Fecha en que efectivizada la autorización. Es decir el dia en que se rechazo o el dia en que el afiliado la utilizo. NULL si todavía no fue realizada#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1849,7 +1918,7 @@
             <dia:string>#fechaVencimiento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaVencimiento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1858,7 +1927,7 @@
             <dia:string>#Fecha en que vence la autorización.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Fecha en que vence la autorización.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1872,7 +1941,7 @@
             <dia:string>#aprobada#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#aprobada#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#bool#</dia:string>
+            <dia:string>#BOOL#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1881,7 +1950,7 @@
             <dia:string>#Indica si la autorizacion fue aprobada o no.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Indica si la autorizacion fue aprobada o no.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1895,7 +1964,7 @@
             <dia:string>#fundamentosResolucion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fundamentosResolucion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1904,7 +1973,7 @@
             <dia:string>#Una descripcion coloquial del por qué se aprueba o rechaza la autorización#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Una descripcion coloquial del por qué se aprueba o rechaza la autorización#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1918,7 +1987,7 @@
             <dia:string>#tipo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#tipo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#enum(manual,auto)#</dia:string>
+            <dia:string>#ENUMmanual,auto)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -1927,7 +1996,7 @@
             <dia:string>#Tipo de autorización#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Tipo de autorización#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1941,16 +2010,16 @@
             <dia:string>#idPrestador#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPrestador#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1961,19 +2030,19 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#idCobertura#</dia:string>
+            <dia:string>#idPrestacion#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -1987,16 +2056,16 @@
             <dia:string>#idAfiliado#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idAfiliado#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2017,13 +2086,13 @@
         <dia:point val="18.515,-1.74"/>
       </dia:attribute>
       <dia:attribute name="obj_bb">
         <dia:point val="18.515,-1.74"/>
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="18.465,-1.79;26.165,3.11"/>
+        <dia:rectangle val="18.465,-1.79;28.265,3.11"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
         <dia:point val="18.515,-1.74"/>
       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_corner">
         <dia:point val="18.515,-1.74"/>
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="7.5999999999999996"/>
+        <dia:real val="9.6999999999999993"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="4.8000000000000007"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="4.8000000000000007"/>


@@ -2035,7 +2104,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Región geográfica, cuya mínima unidad es un barrio.#</dia:string>
+        <dia:string>#Región geográfica, cuya mínima unidad es un barrio. Solo se puede dar de baja si no tiene un Prestador asociado.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -2112,13 +2181,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -2135,7 +2204,7 @@
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -2144,7 +2213,7 @@
             <dia:string>#Nombre de la Zona#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Nombre de la Zona#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2158,7 +2227,7 @@
             <dia:string>#descripcion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#descripcion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -2167,7 +2236,7 @@
             <dia:string>#Descripción de la Zona#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Descripción de la Zona#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2181,16 +2250,16 @@
             <dia:string>#idCap#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idCap#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#No puede ser NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2208,16 +2277,16 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O9">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O9">
       <dia:attribute name="obj_pos">

-        <dia:point val="47.615,28.65"/>
+        <dia:point val="47.665,31.75"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="47.565,28.6;56.315,35.9"/>
+        <dia:rectangle val="47.615,31.7;58.465,39"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="47.615,28.65"/>
+        <dia:point val="47.665,31.75"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="8.6500000000000004"/>
+        <dia:real val="10.75"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="7.1999999999999993"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="7.1999999999999993"/>


@@ -2229,7 +2298,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Persona esperando ser Afiliado a la obra social por un Promotor.#</dia:string>
+        <dia:string>#Persona esperando ser Afiliado a la obra social por un Promotor. Si se da de baja, hay que dar de baja en cascada la tabla Persona#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -2306,13 +2375,13 @@
             <dia:string>#idPersona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPersona#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -2329,16 +2398,16 @@
             <dia:string>#disponibilidad#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#disponibilidad#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Horario en el cual puede ser visitado (de nuevo, representación???).#</dia:string>
+            <dia:string>#Horario en el cual puede ser visitado expresado con texto libre#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2352,7 +2421,7 @@
             <dia:string>#familiares#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#familiares#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -2361,7 +2430,7 @@
             <dia:string>#Cantidad de integrantes del grupo familiar a afiliar.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Cantidad de integrantes del grupo familiar a afiliar.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2375,7 +2444,7 @@
             <dia:string>#observaciones#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#observaciones#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -2384,7 +2453,7 @@
             <dia:string>#Observaciones que puedan ser de utilidad para el Promotor.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Observaciones que puedan ser de utilidad para el Promotor.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2398,7 +2467,7 @@
             <dia:string>#pendiente#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#pendiente#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#bool#</dia:string>
+            <dia:string>#BOOL#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -2407,7 +2476,7 @@
             <dia:string>#Indica si el solicitante fue visitado o no.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Indica si el solicitante fue visitado o no.#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2421,16 +2490,16 @@
             <dia:string>#idPromotor#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPromotor#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#NULL si no está asignado a ningún Promotor#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2444,16 +2513,16 @@
             <dia:string>#idTitular#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idTitular#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#NULL si no se va a agregar a un grupo familiar de un Titular existente#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="1"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2471,13 +2540,13 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O10">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O10">
       <dia:attribute name="obj_pos">

-        <dia:point val="7.765,20.61"/>
+        <dia:point val="8.165,20.91"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="7.715,20.56;18.215,24.66"/>
+        <dia:rectangle val="8.115,20.86;18.615,24.96"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="7.765,20.61"/>
+        <dia:point val="8.165,20.91"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="10.4"/>
       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="10.4"/>


@@ -2569,13 +2638,13 @@
             <dia:string>#idAutorizacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idAutorizacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -2592,7 +2661,7 @@
             <dia:string>#observaciones#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#observaciones#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -2601,7 +2670,7 @@
             <dia:string>#Una descripcion coloquial del por qué se solicita la autorización#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Una descripcion coloquial del por qué se solicita la autorización#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2615,16 +2684,16 @@
             <dia:string>#fechaResolucion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaResolucion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Fecha en la que se aprobo/rechazo la autorizacion.#</dia:string>
+            <dia:string>#Fecha en la que se aprobo/rechazo la autorización. NULL si todavía no hay una resolución tomada.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2642,19 +2711,19 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O11">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O11">
       <dia:attribute name="obj_pos">

-        <dia:point val="-5.885,28.57"/>
+        <dia:point val="-5.635,33.07"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-5.935,28.52;7.265,35.82"/>
+        <dia:rectangle val="-5.685,33.02;7.615,39.52"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="-5.885,28.57"/>
+        <dia:point val="-5.635,33.07"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="13.1"/>
+        <dia:real val="13.199999999999999"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
       </dia:attribute>
       <dia:attribute name="elem_height">

-        <dia:real val="7.1999999999999993"/>
+        <dia:real val="6.4000000000000004"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Cobertura#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Cobertura#</dia:string>


@@ -2663,7 +2732,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Limitaciones de cobertura para un Plan y una Prestación determinada.#</dia:string>
+        <dia:string>#Limitaciones de cobertura para un Plan y una Prestación determinada. Es dado de baja cuando se da de baja el Plan al que pertenece.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -2737,16 +2806,16 @@
       <dia:attribute name="attributes">
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
       <dia:attribute name="attributes">
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#id#</dia:string>
+            <dia:string>#idPrestacion#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
           </dia:attribute>
           <dia:attribute name="value">

-            <dia:string>#PK#</dia:string>
+            <dia:string>#PK/FK#</dia:string>

           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -2760,16 +2829,16 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#tiempoPermanencia#</dia:string>
+            <dia:string>#idPlan#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Tiempo#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
           </dia:attribute>
           <dia:attribute name="value">

-            <dia:string>##</dia:string>
+            <dia:string>#PK/FK#</dia:string>

           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Antigüedad que debe tener el afiliado en el plan para ser cubierto. (años? meses?)#</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -2783,19 +2852,19 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#porcentaje#</dia:string>
+            <dia:string>#carencia#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#FLOAT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Porcentaje de la prestación cubierto.#</dia:string>
+            <dia:string>#Antigüedad que debe tener el afiliado en el plan para ser cubierto. Si es NULL no tiene tiempo de carencia#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2806,19 +2875,19 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#limiteAnual#</dia:string>
+            <dia:string>#porcentaje#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT(3)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Cantidad de prestaciones que se puede realizar por año (cero indica que no hay límite).#</dia:string>
+            <dia:string>#Porcentaje de la prestación cubierto.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2829,19 +2898,19 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#tipoAutorizacion#</dia:string>
+            <dia:string>#limiteAnual#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#enum(manual,auto)#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Indica el tipo de autorización que necesita para realizarse la prestación.#</dia:string>
+            <dia:string>#Cantidad de prestaciones que se puede realizar por año. Si es NULL no hay límite#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2852,42 +2921,19 @@
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">
         </dia:composite>
         <dia:composite type="umlattribute">
           <dia:attribute name="name">

-            <dia:string>#idPrestacion#</dia:string>
+            <dia:string>#tipoAutorizacion#</dia:string>

           </dia:attribute>
           <dia:attribute name="type">
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#ENUM(manual,auto)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
           </dia:attribute>
           <dia:attribute name="value">

-            <dia:string>#FK#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="comment">

             <dia:string>##</dia:string>
           </dia:attribute>
             <dia:string>##</dia:string>
           </dia:attribute>

-          <dia:attribute name="visibility">
-            <dia:enum val="0"/>
-          </dia:attribute>
-          <dia:attribute name="abstract">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="class_scope">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-        </dia:composite>
-        <dia:composite type="umlattribute">
-          <dia:attribute name="name">
-            <dia:string>#idPlan#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="type">
-            <dia:string>#int#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="value">
-            <dia:string>#FK#</dia:string>
-          </dia:attribute>

           <dia:attribute name="comment">
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Indica el tipo de autorización que necesita para realizarse la prestación.#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -2905,19 +2951,19 @@
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O12">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Class" version="0" id="O12">
       <dia:attribute name="obj_pos">

-        <dia:point val="-3.685,22.32"/>
+        <dia:point val="-2.735,26.67"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-3.735,22.27;2.165,26.37"/>
+        <dia:rectangle val="-2.785,26.62;5.265,31.52"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="-3.685,22.32"/>
+        <dia:point val="-2.735,26.67"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="5.7999999999999998"/>
+        <dia:real val="7.9499999999999993"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
       </dia:attribute>
       <dia:attribute name="elem_height">

-        <dia:real val="4"/>
+        <dia:real val="4.8000000000000007"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Categoria#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#Categoria#</dia:string>


@@ -2926,7 +2972,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Clasificación de las Prestaciones. (esto lo necesitamos por el codificador, no?)#</dia:string>
+        <dia:string>#Clasificación de las Prestaciones. Sólo puede ser dado de baja si no tiene Prestaciones asociadas.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -3003,13 +3049,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -3026,16 +3072,16 @@
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#codigo#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Identificador único (por codificador, no?)#</dia:string>
+            <dia:string>#Código de la categoría según el codificador#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="2"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3049,16 +3095,39 @@
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#nombre#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Nombre de la categoría.#</dia:string>
+            <dia:string>#Nombre de la categoría#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>
+          </dia:attribute>
+          <dia:attribute name="abstract">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="class_scope">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+        </dia:composite>
+        <dia:composite type="umlattribute">
+          <dia:attribute name="name">
+            <dia:string>#fechaBaja#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="type">
+            <dia:string>#DATE#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="value">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="comment">
+            <dia:string>#Si no es NULL, la Categoria fue dada de baja en la fecha indicada por este campo.#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="visibility">
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3076,14 +3145,14 @@
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O13">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O13">
       <dia:attribute name="obj_pos">

-        <dia:point val="7.215,35.27"/>
+        <dia:point val="7.515,35.77"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="7.165,26.95;10.825,36.12"/>
+        <dia:rectangle val="7.465,26.9;10.825,36.57"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="7.215,35.27"/>
-        <dia:point val="8.96521,35.27"/>
+        <dia:point val="7.515,35.77"/>
+        <dia:point val="8.96521,35.77"/>

         <dia:point val="8.96521,27.7"/>
         <dia:point val="10.475,27.7"/>
       </dia:attribute>
         <dia:point val="8.96521,27.7"/>
         <dia:point val="10.475,27.7"/>
       </dia:attribute>


@@ -3132,22 +3201,22 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O11" connection="21"/>
+        <dia:connection handle="0" to="O11" connection="11"/>

         <dia:connection handle="1" to="O4" connection="3"/>
       </dia:connections>
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O14">
       <dia:attribute name="obj_pos">
         <dia:connection handle="1" to="O4" connection="3"/>
       </dia:connections>
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O14">
       <dia:attribute name="obj_pos">

-        <dia:point val="20.025,27.7"/>
+        <dia:point val="20.175,27.7"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="19.975,26.95;21.95,30.6"/>
+        <dia:rectangle val="20.125,26.9;29.8,30.45"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="20.025,27.7"/>
+        <dia:point val="20.175,27.7"/>

         <dia:point val="20.8125,27.7"/>
         <dia:point val="20.8125,27.7"/>

-        <dia:point val="20.8125,29.75"/>
-        <dia:point val="21.6,29.75"/>
+        <dia:point val="20.8125,29.65"/>
+        <dia:point val="29.45,29.65"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -3195,21 +3264,21 @@
       </dia:attribute>
       <dia:connections>
         <dia:connection handle="0" to="O4" connection="4"/>
       </dia:attribute>
       <dia:connections>
         <dia:connection handle="0" to="O4" connection="4"/>

-        <dia:connection handle="1" to="O2" connection="20"/>
+        <dia:connection handle="1" to="O2" connection="18"/>

       </dia:connections>
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O15">
       <dia:attribute name="obj_pos">
       </dia:connections>
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O15">
       <dia:attribute name="obj_pos">

-        <dia:point val="26.115,2.56"/>
+        <dia:point val="28.215,2.56"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="26.065,-1.05;33.875,3.41"/>
+        <dia:rectangle val="28.165,-1.3;35.525,3.36"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="26.115,2.56"/>
-        <dia:point val="29.82,2.56"/>
-        <dia:point val="29.82,-0.3"/>
-        <dia:point val="33.525,-0.3"/>
+        <dia:point val="28.215,2.56"/>
+        <dia:point val="31.695,2.56"/>
+        <dia:point val="31.695,-0.5"/>
+        <dia:point val="35.175,-0.5"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -3259,78 +3328,16 @@
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O16">
       <dia:attribute name="obj_pos">
     </dia:object>
     <dia:object type="UML - Association" version="0" id="O16">
       <dia:attribute name="obj_pos">

-        <dia:point val="6.925,16.55"/>
-      </dia:attribute>
-      <dia:attribute name="obj_bb">
-        <dia:rectangle val="0.615,15.8;7.975,29.42"/>
-      </dia:attribute>
-      <dia:attribute name="orth_points">
-        <dia:point val="6.925,16.55"/>
-        <dia:point val="4.825,16.55"/>
-        <dia:point val="4.825,28.57"/>
-        <dia:point val="0.665,28.57"/>
-      </dia:attribute>
-      <dia:attribute name="orth_orient">
-        <dia:enum val="0"/>
-        <dia:enum val="1"/>
-        <dia:enum val="0"/>
-      </dia:attribute>
-      <dia:attribute name="autorouting">
-        <dia:boolean val="false"/>
-      </dia:attribute>
-      <dia:attribute name="name">
-        <dia:string>##</dia:string>
-      </dia:attribute>
-      <dia:attribute name="direction">
-        <dia:enum val="0"/>
-      </dia:attribute>
-      <dia:attribute name="ends">
-        <dia:composite>
-          <dia:attribute name="role">
-            <dia:string>##</dia:string>
-          </dia:attribute>
-          <dia:attribute name="multiplicity">
-            <dia:string># * #</dia:string>
-          </dia:attribute>
-          <dia:attribute name="arrow">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="aggregate">
-            <dia:enum val="0"/>
-          </dia:attribute>
-        </dia:composite>
-        <dia:composite>
-          <dia:attribute name="role">
-            <dia:string>##</dia:string>
-          </dia:attribute>
-          <dia:attribute name="multiplicity">
-            <dia:string>#1#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="arrow">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="aggregate">
-            <dia:enum val="0"/>
-          </dia:attribute>
-        </dia:composite>
-      </dia:attribute>
-      <dia:connections>
-        <dia:connection handle="0" to="O7" connection="28"/>
-        <dia:connection handle="1" to="O11" connection="1"/>
-      </dia:connections>
-    </dia:object>
-    <dia:object type="UML - Association" version="0" id="O17">
-      <dia:attribute name="obj_pos">
-        <dia:point val="-5.885,34.47"/>
+        <dia:point val="-5.635,34.97"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-6.975,14.4;-4.575,35.32"/>
+        <dia:rectangle val="-6.975,17.55;-4.625,35.77"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="-5.885,34.47"/>
-        <dia:point val="-6.925,34.47"/>
-        <dia:point val="-6.925,15.15"/>
-        <dia:point val="-4.925,15.15"/>
+        <dia:point val="-5.635,34.97"/>
+        <dia:point val="-6.925,34.97"/>
+        <dia:point val="-6.925,18.35"/>
+        <dia:point val="-4.975,18.35"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -3377,21 +3384,21 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O11" connection="18"/>
+        <dia:connection handle="0" to="O11" connection="8"/>

         <dia:connection handle="1" to="O3" connection="3"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O3" connection="3"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O18">
+    <dia:object type="UML - Association" version="0" id="O17">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="-5.075,9.78251"/>
+        <dia:point val="-5.125,10.9325"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-6.125,-0.9;1.85,10.6325"/>
+        <dia:rectangle val="-6.175,-0.95;1.85,11.7325"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="-5.075,9.78251"/>
-        <dia:point val="-6.075,9.78251"/>
-        <dia:point val="-6.075,-0.15"/>
+        <dia:point val="-5.125,10.9325"/>
+        <dia:point val="-6.125,10.9325"/>
+        <dia:point val="-6.125,-0.15"/>

         <dia:point val="1.5,-0.15"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:point val="1.5,-0.15"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">


@@ -3436,19 +3443,19 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O33" connection="8"/>
+        <dia:connection handle="0" to="O32" connection="8"/>

         <dia:connection handle="1" to="O5" connection="3"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O5" connection="3"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Class" version="0" id="O19">
+    <dia:object type="UML - Class" version="0" id="O18">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="20.915,33.8825"/>
+        <dia:point val="20.815,34.7325"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="20.865,33.8325;29.965,38.7325"/>
+        <dia:rectangle val="20.765,34.6825;29.865,39.5825"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="20.915,33.8825"/>
+        <dia:point val="20.815,34.7325"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="9"/>
       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="9"/>


@@ -3463,7 +3470,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Representa el período de tiempo que un afiliado estuvo en un plan.#</dia:string>
+        <dia:string>#Representa el período de tiempo que un afiliado estuvo en un plan. Se da de baja sólo al dar de baja un Afiliado.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -3540,13 +3547,13 @@
             <dia:string>#idAfiliado#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idAfiliado#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -3563,13 +3570,13 @@
             <dia:string>#idPlan#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPlan#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -3586,7 +3593,7 @@
             <dia:string>#fechaIngreso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaIngreso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -3595,7 +3602,7 @@
             <dia:string>#Fecha en que se dio de alta el plan#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Fecha en que se dio de alta el plan#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3609,16 +3616,16 @@
             <dia:string>#fechaEgreso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#fechaEgreso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#Fecha#</dia:string>
+            <dia:string>#DATE#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Fecha en la que el plan no rige mas para el afiliado#</dia:string>
+            <dia:string>#Fecha en la que el plan no rige mas para el afiliado. Si es el plan actual es NULL#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3634,18 +3641,18 @@
       </dia:attribute>
       <dia:attribute name="templates"/>
     </dia:object>
       </dia:attribute>
       <dia:attribute name="templates"/>
     </dia:object>

-    <dia:object type="UML - Class" version="0" id="O20">
+    <dia:object type="UML - Class" version="0" id="O19">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="20.8508,11.3575"/>
+        <dia:point val="22.4508,10.7575"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="20.8008,11.3075;31.9508,19.4075"/>
+        <dia:rectangle val="22.4008,10.7075;33.6008,18.8075"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="20.8508,11.3575"/>
+        <dia:point val="22.4508,10.7575"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
       </dia:attribute>
       <dia:attribute name="elem_width">

-        <dia:real val="11.049999999999999"/>
+        <dia:real val="11.1"/>

       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="8"/>
       </dia:attribute>
       <dia:attribute name="elem_height">
         <dia:real val="8"/>


@@ -3657,7 +3664,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>##</dia:string>
+        <dia:string>#Direccion de un domicilio. No se puede dar de baja directamente, se da de baja indirectamente al eliminar un Prestador, un Cap o una Persona.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -3734,13 +3741,13 @@
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#id#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -3757,7 +3764,7 @@
             <dia:string>#calle#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#calle#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -3766,7 +3773,7 @@
             <dia:string>#Calle del domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Calle del domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3780,7 +3787,7 @@
             <dia:string>#numero#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#numero#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -3789,7 +3796,7 @@
             <dia:string>#Número del domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Número del domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3803,16 +3810,16 @@
             <dia:string>#piso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#piso#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Piso del domicilio#</dia:string>
+            <dia:string>#Piso del domicilio. NULL si no aplica#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3826,16 +3833,16 @@
             <dia:string>#departamento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#departamento#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(255)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Departamento del domicilio#</dia:string>
+            <dia:string>#Departamento del domicilio. NULL si no aplica#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3849,7 +3856,7 @@
             <dia:string>#codigoPostal#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#codigoPostal#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string(8)#</dia:string>
+            <dia:string>#VARCHAR(8)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -3858,7 +3865,7 @@
             <dia:string>#Código postal del domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Código postal del domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3872,7 +3879,7 @@
             <dia:string>#provincia#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#provincia#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#enum([provincias])#</dia:string>
+            <dia:string>#ENUM([provincias])#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>


@@ -3881,7 +3888,7 @@
             <dia:string>#Provincia donde se encuentra el domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:string>#Provincia donde se encuentra el domicilio#</dia:string>
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3895,16 +3902,16 @@
             <dia:string>#telefono#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#telefono#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#string#</dia:string>
+            <dia:string>#VARCHAR(30)#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>##</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>#Teléfono del domicilio#</dia:string>
+            <dia:string>#Teléfono del domicilio. NULL si no aplica#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
           </dia:attribute>
           <dia:attribute name="visibility">

-            <dia:enum val="0"/>
+            <dia:enum val="3"/>

           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="abstract">
             <dia:boolean val="false"/>


@@ -3920,19 +3927,19 @@
       </dia:attribute>
       <dia:attribute name="templates"/>
     </dia:object>
       </dia:attribute>
       <dia:attribute name="templates"/>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O21">
+    <dia:object type="UML - Association" version="0" id="O20">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="26.3758,19.3575"/>
+        <dia:point val="28.0008,18.7575"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="26.3258,15.15;39.2,21.7575"/>
+        <dia:rectangle val="27.9508,15.25;39.1,21.1575"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="26.3758,19.3575"/>
-        <dia:point val="26.3758,20.3575"/>
-        <dia:point val="32.6129,20.3575"/>
-        <dia:point val="32.6129,15.9"/>
-        <dia:point val="38.85,15.9"/>
+        <dia:point val="28.0008,18.7575"/>
+        <dia:point val="28.0008,20.3575"/>
+        <dia:point val="36.875,20.3575"/>
+        <dia:point val="36.875,16.05"/>
+        <dia:point val="38.75,16.05"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>


@@ -3940,6 +3947,9 @@
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>

+      <dia:attribute name="autorouting">
+        <dia:boolean val="false"/>
+      </dia:attribute>

       <dia:attribute name="name">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>##</dia:string>
       </dia:attribute>


@@ -3977,21 +3987,21 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O20" connection="6"/>
+        <dia:connection handle="0" to="O19" connection="6"/>

         <dia:connection handle="1" to="O1" connection="26"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O1" connection="26"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O22">
+    <dia:object type="UML - Association" version="0" id="O21">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="5.65,4.75"/>
+        <dia:point val="5.65,5.55"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="5.6,4.7;7.275,16.6"/>
+        <dia:rectangle val="5.6,5.5;7.825,16.55"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="5.65,4.75"/>
+        <dia:point val="5.65,5.55"/>

         <dia:point val="5.65,15.75"/>
         <dia:point val="5.65,15.75"/>

-        <dia:point val="6.925,15.75"/>
+        <dia:point val="7.475,15.75"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>


@@ -4038,18 +4048,18 @@
         <dia:connection handle="1" to="O7" connection="26"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O7" connection="26"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O23">
+    <dia:object type="UML - Association" version="0" id="O22">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="17.975,17.35"/>
+        <dia:point val="20.625,17.35"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="17.925,16.6;21.95,24.6"/>
+        <dia:rectangle val="20.575,16.55;29.8,25.25"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="17.975,17.35"/>
-        <dia:point val="19.515,17.35"/>
-        <dia:point val="19.515,23.75"/>
-        <dia:point val="21.6,23.75"/>
+        <dia:point val="20.625,17.35"/>
+        <dia:point val="21.8706,17.35"/>
+        <dia:point val="21.8706,24.45"/>
+        <dia:point val="29.45,24.45"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4100,18 +4110,18 @@
         <dia:connection handle="1" to="O2" connection="3"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O2" connection="3"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O24">
+    <dia:object type="UML - Association" version="0" id="O23">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="31.9008,12.0575"/>
+        <dia:point val="33.5508,11.4575"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="31.8508,2.55;33.875,12.9075"/>
+        <dia:rectangle val="33.5008,3.1;35.525,12.2575"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="31.9008,12.0575"/>
-        <dia:point val="32.7129,12.0575"/>
-        <dia:point val="32.7129,3.3"/>
-        <dia:point val="33.525,3.3"/>
+        <dia:point val="33.5508,11.4575"/>
+        <dia:point val="34.3629,11.4575"/>
+        <dia:point val="34.3629,3.9"/>
+        <dia:point val="35.175,3.9"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4155,28 +4165,31 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O20" connection="4"/>
-        <dia:connection handle="1" to="O6" connection="14"/>
+        <dia:connection handle="0" to="O19" connection="4"/>
+        <dia:connection handle="1" to="O6" connection="16"/>

       </dia:connections>
     </dia:object>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O25">
+    <dia:object type="UML - Association" version="0" id="O24">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="47.615,35.35"/>
+        <dia:point val="47.665,38.45"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="30.2,26.6;48.315,36.2"/>
+        <dia:rectangle val="38.05,27.25;48.365,39.25"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="47.615,35.35"/>
-        <dia:point val="38.9325,35.35"/>
-        <dia:point val="38.9325,27.35"/>
-        <dia:point val="30.25,27.35"/>
+        <dia:point val="47.665,38.45"/>
+        <dia:point val="41.0501,38.45"/>
+        <dia:point val="41.0501,28.05"/>
+        <dia:point val="38.1,28.05"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>

+      <dia:attribute name="autorouting">
+        <dia:boolean val="false"/>
+      </dia:attribute>

       <dia:attribute name="name">
         <dia:string>#titularidad#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#titularidad#</dia:string>
       </dia:attribute>


@@ -4218,19 +4231,19 @@
         <dia:connection handle="1" to="O2" connection="15"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O2" connection="15"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O26">
+    <dia:object type="UML - Association" version="0" id="O25">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="12.45,17.85"/>
+        <dia:point val="14.05,17.85"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="6.325,17.8;13.15,23.36"/>
+        <dia:rectangle val="6.325,17.8;14.75,23.61"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="12.45,17.85"/>
-        <dia:point val="12.45,19.3325"/>
+        <dia:point val="14.05,17.85"/>
+        <dia:point val="14.05,19.3325"/>

         <dia:point val="6.375,19.3325"/>
         <dia:point val="6.375,19.3325"/>

-        <dia:point val="6.375,22.51"/>
-        <dia:point val="7.765,22.51"/>
+        <dia:point val="6.375,22.81"/>
+        <dia:point val="8.165,22.81"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>


@@ -4282,19 +4295,19 @@
         <dia:connection handle="1" to="O10" connection="8"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O10" connection="8"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O27">
+    <dia:object type="UML - Association" version="0" id="O26">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="51.25,16.4"/>
+        <dia:point val="51.2,16.55"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="46.565,16.35;51.95,31.4"/>
+        <dia:rectangle val="46.0501,16.5;51.9,34.45"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="51.25,16.4"/>
-        <dia:point val="51.25,17.4"/>
-        <dia:point val="46.615,17.4"/>
-        <dia:point val="46.615,30.55"/>
-        <dia:point val="47.615,30.55"/>
+        <dia:point val="51.2,16.55"/>
+        <dia:point val="51.2,19.46"/>
+        <dia:point val="46.1001,19.46"/>
+        <dia:point val="46.1001,33.65"/>
+        <dia:point val="47.665,33.65"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="1"/>


@@ -4302,6 +4315,9 @@
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>

+      <dia:attribute name="autorouting">
+        <dia:boolean val="false"/>
+      </dia:attribute>

       <dia:attribute name="name">
         <dia:string>#herencia#</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>#herencia#</dia:string>
       </dia:attribute>


@@ -4343,21 +4359,28 @@
         <dia:connection handle="1" to="O9" connection="8"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O9" connection="8"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O28">
+    <dia:object type="UML - Association" version="0" id="O27">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="38.85,15.1"/>
+        <dia:point val="38.75,15.25"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="37.625,3.75;39.2,15.95"/>
+        <dia:rectangle val="37.7,4.35;40.725,16.05"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="38.85,15.1"/>
-        <dia:point val="37.675,15.1"/>
-        <dia:point val="37.675,3.8"/>
+        <dia:point val="38.75,15.25"/>
+        <dia:point val="37.75,15.25"/>
+        <dia:point val="37.75,6.06"/>
+        <dia:point val="40.025,6.06"/>
+        <dia:point val="40.025,4.4"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
         <dia:enum val="1"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
         <dia:enum val="1"/>

+        <dia:enum val="0"/>
+        <dia:enum val="1"/>
+      </dia:attribute>
+      <dia:attribute name="autorouting">
+        <dia:boolean val="false"/>

       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="name">
         <dia:string>##</dia:string>


@@ -4400,17 +4423,17 @@
         <dia:connection handle="1" to="O6" connection="6"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O6" connection="6"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O29">
+    <dia:object type="UML - Association" version="0" id="O28">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="30.25,24.95"/>
+        <dia:point val="38.1,25.65"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="30.2,16.35;45.75,25.8"/>
+        <dia:rectangle val="38.05,16.5;45.675,26.45"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="30.25,24.95"/>
-        <dia:point val="45.05,24.95"/>
-        <dia:point val="45.05,16.4"/>
+        <dia:point val="38.1,25.65"/>
+        <dia:point val="44.975,25.65"/>
+        <dia:point val="44.975,16.55"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4457,17 +4480,17 @@
         <dia:connection handle="1" to="O1" connection="6"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O1" connection="6"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O30">
+    <dia:object type="UML - Association" version="0" id="O29">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="20.915,36.5825"/>
+        <dia:point val="20.815,37.4325"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="15.2,33.35;21.265,37.4325"/>
+        <dia:rectangle val="15.275,33.35;21.165,38.2325"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="20.915,36.5825"/>
-        <dia:point val="15.25,36.5825"/>
-        <dia:point val="15.25,33.4"/>
+        <dia:point val="20.815,37.4325"/>
+        <dia:point val="15.325,37.4325"/>
+        <dia:point val="15.325,33.4"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4510,22 +4533,22 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O19" connection="10"/>
+        <dia:connection handle="0" to="O18" connection="10"/>

         <dia:connection handle="1" to="O4" connection="6"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O4" connection="6"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O31">
+    <dia:object type="UML - Association" version="0" id="O30">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="-4.925,17.95"/>
+        <dia:point val="-4.975,22.75"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-5.975,17.2;-3.335,23.87"/>
+        <dia:rectangle val="-6.025,21.95;-2.385,28.17"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="-4.925,17.95"/>
-        <dia:point val="-5.925,17.95"/>
-        <dia:point val="-5.925,23.02"/>
-        <dia:point val="-3.685,23.02"/>
+        <dia:point val="-4.975,22.75"/>
+        <dia:point val="-5.975,22.75"/>
+        <dia:point val="-5.975,27.37"/>
+        <dia:point val="-2.735,27.37"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4569,22 +4592,22 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O3" connection="12"/>
+        <dia:connection handle="0" to="O3" connection="16"/>

         <dia:connection handle="1" to="O12" connection="3"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O12" connection="3"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O32">
+    <dia:object type="UML - Association" version="0" id="O31">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="20.8508,12.0575"/>
+        <dia:point val="22.4508,11.4575"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="9.75,3.5;21.2008,12.9075"/>
+        <dia:rectangle val="9.75,4.25;22.8008,12.2575"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="20.8508,12.0575"/>
-        <dia:point val="20.175,12.0575"/>
-        <dia:point val="20.175,4.25"/>
-        <dia:point val="9.8,4.25"/>
+        <dia:point val="22.4508,11.4575"/>
+        <dia:point val="21.7206,11.4575"/>
+        <dia:point val="21.7206,5.05"/>
+        <dia:point val="9.8,5.05"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4631,19 +4654,19 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O20" connection="3"/>
-        <dia:connection handle="1" to="O5" connection="17"/>
+        <dia:connection handle="0" to="O19" connection="3"/>
+        <dia:connection handle="1" to="O5" connection="19"/>

       </dia:connections>
     </dia:object>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Class" version="0" id="O33">
+    <dia:object type="UML - Class" version="0" id="O32">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="-5.075,7.88251"/>
+        <dia:point val="-5.125,9.03251"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-5.125,7.83251;4.675,11.1325"/>
+        <dia:rectangle val="-5.175,8.98251;4.625,12.2825"/>

       </dia:attribute>
       <dia:attribute name="elem_corner">
       </dia:attribute>
       <dia:attribute name="elem_corner">

-        <dia:point val="-5.075,7.88251"/>
+        <dia:point val="-5.125,9.03251"/>

       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="9.6999999999999993"/>
       </dia:attribute>
       <dia:attribute name="elem_width">
         <dia:real val="9.6999999999999993"/>


@@ -4658,7 +4681,7 @@
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">
         <dia:string>##</dia:string>
       </dia:attribute>
       <dia:attribute name="comment">

-        <dia:string>#Relación N a M entre Prestadores y Prestaciones#</dia:string>
+        <dia:string>#Relación N a M entre Prestadores y Prestaciones. Se da de baja sólo cuando se da de baja un Prestador o una Prestación.#</dia:string>

       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>
       </dia:attribute>
       <dia:attribute name="abstract">
         <dia:boolean val="false"/>


@@ -4735,13 +4758,13 @@
             <dia:string>#idPrestador#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPrestador#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -4758,13 +4781,13 @@
             <dia:string>#idPrestacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
             <dia:string>#idPrestacion#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">

-            <dia:string>#int#</dia:string>
+            <dia:string>#INT#</dia:string>

           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">
           </dia:attribute>
           <dia:attribute name="value">
             <dia:string>#PK/FK#</dia:string>
           </dia:attribute>
           <dia:attribute name="comment">

-            <dia:string>##</dia:string>
+            <dia:string>#Clave primaria interna de la base de datos#</dia:string>

           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>
           </dia:attribute>
           <dia:attribute name="visibility">
             <dia:enum val="0"/>


@@ -4783,20 +4806,20 @@
       </dia:attribute>
       <dia:attribute name="templates"/>
     </dia:object>
       </dia:attribute>
       <dia:attribute name="templates"/>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O34">
+    <dia:object type="UML - Association" version="0" id="O33">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="-5.075,10.5825"/>
+        <dia:point val="-5.125,11.7325"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="-6.125,9.8325;4.425,16"/>
+        <dia:rectangle val="-6.175,10.9325;4.375,19.15"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="-5.075,10.5825"/>
-        <dia:point val="-6.075,10.5825"/>
-        <dia:point val="-6.075,12.8663"/>
-        <dia:point val="4.375,12.8663"/>
-        <dia:point val="4.375,15.15"/>
-        <dia:point val="3.375,15.15"/>
+        <dia:point val="-5.125,11.7325"/>
+        <dia:point val="-6.125,11.7325"/>
+        <dia:point val="-6.125,15.0412"/>
+        <dia:point val="4.325,15.0412"/>
+        <dia:point val="4.325,18.35"/>
+        <dia:point val="3.325,18.35"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -4842,20 +4865,20 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O33" connection="10"/>
+        <dia:connection handle="0" to="O32" connection="10"/>

         <dia:connection handle="1" to="O3" connection="4"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O3" connection="4"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O35">
+    <dia:object type="UML - Association" version="0" id="O34">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="51.25,7.5"/>
+        <dia:point val="51.2,7.65"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="47.8651,6.75;58.7651,27.45"/>
+        <dia:rectangle val="47.8651,6.85;58.7651,27.4"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="51.25,7.5"/>
-        <dia:point val="58.7151,7.5"/>
+        <dia:point val="51.2,7.65"/>
+        <dia:point val="58.7151,7.65"/>

         <dia:point val="58.7151,21.2575"/>
         <dia:point val="47.9151,21.2575"/>
         <dia:point val="47.9151,26.6"/>
         <dia:point val="58.7151,21.2575"/>
         <dia:point val="47.9151,21.2575"/>
         <dia:point val="47.9151,26.6"/>


@@ -4912,16 +4935,16 @@
         <dia:connection handle="1" to="O0" connection="8"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O0" connection="8"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O36">
+    <dia:object type="UML - Association" version="0" id="O35">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="56.265,34.55"/>
+        <dia:point val="58.415,37.65"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="56.215,24.65;59.75,35.4"/>
+        <dia:rectangle val="58.365,24.6;59.75,38.45"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="56.265,34.55"/>
-        <dia:point val="59.65,34.55"/>
+        <dia:point val="58.415,37.65"/>
+        <dia:point val="59.65,37.65"/>

         <dia:point val="59.65,25.4"/>
         <dia:point val="58.65,25.4"/>
       </dia:attribute>
         <dia:point val="59.65,25.4"/>
         <dia:point val="58.65,25.4"/>
       </dia:attribute>


@@ -4971,19 +4994,19 @@
         <dia:connection handle="1" to="O0" connection="4"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O0" connection="4"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O37">
+    <dia:object type="UML - Association" version="0" id="O36">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="21.6,30.55"/>
+        <dia:point val="29.45,30.45"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="20.55,29.8;26.625,33.45"/>
+        <dia:rectangle val="27.9501,29.65;34.475,33.35"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="21.6,30.55"/>
-        <dia:point val="20.6,30.55"/>
-        <dia:point val="20.6,32.8075"/>
-        <dia:point val="25.925,32.8075"/>
-        <dia:point val="25.925,31.05"/>
+        <dia:point val="29.45,30.45"/>
+        <dia:point val="28.0001,30.45"/>
+        <dia:point val="28.0001,32.8075"/>
+        <dia:point val="33.775,32.8075"/>
+        <dia:point val="33.775,30.95"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>
       </dia:attribute>
       <dia:attribute name="orth_orient">
         <dia:enum val="0"/>


@@ -5031,25 +5054,23 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O2" connection="22"/>
+        <dia:connection handle="0" to="O2" connection="20"/>

         <dia:connection handle="1" to="O2" connection="6"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O2" connection="6"/>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O38">
+    <dia:object type="UML - Association" version="0" id="O37">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="30.25,31.05"/>
+        <dia:point val="38.1,30.95"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="29.865,30.3;38,36.6325"/>
+        <dia:rectangle val="29.765,30.9;38.8,37.4325"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="30.25,31.05"/>
-        <dia:point val="31.25,31.05"/>
-        <dia:point val="31.25,35.7825"/>
-        <dia:point val="29.915,35.7825"/>
+        <dia:point val="38.1,30.95"/>
+        <dia:point val="38.1,36.6325"/>
+        <dia:point val="29.815,36.6325"/>

       </dia:attribute>
       <dia:attribute name="orth_orient">
       </dia:attribute>
       <dia:attribute name="orth_orient">

-        <dia:enum val="0"/>

         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>
         <dia:enum val="1"/>
         <dia:enum val="0"/>
       </dia:attribute>


@@ -5091,19 +5112,19 @@
       </dia:attribute>
       <dia:connections>
         <dia:connection handle="0" to="O2" connection="7"/>
       </dia:attribute>
       <dia:connections>
         <dia:connection handle="0" to="O2" connection="7"/>

-        <dia:connection handle="1" to="O19" connection="9"/>
+        <dia:connection handle="1" to="O18" connection="9"/>

       </dia:connections>
     </dia:object>
       </dia:connections>
     </dia:object>

-    <dia:object type="UML - Association" version="0" id="O39">
+    <dia:object type="UML - Association" version="0" id="O38">

       <dia:attribute name="obj_pos">
       <dia:attribute name="obj_pos">

-        <dia:point val="9.8,3.45"/>
+        <dia:point val="9.8,4.25"/>

       </dia:attribute>
       <dia:attribute name="obj_bb">
       </dia:attribute>
       <dia:attribute name="obj_bb">

-        <dia:rectangle val="9.75,-1.79;18.865,4.3"/>
+        <dia:rectangle val="9.75,-1.84;18.865,5.05"/>

       </dia:attribute>
       <dia:attribute name="orth_points">
       </dia:attribute>
       <dia:attribute name="orth_points">

-        <dia:point val="9.8,3.45"/>
-        <dia:point val="14.1575,3.45"/>
+        <dia:point val="9.8,4.25"/>
+        <dia:point val="14.1575,4.25"/>

         <dia:point val="14.1575,-1.04"/>
         <dia:point val="18.515,-1.04"/>
       </dia:attribute>
         <dia:point val="14.1575,-1.04"/>
         <dia:point val="18.515,-1.04"/>
       </dia:attribute>


@@ -5149,9 +5170,125 @@
         </dia:composite>
       </dia:attribute>
       <dia:connections>
         </dia:composite>
       </dia:attribute>
       <dia:connections>

-        <dia:connection handle="0" to="O5" connection="15"/>
+        <dia:connection handle="0" to="O5" connection="17"/>

         <dia:connection handle="1" to="O8" connection="3"/>
       </dia:connections>
     </dia:object>
         <dia:connection handle="1" to="O8" connection="3"/>
       </dia:connections>
     </dia:object>

+    <dia:object type="UML - Association" version="0" id="O39">
+      <dia:attribute name="obj_pos">
+        <dia:point val="7.475,16.55"/>
+      </dia:attribute>
+      <dia:attribute name="obj_bb">
+        <dia:rectangle val="-0.875,15.75;7.825,25.65"/>
+      </dia:attribute>
+      <dia:attribute name="orth_points">
+        <dia:point val="7.475,16.55"/>
+        <dia:point val="5.40453,16.55"/>
+        <dia:point val="5.40453,24.25"/>
+        <dia:point val="-0.825,24.25"/>
+        <dia:point val="-0.825,23.25"/>
+      </dia:attribute>
+      <dia:attribute name="orth_orient">
+        <dia:enum val="0"/>
+        <dia:enum val="1"/>
+        <dia:enum val="0"/>
+        <dia:enum val="1"/>
+      </dia:attribute>
+      <dia:attribute name="autorouting">
+        <dia:boolean val="false"/>
+      </dia:attribute>
+      <dia:attribute name="name">
+        <dia:string>##</dia:string>
+      </dia:attribute>
+      <dia:attribute name="direction">
+        <dia:enum val="0"/>
+      </dia:attribute>
+      <dia:attribute name="ends">
+        <dia:composite>
+          <dia:attribute name="role">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="multiplicity">
+            <dia:string>#*#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="arrow">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="aggregate">
+            <dia:enum val="0"/>
+          </dia:attribute>
+        </dia:composite>
+        <dia:composite>
+          <dia:attribute name="role">
+            <dia:string>##</dia:string>
+          </dia:attribute>
+          <dia:attribute name="multiplicity">
+            <dia:string>#1#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="arrow">
+            <dia:boolean val="false"/>
+          </dia:attribute>
+          <dia:attribute name="aggregate">
+            <dia:enum val="0"/>
+          </dia:attribute>
+        </dia:composite>
+      </dia:attribute>
+      <dia:connections>
+        <dia:connection handle="0" to="O7" connection="28"/>
+        <dia:connection handle="1" to="O3" connection="6"/>
+      </dia:connections>
+    </dia:object>
+    <dia:object type="UML - Note" version="0" id="O40">
+      <dia:attribute name="obj_pos">
+        <dia:point val="45.7001,-1.415"/>
+      </dia:attribute>
+      <dia:attribute name="obj_bb">
+        <dia:rectangle val="45.6501,-1.465;59.6001,5.935"/>
+      </dia:attribute>
+      <dia:attribute name="elem_corner">
+        <dia:point val="45.7001,-1.415"/>
+      </dia:attribute>
+      <dia:attribute name="elem_width">
+        <dia:real val="13.85"/>
+      </dia:attribute>
+      <dia:attribute name="elem_height">
+        <dia:real val="7.2999999999999998"/>
+      </dia:attribute>
+      <dia:attribute name="line_colour">
+        <dia:color val="#000000"/>
+      </dia:attribute>
+      <dia:attribute name="fill_colour">
+        <dia:color val="#ffffff"/>
+      </dia:attribute>
+      <dia:attribute name="text">
+        <dia:composite type="text">
+          <dia:attribute name="string">
+            <dia:string>#Las claves primarias naturales se
+representan con un # (el conjunto de
+atributos marcados con # en una tabla
+componen la clave primaria natural).
+Cada tabla tiene un indice compuesto
+por estos atributos.
+Para mejor legibilidad, a las PK las
+antecede un signo + y las FK un -.#</dia:string>
+          </dia:attribute>
+          <dia:attribute name="font">
+            <dia:font family="monospace" style="0" name="Courier"/>
+          </dia:attribute>
+          <dia:attribute name="height">
+            <dia:real val="0.80000000000000004"/>
+          </dia:attribute>
+          <dia:attribute name="pos">
+            <dia:point val="46.0501,-0.215"/>
+          </dia:attribute>
+          <dia:attribute name="color">
+            <dia:color val="#000000"/>
+          </dia:attribute>
+          <dia:attribute name="alignment">
+            <dia:enum val="0"/>
+          </dia:attribute>
+        </dia:composite>
+      </dia:attribute>
+    </dia:object>

   </dia:layer>
 </dia:diagram>
   </dia:layer>
 </dia:diagram>