FOREIGN KEY

-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `table_1`
--

CREATE TABLE IF NOT EXISTS `table_1` (
  `id` varchar(11) NOT NULL DEFAULT '',
  `name` varchar(20) DEFAULT NULL,
  `comment` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `table_2`
--

CREATE TABLE IF NOT EXISTS `table_2` (
  `address` varchar(20) NOT NULL DEFAULT '',
  `email` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `table_3`
--

CREATE TABLE TABLE_3
(
  id  varchar(11),
  address varchar(20),
  email varchar(20),
  PRIMARY KEY (id, address),
  FOREIGN KEY (id) REFERENCES TABLE_1 (id) ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (address) REFERENCES TABLE_2 (address) ON DELETE CASCADE ON UPDATE CASCADE
)