Re: ri
delimiter $$
CREATE TABLE `adress` (
`adr_id` varchar(20) NOT NULL,
`adr_name` varchar(100) NOT NULL,
`adr_vorname` varchar(100) NOT NULL,
`adr_strasse` varchar(100) NOT NULL,
`adr_plz` varchar(5) NOT NULL,
`adr_ort` varchar(100) NOT NULL,
`adr_geburt` date DEFAULT NULL,
`adr_aufnahme` date DEFAULT NULL,
`adr_telefon1` varchar(100) DEFAULT NULL,
`adr_telefon2` varchar(100) DEFAULT NULL,
`adr_handy` varchar(100) DEFAULT NULL,
`adr_fax` varchar(100) DEFAULT NULL,
`adr_reart` int(8) DEFAULT NULL,
`lnd_id` varchar(20) DEFAULT NULL,
`anr_id` varchar(20) DEFAULT NULL,
`ver_id` varchar(20) DEFAULT NULL,
PRIMARY KEY (`pat_id`),
KEY `FK_Land` (`lnd_id`),
KEY `FK_Anrede` (`anr_id`),
KEY `FK_Versicherung` (`ver_id`),
CONSTRAINT `Relation_215` FOREIGN KEY (`ver_id`) REFERENCES `versicherung` (`ver_id`),
CONSTRAINT `Relation_208` FOREIGN KEY (`lnd_id`) REFERENCES `land` (`lnd_id`),
CONSTRAINT `Relation_210` FOREIGN KEY (`anr_id`) REFERENCES `anrede` (`anr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
Subject
Views
Written By
Posted
2183
December 09, 2012 06:14AM
1126
December 09, 2012 06:54AM
955
December 09, 2012 07:13AM
989
December 09, 2012 07:22AM
Re: ri
942
December 09, 2012 08:28AM
1076
December 09, 2012 08:50AM
1010
December 10, 2012 02:03AM
1163
December 10, 2012 02:14AM
1091
December 10, 2012 02:22AM
984
December 10, 2012 02:33AM
1060
December 10, 2012 02:50AM
1009
December 10, 2012 03:01AM
1075
December 10, 2012 03:18AM
1107
December 10, 2012 06:51AM
1101
December 10, 2012 07:39AM