ventas.txt

MariaDB [ventas]> describe ventas;
+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| idPaciente | int(11)             | NO   | MUL | NULL    |                |
| fecha      | datetime            | NO   |     | NULL    |                |
| total      | decimal(7,2)        | YES  |     | NULL    |                |
| vista      | tinyint(1)          | NO   |     | 0       |                |
| idUsuario  | bigint(20) unsigned | NO   |     | NULL    |                |
| estado     | int(11)             | NO   |     | 0       |                |
| idMedico   | int(200)            | NO   | MUL | 1       |                |
+------------+---------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)