1) Cambio Prestacion.Codigo a VARCHAR(8). en el XLS que pasó Clark son a lo sumo...

2) Prestador.CUIT lo paso de int a VARCHAR(11) --> se almacenaría sin los guiones:
12-12345678-1 --> se almacenaría 12123456781

diff --git a/diagramas/der.dia b/diagramas/der.dia
index 5d3793559f267d7b9141d8913f8b3fe5bc6af2de..b2805a1c766db91e38f276a71ba24d16b0f61214 100644 (file)
--- a/diagramas/der.dia
+++ b/diagramas/der.dia
@@ -912,7 +912,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>#VARCHAR(8)#</dia:string>

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


@@ -1369,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>


@@ -4816,8 +4816,8 @@
       <dia:attribute name="orth_points">
         <dia:point val="-5.125,11.7325"/>
         <dia:point val="-6.125,11.7325"/>
       <dia:attribute name="orth_points">
         <dia:point val="-5.125,11.7325"/>
         <dia:point val="-6.125,11.7325"/>

-        <dia:point val="-6.125,15.0413"/>
-        <dia:point val="4.325,15.0413"/>
+        <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:point val="4.325,18.35"/>
         <dia:point val="3.325,18.35"/>
       </dia:attribute>