MySQL Forums
Forum List  »  German

Re: ri
Posted by: werner meyer
Date: December 09, 2012 08:28AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
ri
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


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.