| Respuesta: duda sobre estructura BD
Hola gnzsolyo, ya he montado toda la bd y solo te pido que le heches un bistazo y me des tu consejo de la misma, tu o cualquiera que se ofrezca. Me parece que entendí bien todo y cada vez se me va haciendo menos grande esto, pero aún me queda.
He copiado el export que he hecho directamente de phpmyadmin, logicamente lo he resumindo para no dar tanto la paliza y vemos que tal.
Gracias por todo.
------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `agencias` (
`agencia_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nom_comercial` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`titulo` varchar(65) COLLATE utf8_spanish_ci NOT NULL,
`descripcion` text COLLATE utf8_spanish_ci NOT NULL,
`per_contacto` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`nom_fiscal` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`nif` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
`calle_fiscal` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`calle_num` varchar(5) COLLATE utf8_spanish_ci NOT NULL,
`piso` varchar(3) COLLATE utf8_spanish_ci NOT NULL,
`puerta` varchar(3) COLLATE utf8_spanish_ci NOT NULL,
`escalera` varchar(3) COLLATE utf8_spanish_ci NOT NULL,
`cod_postal` varchar(7) COLLATE utf8_spanish_ci NOT NULL,
`fijo_1` varchar(9) COLLATE utf8_spanish_ci NOT NULL,
`fijo_2` varchar(9) COLLATE utf8_spanish_ci NOT NULL,
`movil_1` varchar(9) COLLATE utf8_spanish_ci NOT NULL,
`movil_2` varchar(9) COLLATE utf8_spanish_ci NOT NULL,
`correo` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`correo_cont` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`web` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`desc_apartamentos` text COLLATE utf8_spanish_ci NOT NULL,
`reservas` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`pagos` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
PRIMARY KEY (`agencia_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `escorts` (
`escort_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`agencia_id` int(11) DEFAULT NULL,
`nom_comercial` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`titulo` varchar(65) COLLATE utf8_spanish_ci NOT NULL,
`descripcion` text COLLATE utf8_spanish_ci NOT NULL,
`per_contacto` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
`nom_fiscal` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`nif` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
`calle_fiscal` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`calle_num` varchar(5) COLLATE utf8_spanish_ci NOT NULL,
`piso` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
`puerta` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
`escalera` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
`cod_postal` varchar(7) COLLATE utf8_spanish_ci NOT NULL,
`fijo_1` varchar(9) COLLATE utf8_spanish_ci DEFAULT NULL,
`fijo_2` varchar(9) COLLATE utf8_spanish_ci DEFAULT NULL,
`movil_1` varchar(9) COLLATE utf8_spanish_ci NOT NULL,
`movil_2` varchar(9) COLLATE utf8_spanish_ci DEFAULT NULL,
`correo` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`correo_cont` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`web` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`edad` enum('18','19','20','21','22','23','24','25','26', '27','28','29','30','31','32','33','34','35','36', '37','38','39','40','41','42','43','44','45','46', '47','48','49','50','51','52','53','54','55','56', '57','58','59','60') COLLATE utf8_spanish_ci NOT NULL,
`nacionalidad` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
`medidas` varchar(8) COLLATE utf8_spanish_ci DEFAULT NULL,
`altura` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
`peso` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
`apartamento` varchar(150) COLLATE utf8_spanish_ci DEFAULT NULL,
`parking` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`metro` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`autobus` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`reservas` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`pago` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
PRIMARY KEY (`escort_id`),
KEY `agencia_id` (`agencia_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `fotos` (
`fotos_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`escort_id` int(11) NOT NULL,
`foto` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
PRIMARY KEY (`fotos_id`),
KEY `escorts_id` (`escort_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `municipios` (
`municipio_id` bigint(11) NOT NULL AUTO_INCREMENT,
`provincias_id` int(2) NOT NULL,
`municipio` varchar(255) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
PRIMARY KEY (`municipio_id`),
KEY `provincia` (`provincias_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=8123 ;
INSERT INTO `municipios` (`municipio_id`, `provincias_id`, `municipio`) VALUES
(1, 1, 'Alegria-Dulantzi'),
(2, 1, 'Amurrio'),
(3, 1, 'Añana'),
(4, 1, 'Aramaio'),
(5, 1, 'Armiñón'),
(6, 1, 'Arraia-Maeztu'),
(7, 1, 'Arrazua-Ubarrundia'),
(8, 1, 'Artziniega'),
(9, 1, 'Asparrena'),
(10, 1, 'Ayala/Aiara'),
(11, 1, 'Baños de Ebro/Mañueta'),
(23, 1, 'Barrundia'),
(24, 1, 'Berantevilla'),
(25, 1, 'Bernedo'),
etc...
CREATE TABLE IF NOT EXISTS `provincias` (
`provincias_id` int(2) NOT NULL AUTO_INCREMENT,
`agencia_id` int(11) DEFAULT NULL,
`escort_id` int(11) DEFAULT NULL,
`provincia` varchar(255) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
PRIMARY KEY (`provincias_id`),
KEY `agencia_id` (`agencia_id`,`escort_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=53 ;
INSERT INTO `provincias` (`provincias_id`, `agencia_id`, `escort_id`, `provincia`) VALUES
(1, NULL, NULL, 'Álava'),
(2, NULL, NULL, 'Albacete'),
(3, NULL, NULL, 'Alicante'),
(4, NULL, NULL, 'Almer'),
etc...
CREATE TABLE IF NOT EXISTS `publiagencia` (
`publi_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`agencia_id` int(11) NOT NULL,
`banner728x90` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`banner300x218` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`logagencia125x125` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
PRIMARY KEY (`publi_id`),
KEY `agencia_id` (`agencia_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `publiescorts` (
`publiescorts_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`escort_id` int(11) NOT NULL,
`banner728x90` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`banner300x218` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
`logo125x125` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
PRIMARY KEY (`publiescorts_id`),
KEY `escorts_id` (`escort_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `tags` (
`tags_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`agencia_id` int(11) DEFAULT NULL,
`escort_id` int(11) DEFAULT NULL,
`tipos_tags` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
PRIMARY KEY (`tags_id`),
KEY `agencia_id` (`agencia_id`,`escort_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=34 ;
INSERT INTO `tags` (`tags_id`, `agencia_id`, `escort_id`, `tipos_tags`) VALUES
(1, NULL, NULL, 'acompañantes'),
(2, NULL, NULL, 'agencias'),
(3, NULL, NULL, 'agencias contactos'),
(4, NULL, NULL, 'agencias escorts'),
(5, NULL, NULL, 'agencias putas'),
(6, NULL, NULL, 'agencias relax'),
etc... |