Modelado de Procesos

<?xml version="1.0" encoding="utf-8" ?>
<sql>
<datatypes db="mysql">
<group label="Numeric" color="rgb(238,238,170)">
<type label="Integer" length="0" sql="INTEGER" re="INT" quote=""/>
<type label="Decimal" length="1" sql="DECIMAL" re="DEC" quote=""/>
<type label="Single precision" length="0" sql="FLOAT" quote=""/>
<type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote=""/>
</group>

<group label="Character" color="rgb(255,200,200)">
<type label="Char" length="1" sql="CHAR" quote="'"/>
<type label="Varchar" length="1" sql="VARCHAR" quote="'"/>
<type label="Text" length="0" sql="MEDIUMTEXT" re="TEXT" quote="'"/>
<type label="Binary" length="1" sql="BINARY" quote="'"/>
<type label="Varbinary" length="1" sql="VARBINARY" quote="'"/>
<type label="BLOB" length="0" sql="BLOB" re="BLOB" quote="'"/>
</group>

<group label="Date &amp; Time" color="rgb(200,255,200)">
<type label="Date" length="0" sql="DATE" quote="'"/>
<type label="Time" length="0" sql="TIME" quote="'"/>
<type label="Datetime" length="0" sql="DATETIME" quote="'"/>
<type label="Year" length="0" sql="YEAR" quote=""/>
<type label="Timestamp" length="0" sql="TIMESTAMP" quote="'"/>
</group>

<group label="Miscellaneous" color="rgb(200,200,255)">
<type label="ENUM" length="1" sql="ENUM" quote=""/>
<type label="SET" length="1" sql="SET" quote=""/>
</group>
</datatypes><table x="826" y="370" name="PRODUCTOS FACTURADOS">
<row name="id_prod_facturados" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="FACTURA" row="id_prod_facturados" />
</row>
<row name="descripcion_prod" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="cant_unit" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="precio_unit" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="costo_total" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id_prod_facturados</part>
</key>
</table>
<table x="378" y="331" name="PROVEEDOR">
<row name="id_proveedor" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="nombre" null="1" autoincrement="0">
<datatype>CHAR</datatype>
<default>NULL</default></row>
<row name="e-mail" null="1" autoincrement="0">
<datatype>CHAR</datatype>
<default>NULL</default></row>
<row name="direccion" null="1" autoincrement="0">
<datatype>CHAR</datatype>
<default>NULL</default></row>
<row name="telefono" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="forma_de_pago" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="id_num_de_orden" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="ORDEN DE COMPRA" row="id_num_de_orden" />
</row>
<row name="id_num_factura" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id_proveedor</part>
<part>id_num_factura</part>
</key>
</table>
<table x="633" y="68" name="FACTURA">
<row name="id_num_factura" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="PROVEEDOR" row="id_num_factura" />
</row>
<row name="fecha_factura" null="1" autoincrement="0">
<datatype>DATE</datatype>
<default>NULL</default></row>
<row name="cant_unit" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="precio_unit" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="costo_total" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="impuestos" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="id_num_de_orden" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default><relation table="ORDEN DE COMPRA" row="id_num_de_orden" />
</row>
<row name="id_proveedor" null="1" autoincrement="0">
<datatype>CHAR</datatype>
<default>NULL</default></row>
<row name="id_prod_facturados" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="forma_de_pago" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id_num_factura</part>
<part>id_prod_facturados</part>
</key>
</table>
<table x="55" y="51" name="ORDEN DE COMPRA">
<row name="id_num_de_orden" null="1" autoincrement="1">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="descripcion_prod" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="cant_unit" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="precio_unit" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="costo_total" null="1" autoincrement="0">
<datatype>INTEGER</datatype>
<default>NULL</default></row>
<row name="fecha_orden" null="1" autoincrement="0">
<datatype>DATE</datatype>
<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>id_num_de_orden</part>
</key>
<key type="INDEX" name="">
<part>id_num_de_orden</part>
<part>cant_unit</part>
<part>fecha_orden</part>
</key>
</table>
</sql>

 

<?xml version="1.0" encoding="utf-8" ?><sql><datatypes db="mysql"> <group label="Numeric" color="rgb(238,238,170)"> <type label="Integer" length="0" sql="INTEGER" re="INT" quote=""/> <type label="Decimal" length="1" sql="DECIMAL" re="DEC" quote=""/> <type label="Single precision" length="0" sql="FLOAT" quote=""/> <type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote=""/> </group> <group label="Character" color="rgb(255,200,200)"> <type label="Char" length="1" sql="CHAR" quote="'"/> <type label="Varchar" length="1" sql="VARCHAR" quote="'"/> <type label="Text" length="0" sql="MEDIUMTEXT" re="TEXT" quote="'"/> <type label="Binary" length="1" sql="BINARY" quote="'"/> <type label="Varbinary" length="1" sql="VARBINARY" quote="'"/> <type label="BLOB" length="0" sql="BLOB" re="BLOB" quote="'"/> </group> <group label="Date &amp; Time" color="rgb(200,255,200)"> <type label="Date" length="0" sql="DATE" quote="'"/> <type label="Time" length="0" sql="TIME" quote="'"/> <type label="Datetime" length="0" sql="DATETIME" quote="'"/> <type label="Year" length="0" sql="YEAR" quote=""/> <type label="Timestamp" length="0" sql="TIMESTAMP" quote="'"/> </group> <group label="Miscellaneous" color="rgb(200,200,255)"> <type label="ENUM" length="1" sql="ENUM" quote=""/> <type label="SET" length="1" sql="SET" quote=""/> </group></datatypes><table x="103" y="71" name="Aportes"><row name="id_FECLIBA" null="1" autoincrement="1"><datatype>INTEGER</datatype><default>NULL</default></row><key type="PRIMARY" name=""><part>id_FECLIBA</part></key></table><table x="355" y="80" name="Prestaciones (sem)"><row name="id_código prestaciones" null="1" autoincrement="1"><datatype>INTEGER</datatype><default>NULL</default><relation table="Factura" row="id_factura" /></row><row name="consultas medicas" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default></row><row name="Estudios" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default></row><row name="radiografias" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default></row><row name="operaciones" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default></row><row name="id_FECLIBA_Aportes" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default><relation table="Aportes" row="id_FECLIBA" /></row><key type="PRIMARY" name=""><part>id_código prestaciones</part></key></table><table x="742" y="99" name="Factura"><row name="id_factura" null="1" autoincrement="1"><datatype>INTEGER</datatype><default>NULL</default></row><row name="Detalle" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default></row><row name="Prestaciones aceptadas" null="1" autoincrement="0"><datatype>INTEGER</datatype><default>NULL</default></row><key type="PRIMARY" name=""><part>id_factura</part></key></table></sql>