def |
Consultorio |
Cita |
Nro_Cita |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(7) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Cita |
Fecha |
2 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Cita |
Hora |
3 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Cita |
ID_Paciente |
4 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Cita |
Cod_Médico |
5 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(6) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Cita |
Motivo_cita |
6 |
NULL
|
YES |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Diagnóstico |
ID_diagnostico |
1 |
NULL
|
YES |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Diagnóstico |
Descripción |
2 |
NULL
|
YES |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Diagnóstico |
Nro_Cita |
3 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(7) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Factura |
ID_factura |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Factura |
Monto_total |
2 |
NULL
|
YES |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Factura |
Fecha |
3 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Factura |
Nro_Cita |
4 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(7) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Medico |
Cod_Médico |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(6) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Medico |
Nombre |
2 |
NULL
|
NO |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Medico |
Apellidos |
3 |
NULL
|
NO |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Medico |
Celular |
4 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
Medico |
Email |
5 |
NULL
|
YES |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
ID_Paciente |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
Nombre |
2 |
NULL
|
NO |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
Apellidos |
3 |
NULL
|
NO |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
Fecha_de_nacimiento |
4 |
NULL
|
NO |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
Direccion |
5 |
NULL
|
NO |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
Celular |
6 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Consultorio |
paciente |
Email |
7 |
NULL
|
YES |
tinytext |
255 |
255 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
tinytext |
|
|
select,insert,update,references |
|
|
NULL
|