MariaDB [(none)]> create database almacen2; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> use almacen2; Database changed **************************************************************************************************************************************************************** CREACION DE TABLAS **************************************************************************************************************************************************************** 1 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table departamento -> (iddepartamento int(10) not null primary key auto_increment, -> descripcion varchar(60) not null, -> estado enum('activo', 'inactivo') not null); Query OK, 0 rows affected (0.342 sec) **************************************************************************************************************************************************************** 2 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table ciudad -> (idciudad int(10) not null primary key auto_increment, -> descripcion varchar(60) not null, -> estado enum('activo', 'inactivo') not null, -> iddepartamento int(10) not null, -> foreign key(iddepartamento) references departamento(iddepartamento) on delete cascade on update cascade); Query OK, 0 rows affected (0.332 sec) **************************************************************************************************************************************************************** 3 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table empleado -> (cedula varchar(15) not null primary key, -> primer_nombre varchar(60) not null, -> segundo_nombre varchar(60) not null, -> primero_apellido varchar(60) not null, -> segundo_apellido varchar(60) not null, -> fecha_nacimiento date not null, -> direccion varchar(80) not null, -> telefono int(11) not null, -> correo varchar(60) not null, -> genero varchar(25) not null, -> estado enum('activo', 'inactivo') not null); Query OK, 0 rows affected (0.271 sec) **************************************************************************************************************************************************************** 4 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table tipo_producto -> (codigotp int(10) not null primary key auto_increment, -> descripcion varchar(60) not null); Query OK, 0 rows affected (0.470 sec) **************************************************************************************************************************************************************** 5 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table producto -> (idproducto int(10) not null primary key auto_increment, -> codigotp int(10) not null, -> nombre varchar(60) not null, -> img_ref blob, -> stock int(11) not null, -> valor int(11) not null, -> iva int(11), -> valor_venta int(11), -> estado enum('activo', 'inactivo') not null); Query OK, 0 rows affected (0.511 sec) **************************************************************************************************************************************************************** 6 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table cliente -> (cedula_cliente varchar(15) not null primary key, -> primer_nombre varchar(60) not null, -> segundo_nombre varchar(60) not null, -> primero_apellido varchar(60) not null, -> segundo_apellido varchar(60) not null, -> fecha_nacimiento date not null, -> idciudad int(10) not null, -> direccion varchar(80) not null, -> telefono int(11) not null, -> correo varchar(60) not null, -> genero varchar(25) not null, -> estado enum('activo', 'inactivo') not null, -> foreign key(idciudad) references ciudad(idciudad) on delete cascade on update cascade); Query OK, 0 rows affected (0.477 sec) **************************************************************************************************************************************************************** 7 **************************************************************************************************************************************************************** MariaDB [almacen2]> alter table empleado change cedula cedula_empleado varchar(15) not null; Query OK, 0 rows affected (0.121 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [almacen2]> create table tipo_pago -> (idtipopago int(10) not null primary key auto_increment, -> descripcion varchar(60) not null); Query OK, 0 rows affected (0.283 sec) **************************************************************************************************************************************************************** 8 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table factura -> (idfactura int(9) not null primary key auto_increment, -> cedula_cliente varchar(15) not null, -> cedula_empleado varchar(15) not null, -> fecha date not null, -> hora time not null, -> subtotal int(20) not null, -> total_iva int(20) not null, -> descuento int(20), -> total int(20) not null, -> idtipopago int(10) not null, -> descripcion varchar(500), -> estado_sistema enum('activo', 'inactivo') not null, -> estado_factura enum('activo', 'inactivo') not null, -> foreign key (cedula_cliente) references cliente(cedula_cliente) on delete cascade on update cascade, -> foreign key (idtipopago) references tipo_pago(idtipopago) on delete cascade on update cascade); Query OK, 0 rows affected (0.286 sec) **************************************************************************************************************************************************************** 9 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table pedido -> (idpedido int(10) not null primary key auto_increment, -> idfactura int(10) not null, -> idproducto int(10) not null, -> cantidad int(20) not null, -> valor_unitario int(11) not null, -> subtotal int(20), -> iva int(20), -> total int(20) not null); Query OK, 0 rows affected (0.211 sec) **************************************************************************************************************************************************************** 10 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table perfil -> (idperfil varchar(10) not null primary key, -> descripcion varchar(60) not null); Query OK, 0 rows affected (0.248 sec) **************************************************************************************************************************************************************** 11 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table usuario -> (idusuario varchar(10) not null primary key, -> usuario varchar(20) not null, -> contrasena varchar(20) not null, -> idperfil varchar(10) not null, -> foreign key(idperfil) references perfil(idperfil) on delete cascade on update cascade); Query OK, 0 rows affected (0.299 sec) **************************************************************************************************************************************************************** 12 **************************************************************************************************************************************************************** MariaDB [almacen2]> create table pagos -> (idpagos int(10) not null primary key auto_increment, -> idfactura int(10) not null, -> fecha date not null, -> hora time not null, -> monto_pagado int(20) not null, -> monto_restante int(20), -> observacion varchar(500), -> foreign key(idfactura) references factura(idfactura) on delete cascade on update cascade); Query OK, 0 rows affected (0.350 sec) **************************************************************************************************************************************************************** TODAS LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> show tables; +--------------------+ | Tables_in_almacen2 | +--------------------+ | ciudad | | cliente | | departamento | | empleado | | factura | | pagos | | pedido | | perfil | | producto | | tipo_pago | | tipo_producto | | usuario | +--------------------+ 12 rows in set (0.001 sec) **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into tipo_producto(descripcion) values -> ('Hombre'), -> ('Mujer'), -> ('Ni os'); Query OK, 3 rows affected (0.065 sec) Records: 3 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into producto(codigotp,nombre,stock,valor,iva,valor_venta,estado) values -> (2,'pantalon_mujer',120,100000,19000,119000,1), -> (1,'pantalon_hombre',120,80000,15200,95200,1), -> (3,'pantalon_ni os',110,70000,13300,83300,1), -> (2,'blusa_mujer',215,60000,11400,71400,1), -> (3,'blusa_ni os',200,40000,7600,47600,1), -> (1,'chaqueta_hombre',110,180000,34200,214200,1), -> (2,'chaqueta_mujer',150,150000,28500,178500,1), -> (3,'chaqueta_ni os',300,100000,19000,119000,1), -> (2,'vestido_mujer',300,80000,15200,95200,1), -> (3,'vestido_ni os',400,50000,13300,63300,1), -> (1,'camiseta_hombre',180,70000,13300,83300,1), -> (2,'falda',250,70000,13300,83300,1), -> (1,'pijama_hombre',190,40000,7600,47600,1), -> (2,'pijama_mujer',260,50000,9500,59500,1), -> (3,'pijama_ni os',180,40000,7600,47600,1), -> (1,'sudadera_hombre',150,100000,19000,119000,1), -> (2,'sudadera_mujer',190,80000,15200,95200,1), -> (3,'sudadera_ni os',190,70000,13300,83300,1); Query OK, 18 rows affected (0.074 sec) Records: 18 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into departamento(descripcion,estado) values -> ('antioquia',1), -> ('atlantico',1), -> ('cundinamarca',1); Query OK, 3 rows affected (0.068 sec) Records: 3 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into ciudad(descripcion,estado,iddepartamento) values -> ('medellin',1,1), -> ('barranquilla',1,2), -> ('bogota',1,3); Query OK, 3 rows affected (0.116 sec) Records: 3 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into empleado(cedula_empleado,primer_nombre,segundo_nombre,primero_apellido,segundo_apellido,fecha_nacimiento,direccion,telefono,correo,genero,estado) values -> (43418,'Marcela','Carolina','Arboleda','Tabares','1982-11-12','Carrera 48 nro 67-77','2119876','marboleda@gmail.com','femenino',1), -> (98620,'Andres','Esteban','Garcia','Acevedo','1985-06-02','calle 92a nro36','2128976','jgarcia@gmail.com','masculino',1), -> (110243,'Jaqueline','Isabel','Castrillon','Botero','1996-08-15','carrera50 nro 68-19','2124576','lcastrillon@gmail.com','femenino',1), -> (10043,'Isabel','Carolina','Benitez','Rodriguez','1987-10-20','carrera 40 nro 68-76','2113476','dbenitez@gmail.com','femenino',1); Query OK, 4 rows affected (0.073 sec) Records: 4 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into cliente(cedula_cliente,primer_nombre,segundo_nombre,primero_apellido,segundo_apellido,fecha_nacimiento,idciudad,direccion,telefono,correo,genero,estado) values -> (46578,'Silvia','Lorena','Dioses','Osorio','1985-07-05',2,'La Ceja Cra 74 # 13-33','5060385','sdioses@gmail.com','femenino',1), -> (985423,'Michael ','Steven','Jimenez','Toro','1987-06-03',3,'Rionegro Cra 37 # 7-78','2115147','mjimenez@gmail.com','masculino',1), -> (11023,'Maria','Victoria','Ceballos','Ruedas','1990-01-01',3,'Valdivia Cra 48 # 90-36','3125637486','mceballos@gmail.com','femenino',1), -> (1107659,'Katherin','Cecilia','Thomas','Garcia','1996-08-09',1,'Medell n Cra 28 # 38-72','3194873265','kthomas@gmail.com','femenino',1), -> (96780,'Cristian','Camilo','Sanchez','Casta o','1996-09-10',2,'Guatape Cra 54 # 26-33','5026754','csanchez@gmail.com','masculino',1), -> (11203,'Carlos ','Eduardo','Campo','Giraldo','1987-05-06',2,'El Bagre Cra 32 # 65-69','3104987623','ccampo@gmail.com','masculino',1), -> (96234,'Maria','Nataly','Torres','Toro','1997-12-09',1,'Copacabana Cra 65 # 45-83','3143834987','mtorres@gmail.com','femenino',1), -> (43200,'lesdy','Vanesa','Mejia','Lopera','1995-11-18',1,'Andes Cra 35 # 51-85','3147658279','lmejia@gmail.com','femenino',1), -> (98986,'Andres','Felipe','Gomez','Arias','1994-10-25',3,'Guarne Cra 35 # 88-74','3206570976','agomez@gmail.com','masculino',1), -> (43894,'Ana','Maria','Llano','Rendon','1993-07-04',1,'Sabaneta Cra 51 # 29-45','3202850183','allano@gmail.com','femenino',1); Query OK, 10 rows affected, 7 warnings (0.215 sec) Records: 10 Duplicates: 0 Warnings: 7 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into tipo_pago(descripcion)values -> ("efectivo"), -> ("transferencia"), -> ("tarjeta"), -> ("credito"); Query OK, 4 rows affected (0.172 sec) Records: 4 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** INSERTAR DATOS EN LAS TABLAS **************************************************************************************************************************************************************** MariaDB [almacen2]> insert into factura(cedula_cliente,cedula_empleado,fecha,hora,subtotal,total_iva,descuento,total,idtipopago,descripcion,estado_sistema,estado_factura) values -> ("46578","110243","2023-01-10","11:30:34",0,0,0,0,1,"",1,1), -> ("985423","10043","2023-02-25","09:27:35",0,0,0,0,2,"",1,1), -> ("11023","10043","2023-02-25","11:00:00",0,0,0,0,1,"",1,1), -> ("1107659","43418","2023-03-02","12:27:34",0,0,0,0,3,"",1,1), -> ("96780","98620","2023-03-02","10:09:55",0,0,0,0,2,"",1,1), -> ("11203","98620","2023-04-12","07:24:10",0,0,0,0,1,"",1,1), -> ("96234","110243","2023-04-12","11:10:03",0,0,0,0,1,"",1,1), -> ("43200","43418","2023-05-01","12:20:46",0,0,0,0,2,"",1,1), -> ("98986","43418","2023-05-01","10:20:46",0,0,0,0,4,"",1,1), -> ("43894","98620","2023-05-05","12:00:00",0,0,0,0,2,"",1,1); Query OK, 10 rows affected (0.124 sec) Records: 10 Duplicates: 0 Warnings: 0 **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 1 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe ciudad; +----------------+---------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------------+------+-----+---------+----------------+ | idciudad | int(10) | NO | PRI | NULL | auto_increment | | descripcion | varchar(60) | NO | | NULL | | | estado | enum('activo','inactivo') | NO | | NULL | | | iddepartamento | int(10) | NO | MUL | NULL | | +----------------+---------------------------+------+-----+---------+----------------+ 4 rows in set (0.003 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 2 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe cliente; +------------------+---------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------------+------+-----+---------+-------+ | cedula_cliente | varchar(15) | NO | PRI | NULL | | | primer_nombre | varchar(60) | NO | | NULL | | | segundo_nombre | varchar(60) | NO | | NULL | | | primero_apellido | varchar(60) | NO | | NULL | | | segundo_apellido | varchar(60) | NO | | NULL | | | fecha_nacimiento | date | NO | | NULL | | | idciudad | int(10) | NO | MUL | NULL | | | direccion | varchar(80) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | | correo | varchar(60) | NO | | NULL | | | genero | varchar(25) | NO | | NULL | | | estado | enum('activo','inactivo') | NO | | NULL | | +------------------+---------------------------+------+-----+---------+-------+ 12 rows in set (0.006 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 3 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe departamento; +----------------+---------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------------+------+-----+---------+----------------+ | iddepartamento | int(10) | NO | PRI | NULL | auto_increment | | descripcion | varchar(60) | NO | | NULL | | | estado | enum('activo','inactivo') | NO | | NULL | | +----------------+---------------------------+------+-----+---------+----------------+ 3 rows in set (0.015 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 4 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe empleado; +------------------+---------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------------+------+-----+---------+-------+ | cedula_empleado | varchar(15) | NO | PRI | NULL | | | primer_nombre | varchar(60) | NO | | NULL | | | segundo_nombre | varchar(60) | NO | | NULL | | | primero_apellido | varchar(60) | NO | | NULL | | | segundo_apellido | varchar(60) | NO | | NULL | | | fecha_nacimiento | date | NO | | NULL | | | direccion | varchar(80) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | | correo | varchar(60) | NO | | NULL | | | genero | varchar(25) | NO | | NULL | | | estado | enum('activo','inactivo') | NO | | NULL | | +------------------+---------------------------+------+-----+---------+-------+ 11 rows in set (0.021 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 5 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe factura; +-----------------+---------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------------+------+-----+---------+----------------+ | idfactura | int(9) | NO | PRI | NULL | auto_increment | | cedula_cliente | varchar(15) | NO | MUL | NULL | | | cedula_empleado | varchar(15) | NO | | NULL | | | fecha | date | NO | | NULL | | | hora | time | NO | | NULL | | | subtotal | int(20) | NO | | NULL | | | total_iva | int(20) | NO | | NULL | | | descuento | int(20) | YES | | NULL | | | total | int(20) | NO | | NULL | | | idtipopago | int(10) | NO | MUL | NULL | | | descripcion | varchar(500) | YES | | NULL | | | estado_sistema | enum('activo','inactivo') | NO | | NULL | | | estado_factura | enum('activo','inactivo') | NO | | NULL | | +-----------------+---------------------------+------+-----+---------+----------------+ 13 rows in set (0.012 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 6 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe pagos; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | idpagos | int(10) | NO | PRI | NULL | auto_increment | | idfactura | int(10) | NO | MUL | NULL | | | fecha | date | NO | | NULL | | | hora | time | NO | | NULL | | | monto_pagado | int(20) | NO | | NULL | | | monto_restante | int(20) | YES | | NULL | | | observacion | varchar(500) | YES | | NULL | | +----------------+--------------+------+-----+---------+----------------+ 7 rows in set (0.003 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 7 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe pedido; +----------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------+------+-----+---------+----------------+ | idpedido | int(10) | NO | PRI | NULL | auto_increment | | idfactura | int(10) | NO | | NULL | | | idproducto | int(10) | NO | | NULL | | | cantidad | int(20) | NO | | NULL | | | valor_unitario | int(11) | NO | | NULL | | | subtotal | int(20) | YES | | NULL | | | iva | int(20) | YES | | NULL | | | total | int(20) | NO | | NULL | | +----------------+---------+------+-----+---------+----------------+ 8 rows in set (0.007 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 8 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe perfil; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idperfil | varchar(10) | NO | PRI | NULL | | | descripcion | varchar(60) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.081 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 9 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe tipo_pago; +-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | idtipopago | int(10) | NO | PRI | NULL | auto_increment | | descripcion | varchar(60) | NO | | NULL | | +-------------+-------------+------+-----+---------+----------------+ 2 rows in set (0.151 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 10 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe tipo_producto; +-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | codigotp | int(10) | NO | PRI | NULL | auto_increment | | descripcion | varchar(60) | NO | | NULL | | +-------------+-------------+------+-----+---------+----------------+ 2 rows in set (0.045 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 11 **************************************************************************************************************************************************************** MariaDB [almacen2]> describe usuario; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | idusuario | varchar(10) | NO | PRI | NULL | | | usuario | varchar(20) | NO | | NULL | | | contrasena | varchar(20) | NO | | NULL | | | idperfil | varchar(10) | NO | MUL | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.006 sec) **************************************************************************************************************************************************************** DESCRIPCION EN LAS TABLAS 12 **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from ciudad; +----------+--------------+--------+----------------+ | idciudad | descripcion | estado | iddepartamento | +----------+--------------+--------+----------------+ | 1 | medellin | activo | 1 | | 2 | barranquilla | activo | 2 | | 3 | bogota | activo | 3 | +----------+--------------+--------+----------------+ 3 rows in set (0.001 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS CLIENTE **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from cliente; +----------------+---------------+----------------+------------------+------------------+------------------+----------+---------------------------+------------+---------------------+-----------+--------+ | cedula_cliente | primer_nombre | segundo_nombre | primero_apellido | segundo_apellido | fecha_nacimiento | idciudad | direccion | telefono | correo | genero | estado | +----------------+---------------+----------------+------------------+------------------+------------------+----------+---------------------------+------------+---------------------+-----------+--------+ | 11023 | Maria | Victoria | Ceballos | Ruedas | 1990-01-01 | 3 | Valdivia Cra 48 # 90-36 | 2147483647 | mceballos@gmail.com | femenino | activo | | 1107659 | Katherin | Cecilia | Thomas | Garcia | 1996-08-09 | 1 | Medell n Cra 28 # 38-72 | 2147483647 | kthomas@gmail.com | femenino | activo | | 11203 | Carlos | Eduardo | Campo | Giraldo | 1987-05-06 | 2 | El Bagre Cra 32 # 65-69 | 2147483647 | ccampo@gmail.com | masculino | activo | | 43200 | lesdy | Vanesa | Mejia | Lopera | 1995-11-18 | 1 | Andes Cra 35 # 51-85 | 2147483647 | lmejia@gmail.com | femenino | activo | | 43894 | Ana | Maria | Llano | Rendon | 1993-07-04 | 1 | Sabaneta Cra 51 # 29-45 | 2147483647 | allano@gmail.com | femenino | activo | | 46578 | Silvia | Lorena | Dioses | Osorio | 1985-07-05 | 2 | La Ceja Cra 74 # 13-33 | 5060385 | sdioses@gmail.com | femenino | activo | | 96234 | Maria | Nataly | Torres | Toro | 1997-12-09 | 1 | Copacabana Cra 65 # 45-83 | 2147483647 | mtorres@gmail.com | femenino | activo | | 96780 | Cristian | Camilo | Sanchez | Casta o | 1996-09-10 | 2 | Guatape Cra 54 # 26-33 | 5026754 | csanchez@gmail.com | masculino | activo | | 985423 | Michael | Steven | Jimenez | Toro | 1987-06-03 | 3 | Rionegro Cra 37 # 7-78 | 2115147 | mjimenez@gmail.com | masculino | activo | | 98986 | Andres | Felipe | Gomez | Arias | 1994-10-25 | 3 | Guarne Cra 35 # 88-74 | 2147483647 | agomez@gmail.com | masculino | activo | +----------------+---------------+----------------+------------------+------------------+------------------+----------+---------------------------+------------+---------------------+-----------+--------+ 10 rows in set (0.000 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS DEPARTAMENTO **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from departamento; +----------------+--------------+--------+ | iddepartamento | descripcion | estado | +----------------+--------------+--------+ | 1 | antioquia | activo | | 2 | atlantico | activo | | 3 | cundinamarca | activo | +----------------+--------------+--------+ 3 rows in set (0.000 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS EMPLEADO **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from empleado; +-----------------+---------------+----------------+------------------+------------------+------------------+----------------------+----------+-----------------------+-----------+--------+ | cedula_empleado | primer_nombre | segundo_nombre | primero_apellido | segundo_apellido | fecha_nacimiento | direccion | telefono | correo | genero | estado | +-----------------+---------------+----------------+------------------+------------------+------------------+----------------------+----------+-----------------------+-----------+--------+ | 10043 | Isabel | Carolina | Benitez | Rodriguez | 1987-10-20 | carrera 40 nro 68-76 | 2113476 | dbenitez@gmail.com | femenino | activo | | 110243 | Jaqueline | Isabel | Castrillon | Botero | 1996-08-15 | carrera50 nro 68-19 | 2124576 | lcastrillon@gmail.com | femenino | activo | | 43418 | Marcela | Carolina | Arboleda | Tabares | 1982-11-12 | Carrera 48 nro 67-77 | 2119876 | marboleda@gmail.com | femenino | activo | | 98620 | Andres | Esteban | Garcia | Acevedo | 1985-06-02 | calle 92a nro36 | 2128976 | jgarcia@gmail.com | masculino | activo | +-----------------+---------------+----------------+------------------+------------------+------------------+----------------------+----------+-----------------------+-----------+--------+ 4 rows in set (0.000 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS FACTURA **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from factura; +-----------+----------------+-----------------+------------+----------+----------+-----------+-----------+-------+------------+-------------+----------------+----------------+ | idfactura | cedula_cliente | cedula_empleado | fecha | hora | subtotal | total_iva | descuento | total | idtipopago | descripcion | estado_sistema | estado_factura | +-----------+----------------+-----------------+------------+----------+----------+-----------+-----------+-------+------------+-------------+----------------+----------------+ | 1 | 46578 | 110243 | 2023-01-10 | 11:30:34 | 0 | 0 | 0 | 0 | 1 | | activo | activo | | 2 | 985423 | 10043 | 2023-02-25 | 09:27:35 | 0 | 0 | 0 | 0 | 2 | | activo | activo | | 3 | 11023 | 10043 | 2023-02-25 | 11:00:00 | 0 | 0 | 0 | 0 | 1 | | activo | activo | | 4 | 1107659 | 43418 | 2023-03-02 | 12:27:34 | 0 | 0 | 0 | 0 | 3 | | activo | activo | | 5 | 96780 | 98620 | 2023-03-02 | 10:09:55 | 0 | 0 | 0 | 0 | 2 | | activo | activo | | 6 | 11203 | 98620 | 2023-04-12 | 07:24:10 | 0 | 0 | 0 | 0 | 1 | | activo | activo | | 7 | 96234 | 110243 | 2023-04-12 | 11:10:03 | 0 | 0 | 0 | 0 | 1 | | activo | activo | | 8 | 43200 | 43418 | 2023-05-01 | 12:20:46 | 0 | 0 | 0 | 0 | 2 | | activo | activo | | 9 | 98986 | 43418 | 2023-05-01 | 10:20:46 | 0 | 0 | 0 | 0 | 4 | | activo | activo | | 10 | 43894 | 98620 | 2023-05-05 | 12:00:00 | 0 | 0 | 0 | 0 | 2 | | activo | activo | +-----------+----------------+-----------------+------------+----------+----------+-----------+-----------+-------+------------+-------------+----------------+----------------+ 10 rows in set (0.001 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS PEDIDO **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from pedido; Empty set (0.001 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS PERFIL **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from perfil; Empty set (0.001 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS PRODUCTO **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from producto; +------------+----------+-----------------+---------+-------+--------+-------+-------------+--------+ | idproducto | codigotp | nombre | img_ref | stock | valor | iva | valor_venta | estado | +------------+----------+-----------------+---------+-------+--------+-------+-------------+--------+ | 1 | 2 | pantalon_mujer | NULL | 120 | 100000 | 19000 | 119000 | activo | | 2 | 1 | pantalon_hombre | NULL | 120 | 80000 | 15200 | 95200 | activo | | 3 | 3 | pantalon_ni os | NULL | 110 | 70000 | 13300 | 83300 | activo | | 4 | 2 | blusa_mujer | NULL | 215 | 60000 | 11400 | 71400 | activo | | 5 | 3 | blusa_ni os | NULL | 200 | 40000 | 7600 | 47600 | activo | | 6 | 1 | chaqueta_hombre | NULL | 110 | 180000 | 34200 | 214200 | activo | | 7 | 2 | chaqueta_mujer | NULL | 150 | 150000 | 28500 | 178500 | activo | | 8 | 3 | chaqueta_ni os | NULL | 300 | 100000 | 19000 | 119000 | activo | | 9 | 2 | vestido_mujer | NULL | 300 | 80000 | 15200 | 95200 | activo | | 10 | 3 | vestido_ni os | NULL | 400 | 50000 | 13300 | 63300 | activo | | 11 | 1 | camiseta_hombre | NULL | 180 | 70000 | 13300 | 83300 | activo | | 12 | 2 | falda | NULL | 250 | 70000 | 13300 | 83300 | activo | | 13 | 1 | pijama_hombre | NULL | 190 | 40000 | 7600 | 47600 | activo | | 14 | 2 | pijama_mujer | NULL | 260 | 50000 | 9500 | 59500 | activo | | 15 | 3 | pijama_ni os | NULL | 180 | 40000 | 7600 | 47600 | activo | | 16 | 1 | sudadera_hombre | NULL | 150 | 100000 | 19000 | 119000 | activo | | 17 | 2 | sudadera_mujer | NULL | 190 | 80000 | 15200 | 95200 | activo | | 18 | 3 | sudadera_ni os | NULL | 190 | 70000 | 13300 | 83300 | activo | +------------+----------+-----------------+---------+-------+--------+-------+-------------+--------+ 18 rows in set (0.001 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS TIPO_PAGO **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from tipo_pago; +------------+---------------+ | idtipopago | descripcion | +------------+---------------+ | 1 | efectivo | | 2 | transferencia | | 3 | tarjeta | | 4 | credito | +------------+---------------+ 4 rows in set (0.001 sec) **************************************************************************************************************************************************************** VISUALIZAR LOS DATOS DE LAS TABLAS TIPO_PRODUCTO **************************************************************************************************************************************************************** MariaDB [almacen2]> select * from tipo_producto; +----------+-------------+ | codigotp | descripcion | +----------+-------------+ | 1 | Hombre | | 2 | Mujer | | 3 | Ni os | +----------+-------------+ 3 rows in set (0.001 sec) MariaDB [almacen2]> select * from usuario; Empty set (0.001 sec) **************************************************************************************************************************************************************** CREAR TABLA AUDITORIA_PRODUCTO PARA UN TRIGGERS **************************************************************************************************************************************************************** MariaDB [almacen2]> CREATE TABLE almacen2.auditoria_producto ( -> id INT AUTO_INCREMENT PRIMARY KEY, -> accion VARCHAR(255), -> fecha_hora DATETIME); Query OK, 0 rows affected (0.303 sec) MariaDB [almacen2]> show tables; +--------------------+ | Tables_in_almacen2 | +--------------------+ | auditoria_producto | | ciudad | | cliente | | departamento | | empleado | | factura | | pagos | | pedido | | perfil | | producto | | tipo_pago | | tipo_producto | | usuario | +--------------------+ 13 rows in set (0.001 sec)