def |
Hospital |
Doctor |
ID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Hospital |
Doctor |
Name |
2 |
NULL
|
NO |
varchar |
25 |
100 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(25) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Hospital |
Doctor |
Department |
3 |
NULL
|
NO |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Hospital |
Doctor |
Address |
4 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Hospital |
Doctor |
Dept_ID |
5 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Hospital |
Doctor |
Doc_id |
6 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
id_ubigeo |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
ubigeo_reniec |
2 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
ubigeo_inei |
3 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
departamento_inei |
4 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
departamento |
5 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
provincia_inei |
6 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
provincia |
7 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
distrito |
8 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
region |
9 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
macroregion_inei |
10 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
macroregion_minsa |
11 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
iso_3166_2 |
12 |
NULL
|
NO |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
fips |
13 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
superficie |
14 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
altitud |
15 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
latitud |
16 |
NULL
|
NO |
float |
NULL
|
NULL
|
12 |
NULL
|
NULL
|
NULL
|
NULL
|
float |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Ubigeos |
ubigeos |
longitud |
17 |
NULL
|
NO |
float |
NULL
|
NULL
|
12 |
NULL
|
NULL
|
NULL
|
NULL
|
float |
|
|
select,insert,update,references |
|
|
NULL
|
def |
foldrajz |
orszagok |
id |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
foldrajz |
orszagok |
orszag |
2 |
|
NO |
varchar |
27 |
81 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_hungarian_ci |
varchar(27) |
|
|
select,insert,update,references |
|
|
NULL
|