Re: ri

[werner meyer]

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$$