| ID_Proveedor | Nombre_Proveedor | Contacto |
|---|---|---|
| 1 | Textiles S.A. | contacto@textiles.com |
| 2 | Calzados Colombia | info@calzados.co |
| 3 | Moda Express | ventas@modaexpress.com |
| 4 | Accesorios VIP | soporte@accesoriosvip.com |
| 5 | Ropa Interior Plus | contact@ropainterior.com |
| 6 | Deportes Extremos | ventas@deportesextremos.co |
| 7 | Lujo y Elegancia | info@lujoelegancia.com |
| 8 | Ni├▒os Felices | contacto@ninosfelices.com |
| 9 | Ropa T├®rmica | soporte@ropatermica.com |
| 10 | Trajes Formales Ltda. | ventas@trajesformales.com |
| 11 | Bikinis Paradise | info@bikinisparadise.com |
| 12 | Invierno & Co. | contacto@inviernoyco.com |
| 13 | Verano Brillante | ventas@veranobrillante.com |
| 14 | Trabajo Seguro | soporte@trabajoseguro.com |
| 15 | Cultura Viva | info@culturayviva.com |
| 16 | Fiesta Total | ventas@fiestatotal.com |
| 17 | Sue├▒os Dorados | contacto@sue├▒osdorados.com |
| 18 | Marca Premium | info@marcapremium.com |
| 19 | EcoFashion | soporte@ecofashion.com |
| 20 | Vintage Collection | ventas@vintagecollection.com |
| ID_Cargo | Nombre_Cargo | Es_Gerente |
|---|---|---|
| 1 | Gerente | 1 |
| 2 | Cajero | 0 |
| 3 | Vendedor | 0 |
| 4 | Almacenista | 0 |
| 5 | Supervisor | 0 |
| 6 | Atenci├│n al Cliente | 0 |
| 7 | Marketing | 0 |
| 8 | Contador | 0 |
| 9 | T├®cnico | 0 |
| 10 | Limpieza | 0 |
| 11 | Seguridad | 0 |
| 12 | RRHH | 0 |
| 13 | Logística | 0 |
| 14 | IT | 0 |
| 15 | Compras | 0 |
| 16 | Ventas Online | 0 |
| 17 | Dise├▒ador | 0 |
| 18 | Cadenero | 0 |
| 19 | Mantenimiento | 0 |
| 20 | Transportador | 0 |
| Tables_in_DB6154_WALKMART |
|---|
| Cargos |
| Categorias |
| Ciudades |
| Clientes |
| Departamentos |
| DetalleVenta |
| Empleados |
| Inventario |
| MetodosPago |
| ProductoProveedor |
| Productos |
| PromocionProducto |
| Promociones |
| Proveedores |
| Reclamaciones |
| Subcategorias |
| Tiendas |
| Turnos |
| Ventas |
| cargos |
| categorias |
| ciudades |
| clientes |
| departamentos |
| detalleventa |
| empleados |
| inventario |
| metodospago |
| productoproveedor |
| productos |
| promociones |
| promocionproducto |
| proveedores |
| reclamaciones |
| subcategorias |
| tiendas |
| turnos |
| ventas |
| ID_Empleado | Nombre_Empleado | Cargo_ID | Tienda_ID | Telefono | |
|---|---|---|---|---|---|
| 1 | Laura G├│mez | 1 | 1 | 3101111111 | laura@walkmar.com |
| 2 | Carlos P├®rez | 2 | 1 | 3102222222 | carlos@walkmar.com |
| 3 | Ana L├│pez | 3 | 1 | 3103333333 | ana@walkmar.com |
| 4 | Pedro Ramírez | 4 | 2 | 3104444444 | pedro@walkmar.com |
| 5 | Sofía Martínez | 5 | 2 | 3105555555 | sofia@walkmar.com |
| 6 | Jorge Herrera | 6 | 3 | 3106666666 | jorge@walkmar.com |
| 7 | Luisa Castro | 7 | 3 | 3107777777 | luisa@walkmar.com |
| 8 | Andr├®s S├ínchez | 8 | 4 | 3108888888 | andres@walkmar.com |
| 9 | M├│nica Torres | 9 | 4 | 3109999999 | monica@walkmar.com |
| 10 | Diego Rojas | 10 | 5 | 3110000000 | diego@walkmar.com |
| 11 | Camila Díaz | 11 | 5 | 3111111111 | camila@walkmar.com |
| 12 | Miguel Guti├®rrez | 12 | 6 | 3112222222 | miguel@walkmar.com |
| 13 | Valentina Mejía | 13 | 6 | 3113333333 | valentina@walkmar.com |
| 14 | Juan Vargas | 14 | 7 | 3114444444 | juan@walkmar.com |
| 15 | Isabella Jim├®nez | 15 | 7 | 3115555555 | isabella@walkmar.com |
| 16 | Fernando Mu├▒oz | 16 | 8 | 3116666666 | fernando@walkmar.com |
| 17 | Daniela Ospina | 17 | 8 | 3117777777 | daniela@walkmar.com |
| 18 | Ricardo Ruiz | 18 | 9 | 3118888888 | ricardo@walkmar.com |
| 19 | Carolina Molina | 19 | 9 | 3119999999 | carolina@walkmar.com |
| 20 | Santiago G├│mez | 20 | 10 | 3120000000 | santiago@walkmar.com |
| ID_Empleado | Nombre_Empleado | Cargo_ID | Tienda_ID | Telefono | |
|---|---|---|---|---|---|
| 1 | Laura Gómezz | 1 | 1 | 3101111111 | laura@walkmar.com |
| 2 | Carlos Pérez | 2 | 1 | 3102222222 | carlos@walkmar.com |
| 3 | Ana López | 3 | 1 | 3103333333 | ana@walkmar.com |
| 4 | Pedro Ramírez | 4 | 2 | 3104444444 | pedro@walkmar.com |
| 5 | Sofía Martínez | 5 | 2 | 3105555555 | sofia@walkmar.com |
| 6 | Jorge Herrera | 6 | 3 | 3106666666 | jorge@walkmar.com |
| 7 | Luisa Castro | 7 | 3 | 3107777777 | luisa@walkmar.com |
| 8 | Andrés Sánchez | 8 | 4 | 3108888888 | andres@walkmar.com |
| 9 | Mónica Torres | 9 | 4 | 3109999999 | monica@walkmar.com |
| 10 | Diego Rojas | 10 | 5 | 3110000000 | diego@walkmar.com |
| 11 | Camila Díaz | 11 | 5 | 3111111111 | camila@walkmar.com |
| 12 | Miguel Gutiérrez | 12 | 6 | 3112222222 | miguel@walkmar.com |
| 13 | Valentina Mejía | 13 | 6 | 3113333333 | valentina@walkmar.com |
| 14 | Juan Vargas | 14 | 7 | 3114444444 | juan@walkmar.com |
| 15 | Isabella Jiménez | 15 | 7 | 3115555555 | isabella@walkmar.com |
| 16 | Fernando Muñoz | 16 | 8 | 3116666666 | fernando@walkmar.com |
| 17 | Daniela Ospina | 17 | 8 | 3117777777 | daniela@walkmar.com |
| 18 | Ricardo Ruiz | 18 | 9 | 3118888888 | ricardo@walkmar.com |
| 19 | Carolina Molina | 19 | 9 | 3119999999 | carolina@walkmar.com |
| 20 | Santiago Gómez | 20 | 10 | 3120000000 | santiago@walkmar.com |
| 105 | Alejandro Cardona | 1 | 11 | 3101111111 | acardona@a |
| 106 | Fatima | 8 | 62 | 3145387401 | aaaa@aa |
| ID_Tienda | Nombre_Tienda | Direccion_Tienda | Ciudad_ID | Gerente_ID |
|---|---|---|---|---|
| 1 | Walkmar Centro | Carrera 50 #10-20 | 1 | 1 |
| 2 | Walkmar Norte | Avenida 30 #5-45 | 2 | 4 |
| 3 | Walkmar Sur | Calle 15 #22-30 | 3 | 6 |
| 4 | Walkmar Oriente | Carrera 7 #12-10 | 4 | 8 |
| 5 | Walkmar Occidente | Avenida 6 #18-25 | 5 | 10 |
| 6 | Walkmar Plaza | Calle 25 #8-15 | 6 | 12 |
| 7 | Walkmar Unicentro | Carrera 45 #20-50 | 7 | 14 |
| 8 | Walkmar Megamall | Avenida 10 #30-40 | 8 | 16 |
| 9 | Walkmar La 70 | Carrera 70 #15-80 | 9 | 18 |
| 10 | Walkmar Poblado | Calle 10 #40-25 | 10 | 20 |
| 11 | Walkmar Caribe | Carrera 5 #22-10 | 11 | |
| 12 | Walkmar Histórica | Avenida 2 #17-30 | 12 | |
| 13 | Walkmar Moderna | Calle 8 #12-45 | 13 | |
| 14 | Walkmar Clásica | Carrera 12 #9-18 | 14 | |
| 15 | Walkmar Premium | Avenida 4 #25-60 | 15 | |
| 16 | Walkmar Básica | Calle 20 #7-30 | 16 | |
| 17 | Walkmar Express | Carrera 18 #33-50 | 17 | |
| 18 | Walkmar VIP | Avenida 9 #27-15 | 18 | |
| 19 | Walkmar Eco | Calle 5 #19-40 | 19 | |
| 20 | Walkmar Vintage | Carrera 3 #14-22 | 20 | |
| 21 | Walkmar Centro | Carrera 50 #10-20 | 1 | |
| 22 | Walkmar Norte | Avenida 30 #5-45 | 2 | |
| 23 | Walkmar Sur | Calle 15 #22-30 | 3 | |
| 24 | Walkmar Oriente | Carrera 7 #12-10 | 4 | |
| 25 | Walkmar Occidente | Avenida 6 #18-25 | 5 | |
| 26 | Walkmar Plaza | Calle 25 #8-15 | 6 | |
| 27 | Walkmar Unicentro | Carrera 45 #20-50 | 7 | |
| 28 | Walkmar Megamall | Avenida 10 #30-40 | 8 | |
| 29 | Walkmar La 70 | Carrera 70 #15-80 | 9 | |
| 30 | Walkmar Poblado | Calle 10 #40-25 | 10 | |
| 31 | Walkmar Caribe | Carrera 5 #22-10 | 11 | |
| 32 | Walkmar Histórica | Avenida 2 #17-30 | 12 | |
| 33 | Walkmar Moderna | Calle 8 #12-45 | 13 | |
| 34 | Walkmar Clásica | Carrera 12 #9-18 | 14 | |
| 35 | Walkmar Premium | Avenida 4 #25-60 | 15 | |
| 36 | Walkmar Básica | Calle 20 #7-30 | 16 | |
| 37 | Walkmar Express | Carrera 18 #33-50 | 17 | |
| 38 | Walkmar VIP | Avenida 9 #27-15 | 18 | |
| 39 | Walkmar Eco | Calle 5 #19-40 | 19 | |
| 40 | Walkmar Vintage | Carrera 3 #14-22 | 20 | |
| 41 | Walkmar Centro | Carrera 50 #10-20 | 1 | |
| 42 | Walkmar Norte | Avenida 30 #5-45 | 2 | |
| 43 | Walkmar Sur | Calle 15 #22-30 | 3 | |
| 44 | Walkmar Oriente | Carrera 7 #12-10 | 4 | |
| 45 | Walkmar Occidente | Avenida 6 #18-25 | 5 | |
| 46 | Walkmar Plaza | Calle 25 #8-15 | 6 | |
| 47 | Walkmar Unicentro | Carrera 45 #20-50 | 7 | |
| 48 | Walkmar Megamall | Avenida 10 #30-40 | 8 | |
| 49 | Walkmar La 70 | Carrera 70 #15-80 | 9 | |
| 50 | Walkmar Poblado | Calle 10 #40-25 | 10 | |
| 51 | Walkmar Caribe | Carrera 5 #22-10 | 11 | |
| 52 | Walkmar Histórica | Avenida 2 #17-30 | 12 | |
| 53 | Walkmar Moderna | Calle 8 #12-45 | 13 | |
| 54 | Walkmar Clásica | Carrera 12 #9-18 | 14 | |
| 55 | Walkmar Premium | Avenida 4 #25-60 | 15 | |
| 56 | Walkmar Básica | Calle 20 #7-30 | 16 | |
| 57 | Walkmar Express | Carrera 18 #33-50 | 17 | |
| 58 | Walkmar VIP | Avenida 9 #27-15 | 18 | |
| 59 | Walkmar Eco | Calle 5 #19-40 | 19 | |
| 60 | Walkmar Vintage | Carrera 3 #14-22 | 20 | |
| 61 | Walkmar Centro | Carrera 50 #10-20 | 1 | |
| 62 | Walkmar Norte | Avenida 30 #5-45 | 2 | |
| 63 | Walkmar Sur | Calle 15 #22-30 | 3 | |
| 64 | Walkmar Oriente | Carrera 7 #12-10 | 4 | |
| 65 | Walkmar Occidente | Avenida 6 #18-25 | 5 | |
| 66 | Walkmar Plaza | Calle 25 #8-15 | 6 | |
| 67 | Walkmar Unicentro | Carrera 45 #20-50 | 7 | |
| 68 | Walkmar Megamall | Avenida 10 #30-40 | 8 | |
| 69 | Walkmar La 70 | Carrera 70 #15-80 | 9 | |
| 70 | Walkmar Poblado | Calle 10 #40-25 | 10 | |
| 71 | Walkmar Caribe | Carrera 5 #22-10 | 11 | |
| 72 | Walkmar Histórica | Avenida 2 #17-30 | 12 | |
| 73 | Walkmar Moderna | Calle 8 #12-45 | 13 | |
| 74 | Walkmar Clásica | Carrera 12 #9-18 | 14 | |
| 75 | Walkmar Premium | Avenida 4 #25-60 | 15 | |
| 76 | Walkmar Básica | Calle 20 #7-30 | 16 | |
| 77 | Walkmar Express | Carrera 18 #33-50 | 17 | |
| 78 | Walkmar VIP | Avenida 9 #27-15 | 18 | |
| 79 | Walkmar Eco | Calle 5 #19-40 | 19 | |
| 80 | Walkmar Vintage | Carrera 3 #14-22 | 20 | |
| 81 | Walkmar Centro | Carrera 50 #10-20 | 1 | |
| 82 | Walkmar Norte | Avenida 30 #5-45 | 2 | |
| 83 | Walkmar Sur | Calle 15 #22-30 | 3 | |
| 84 | Walkmar Oriente | Carrera 7 #12-10 | 4 | |
| 85 | Walkmar Occidente | Avenida 6 #18-25 | 5 | |
| 86 | Walkmar Plaza | Calle 25 #8-15 | 6 | |
| 87 | Walkmar Unicentro | Carrera 45 #20-50 | 7 | |
| 88 | Walkmar Megamall | Avenida 10 #30-40 | 8 | |
| 89 | Walkmar La 70 | Carrera 70 #15-80 | 9 | |
| 90 | Walkmar Poblado | Calle 10 #40-25 | 10 | |
| 91 | Walkmar Caribe | Carrera 5 #22-10 | 11 | |
| 92 | Walkmar Histórica | Avenida 2 #17-30 | 12 | |
| 93 | Walkmar Moderna | Calle 8 #12-45 | 13 | |
| 94 | Walkmar Clásica | Carrera 12 #9-18 | 14 | |
| 95 | Walkmar Premium | Avenida 4 #25-60 | 15 | |
| 96 | Walkmar Básica | Calle 20 #7-30 | 16 | |
| 97 | Walkmar Express | Carrera 18 #33-50 | 17 | |
| 98 | Walkmar VIP | Avenida 9 #27-15 | 18 | |
| 99 | Walkmar Eco | Calle 5 #19-40 | 19 | |
| 100 | Walkmar Vintage | Carrera 3 #14-22 | 20 |
| ID_Producto | Nombre_Producto | Categoria_ID | Precio_Unitario |
|---|---|---|---|
| 1 | Camiseta Básica | 1 | 25000.00 |
| 2 | Jeans Clásico | 2 | 80000.00 |
| 3 | Zapatos Casuales | 3 | 120000.00 |
| 4 | Gorra Deportiva | 4 | 35000.00 |
| 5 | Calcetines Pack x3 | 5 | 15000.00 |
| 6 | Chaqueta de Cuero | 6 | 200000.00 |
| 7 | Vestido Elegante | 7 | 150000.00 |
| 8 | Falda Plisada | 8 | 60000.00 |
| 9 | Traje Formal | 9 | 300000.00 |
| 10 | Short Deportivo | 10 | 45000.00 |
| 11 | Blusa de Seda | 11 | 70000.00 |
| 12 | Bufanda de Lana | 12 | 30000.00 |
| 13 | Guantes de Piel | 13 | 55000.00 |
| 14 | Pijama Algodón | 14 | 50000.00 |
| 15 | Sudadera con Capucha | 15 | 90000.00 |
| 16 | Tenis Running | 16 | 180000.00 |
| 17 | Gafas de Sol | 17 | 75000.00 |
| 18 | Cinturón de Cuero | 18 | 40000.00 |
| 19 | Bikini Estampado | 19 | 65000.00 |
| 20 | Abrigo Invierno | 20 | 250000.00 |
| 21 | Camiseta Básica | 1 | 25000.00 |
| 22 | Jeans Clásico | 2 | 80000.00 |
| 23 | Zapatos Casuales | 3 | 120000.00 |
| 24 | Gorra Deportiva | 4 | 35000.00 |
| 25 | Calcetines Pack x3 | 5 | 15000.00 |
| 26 | Chaqueta de Cuero | 6 | 200000.00 |
| 27 | Vestido Elegante | 7 | 150000.00 |
| 28 | Falda Plisada | 8 | 60000.00 |
| 29 | Traje Formal | 9 | 300000.00 |
| 30 | Short Deportivo | 10 | 45000.00 |
| 31 | Blusa de Seda | 11 | 70000.00 |
| 32 | Bufanda de Lana | 12 | 30000.00 |
| 33 | Guantes de Piel | 13 | 55000.00 |
| 34 | Pijama Algodón | 14 | 50000.00 |
| 35 | Sudadera con Capucha | 15 | 90000.00 |
| 36 | Tenis Running | 16 | 180000.00 |
| 37 | Gafas de Sol | 17 | 75000.00 |
| 38 | Cinturón de Cuero | 18 | 40000.00 |
| 39 | Bikini Estampado | 19 | 65000.00 |
| 40 | Abrigo Invierno | 20 | 250000.00 |
| 41 | prueba | 3 | 1.10 |
| 42 | prueba2 | 3 | 2.00 |
| 43 | Camiseta Básica | 1 | 25000.00 |
| 44 | Jeans Clásico | 2 | 80000.00 |
| 45 | Zapatos Casuales | 3 | 120000.00 |
| 46 | Gorra Deportiva | 4 | 35000.00 |
| 47 | Calcetines Pack x3 | 5 | 15000.00 |
| 48 | Chaqueta de Cuero | 6 | 200000.00 |
| 49 | Vestido Elegante | 7 | 150000.00 |
| 50 | Falda Plisada | 8 | 60000.00 |
| 51 | Traje Formal | 9 | 300000.00 |
| 52 | Short Deportivo | 10 | 45000.00 |
| 53 | Blusa de Seda | 11 | 70000.00 |
| 54 | Bufanda de Lana | 12 | 30000.00 |
| 55 | Guantes de Piel | 13 | 55000.00 |
| 56 | Pijama Algodón | 14 | 50000.00 |
| 57 | Sudadera con Capucha | 15 | 90000.00 |
| 58 | Tenis Running | 16 | 180000.00 |
| 59 | Gafas de Sol | 17 | 75000.00 |
| 60 | Cinturón de Cuero | 18 | 40000.00 |
| 61 | Bikini Estampado | 19 | 65000.00 |
| 62 | Abrigo Invierno | 20 | 250000.00 |
| 63 | Camiseta Básica | 1 | 25000.00 |
| 64 | Jeans Clásico | 2 | 80000.00 |
| 65 | Zapatos Casuales | 3 | 120000.00 |
| 66 | Gorra Deportiva | 4 | 35000.00 |
| 67 | Calcetines Pack x3 | 5 | 15000.00 |
| 68 | Chaqueta de Cuero | 6 | 200000.00 |
| 69 | Vestido Elegante | 7 | 150000.00 |
| 70 | Falda Plisada | 8 | 60000.00 |
| 71 | Traje Formal | 9 | 300000.00 |
| 72 | Short Deportivo | 10 | 45000.00 |
| 73 | Blusa de Seda | 11 | 70000.00 |
| 74 | Bufanda de Lana | 12 | 30000.00 |
| 75 | Guantes de Piel | 13 | 55000.00 |
| 76 | Pijama Algodón | 14 | 50000.00 |
| 77 | Sudadera con Capucha | 15 | 90000.00 |
| 78 | Tenis Running | 16 | 180000.00 |
| 79 | Gafas de Sol | 17 | 75000.00 |
| 80 | Cinturón de Cuero | 18 | 40000.00 |
| 81 | Bikini Estampado | 19 | 65000.00 |
| 82 | Abrigo Invierno | 20 | 250000.00 |
| 83 | Camiseta Básica | 1 | 25000.00 |
| 84 | Jeans Clásico | 2 | 80000.00 |
| 85 | Zapatos Casuales | 3 | 120000.00 |
| 86 | Gorra Deportiva | 4 | 35000.00 |
| 87 | Calcetines Pack x3 | 5 | 15000.00 |
| 88 | Chaqueta de Cuero | 6 | 200000.00 |
| 89 | Vestido Elegante | 7 | 150000.00 |
| 90 | Falda Plisada | 8 | 60000.00 |
| 91 | Traje Formal | 9 | 300000.00 |
| 92 | Short Deportivo | 10 | 45000.00 |
| 93 | Blusa de Seda | 11 | 70000.00 |
| 94 | Bufanda de Lana | 12 | 30000.00 |
| 95 | Guantes de Piel | 13 | 55000.00 |
| 96 | Pijama Algodón | 14 | 50000.00 |
| 97 | Sudadera con Capucha | 15 | 90000.00 |
| 98 | Tenis Running | 16 | 180000.00 |
| 99 | Gafas de Sol | 17 | 75000.00 |
| 100 | Cinturón de Cuero | 18 | 40000.00 |
| 101 | Bikini Estampado | 19 | 65000.00 |
| 103 | x | 3 | 1000.00 |
| ID_Empleado | Nombre_Empleado | Nombre_Tienda |
|---|---|---|
| 1 | Laura Gómezz | Walkmar Centro |
| 2 | Carlos Pérez | Walkmar Centro |
| 3 | Ana López | Walkmar Centro |
| 4 | Pedro Ramírez | Walkmar Norte |
| 5 | Sofía Martínez | Walkmar Norte |
| 6 | Jorge Herrera | Walkmar Sur |
| 7 | Luisa Castro | Walkmar Sur |
| 8 | Andrés Sánchez | Walkmar Oriente |
| 9 | Mónica Torres | Walkmar Oriente |
| 10 | Diego Rojas | Walkmar Occidente |