<div class="gmail_extra">Leo! gracias a tus correcciones mejoré mi BD, espero que esté mejor y en cuanto este "perfecta" corregiré mi SRS.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Me surgió una duda habiendo tantos tipos de datos numéricos: ¿ es conveniente utilizar FLOAT para almacenar precios y costos ? .</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Para almacenar numeros de CUIT y TELEFONO utilizo INT en el primero (porq mantiene siempre la misma estructura) y VARCHAR en el segundo (porq me interesa almacenar guiones y otros simbolos). Te parece bien o pensas que puede surgir alguna complicacion?</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Saludos. </div><div class="gmail_extra"><br><br><div class="gmail_quote"><div class="gmail_quote">ARTICULOS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDTIPOIVA tinyint ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NOMBRE varchar(100) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCATEGORIA int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>COSTO decimal(10,4) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>PRECIO decimal(10,4),<span class="Apple-tab-span" style="white-space:pre"> </span></div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DESCRIPCION TEXT </div>
<div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">ART_TIPOIVA (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDTIPOIVA tinyint ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>TIPOIVA varchar(50),</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>TASA float (2,4)</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">ARTICULOS_CATEGORIAS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>CATEGORIA varchar(100) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DESCRIPCION TEXT</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">CLIENTES (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>RAZON varchar(100) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCONDIVA tinyint ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>CUIT int ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>EMAIL varchar(100) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>OTROS TEXT</div><div class="gmail_quote">)</div>
<div class="gmail_quote"><br></div><div class="gmail_quote">CLI_DIRECCIONES (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DIRECCION varchar (50) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDLOCALIDAD int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCLIENTE int</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">CLI_TELEFONOS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDTIPO tinyint,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NUMERO varchar(50) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCLIENTE int(10)</div>
<div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">PROVEEDORES (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>RAZON varchar(100) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>EMAIL varchar(100) ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>WEB varchar(100) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCONDIVA smallint ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>CUIT tinyint ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>OTROS TEXT</div><div class="gmail_quote">)</div><div class="gmail_quote">
<br></div><div class="gmail_quote">PRO_DOMICILIOS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DIRECCION varchar(50) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDLOCALIDAD int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDPROVEEDOR int</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">PRO_TELEFONOS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDTIPO tinyint ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NUMERO varchar(50) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDPROVEEDOR int</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">FACTURAS_CLI (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NUMERO int,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCLIENTE int(10) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>RAZON varchar(100) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCONDIVA tinyint ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>CUIT int ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>TIPOIVA char(1) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>FECHA datetime , <span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DESCRIPCION TEXT ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>PAGA bool</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">FACTURAS_PRO (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NUMERO int,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDPROOVEDOR int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>RAZON varchar(100) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDCONDIVA tinyint ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>CUIT int ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>TIPOIVA char(1) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>FECHA datetime ,<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IVA decimal(10,4) , //por si difiere</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IIBB decimal(10,4) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NETO decimal(10,4) , //por si difiere</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DESCRIPCION TEXT ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>PAGA bool</div><div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">FACTURA_CLI_ITEMS (</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDFACTURA int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDARTICULO int ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DESCRIPCION varchar(100) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>CANTIDAD int,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>UNITARIO decimal (10,4)</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IVA decimal (10,4),<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">FACTURA_PRO_ITEMS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>IDFACTURA int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDARTICULO int ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>DESCRIPCION varchar(100) ,<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>CANTIDAD int,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>UNITARIO decimal (10,4)</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>IVA decimal (10,4),<span class="Apple-tab-span" style="white-space:pre"> </span></div><div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">
LOCALIDADES (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NOMBRE varchar(50) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>CP int(4) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>IDPROVINCIA int</div><div class="gmail_quote">
)</div><div class="gmail_quote"><br></div><div class="gmail_quote">PROVINCIAS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NOMBRE varchar(50)</div>
<div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">CONDIVA (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>CONDICION varchar(50)</div><div class="gmail_quote">)</div><div class="gmail_quote"><br></div><div class="gmail_quote">TELEFONO_TIPOS (</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>ID tinyint ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>TIPO varchar(50) ,</div><div class="gmail_quote">)</div>
<div class="gmail_quote"><br></div><div class="gmail_quote">USUARIOS (</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ID int PK ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>USUARIO varchar(50) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>PASSWORD varchar(100) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>NOMBRE varchar(100) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>APELLIDO varchar(100) ,</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>EMAIL varchar(100) ,</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>ACCESO datetime</div><div class="gmail_quote">) </div></div></div>