5arb3CEj

1create table pais(
2 id_pais int auto_increment primary key,
3 nombre_pais varchar(50) not null
4) 
5     
6create table provincia(
7 id_provincia int auto_increment primary key,
8 nombre_prov varchar(50) not null,
9 idPais int not null,
10 foreign key (idPais) references pais(id_pais)
11 on delete cascade on update cascade
12) 
13     
14create table departamento(
15 id_departamento int auto_increment primary key,
16 nombre_dpto varchar (50) not null,
17 id_prov int not null,
18 foreign key (id_prov) references provincia (id_provincia)
19 on delete cascade on update cascade
20) 
21     
22create table municipio(
23 id_municipio int auto_increment primary key,
24 nombre_mun varchar (50) not null,
25 id_dpto int not null,
26 foreign key (id_dpto) references departamento (id_departamento)
27 on delete cascade on update cascade
28) 
29     
30create table localidad(
31 id_localidad int auto_increment primary key,
32 nombre_loc varchar (50) not null,
33 id_mun int not null,
34 foreign key (id_mun) references municipio(id_municipio)
35 on delete cascade on update cascade
36) 
37     
38create table barrio(
39 id_barrio int auto_increment primary key,
40 nombre_barrio varchar (50) not null,
41 id_loc int not null,
42 foreign key (id_loc) references localidad(id_loc)
43 on delete cascade on update cascade
44) 
45     
46CREATE TABLE IF NOT EXISTS persona (
47  id_persona  int  AUTO_INCREMENT,
48  nombre_per  varchar(100) not null,
49  apellido_per  varchar(100) not null,
50  numeroId  int  not  null,
51  calle varchar(100) not null,
52  numeroCalle  varchar(10),
53  piso  varchar(10),
54  dpto  varchar(10),
55  lote  varchar(10),
56  mzna  varchar(10),
57  entreCalle  varchar(100),
58  yCalle  varchar(100),
59  CP  varchar(10) not null,
60  cod_fijo  int(11) not null,
61  fijo  int(11) not null,
62  cod_celular  int(11) not null,
63  celular  int(11) not null,
64  id_ba  int not null,
65  id_loc1 int not null,
66 id_mun1 int not null,
67  id_dpto1 int not null,
68  id_prov1 int not null,
69  id_pais1 int not null,
70  PRIMARY KEY (id_persona),
71  id_ba  int not null,
72  id_loc1 int not null,
73  id_mun1 int  not null,
74  id_dpto1 int not null,
75  id_prov1 int not null,
76  id_pais1 int not null,
77
78FOREIGN KEY (id_ba) REFERENCES barrio (id_barrio) ON DELETE CASCADE ON UPDATE CASCADE,
79FOREIGN KEY (id_loc1) REFERENCES localidad (id_localidad) ON DELETE CASCADE ON UPDATE CASCADE,
80FOREIGN KEY (id_mun1) REFERENCES municipio (id_municipio) ON DELETE CASCADE ON UPDATE CASCADE,
81FOREIGN KEY (id_dpto1) REFERENCES departamento(id_departamento) ON DELETE CASCADE ON UPDATE CASCADE,
82FOREIGN KEY (`id_prov1`) REFERENCES provincia (id_provincia) ON DELETE CASCADE ON UPDATE CASCADE,
83FOREIGN KEY (id_pais1) REFERENCES pais (id_pais) ON DELETE CASCADE ON UPDATE CASCADE
84);