外键约束

CREATE TABLE `organization` (
  `ORGANIZATION_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PARENT_ORGANIZATION_ID` int(11) NOT NULL,
  `ORGANIZATION_NAME` varchar(256) DEFAULT NULL,
  `MASTER_ORGANIZATION_ID` int(11) DEFAULT NULL,
  `LOGO_IMAGE_ID` int(11) DEFAULT NULL,
  `PT_ACCOUNT_NUMBER` varchar(64) DEFAULT NULL,
  `WEB_URL` varchar(128) DEFAULT NULL,
  `ORGANIZATION_EMAIL` varchar(128) DEFAULT NULL,
  `ORGANIZATION_STATUS_ID` int(11) NOT NULL DEFAULT '1',
  `LANGUAGE_CODE` varchar(2) DEFAULT NULL,
  `INSERT_DATE` datetime NOT NULL,
  `INSERTED_BY` varchar(256) DEFAULT NULL,
  `UPDATE_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `UPDATED_BY` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ORGANIZATION_ID`),
  KEY `IX_ORGANIZATION_01` (`PARENT_ORGANIZATION_ID`),
  KEY `IX_ORGANIZATION_02` (`ORGANIZATION_STATUS_ID`),
  KEY `IX_ORGANIZATION_03` (`LANGUAGE_CODE`),
  KEY `IX_ORGANIZATION_04` (`MASTER_ORGANIZATION_ID`),
  CONSTRAINT `FK_ORGANIZATION_01` FOREIGN KEY (`PARENT_ORGANIZATION_ID`) REFERENCES `organization` (`ORGANIZATION_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_ORGANIZATION_02` FOREIGN KEY (`ORGANIZATION_STATUS_ID`) REFERENCES `organization_status` (`ORGANIZATION_STATUS_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_ORGANIZATION_03` FOREIGN KEY (`LANGUAGE_CODE`) REFERENCES `language` (`LANGUAGE_CODE`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_ORGANIZATION_04` FOREIGN KEY (`MASTER_ORGANIZATION_ID`) REFERENCES `master_organization` (`MASTER_ORGANIZATION_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=99 ;

INSERT INTO `organization` VALUES (1,0,'ROOT OF ORGANIZATION TREE',NULL,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 21:17:37',NULL,'2014-02-13 02:17:37',NULL),(2,1,'Home Office',1,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:36','System'),(3,1,'Home Office',2,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:36','System'),(4,1,'Northeast Office',2,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:36','System'),(5,1,'Home Office',3,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:37','System'),(6,1,'Home Office',4,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:37','System'),(7,1,'Home Office',5,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:37','System'),(8,1,'Ohio Branch',5,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:38','System'),(9,1,'NH Branch',5,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:38','System'),(10,1,'Home Office',5,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:38','System'),(11,1,'Home Office',5,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:38','System'),(12,1,'Home Office',6,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:38','System'),(13,1,'Home Office',7,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:38','System'),(14,1,'Home Office',8,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:39','System'),(15,1,'Home Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:39','System'),(16,1,'MD Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(17,1,'Home Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(18,1,'MD Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(19,1,'Home Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(20,1,'Home Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(21,1,'Home Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(22,1,'Home Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(23,1,'MD Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:40','System'),(24,1,'New England Office',9,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:41','System'),(25,1,'Home Office',10,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:41','System'),(26,1,'Home Office',11,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:41','System'),(27,1,'Maryland Office',11,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:42','System'),(28,1,'Home Office',11,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:42','System'),(29,1,'MD Office',11,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:42','System'),(30,1,'New England Office',11,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:42','System'),(31,1,'Home Office',12,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:43','System'),(32,1,'Home Office',12,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:43','System'),(33,1,'Home Office',12,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:43','System'),(34,1,'Home Office',13,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:43','System'),(35,1,'MD Office',13,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:44','System'),(36,1,'Home Office',13,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:44','System'),(37,1,'Home Office',13,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:44','System'),(38,1,'Home Office',14,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:44','System'),(39,1,'Home Office',14,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:44','System'),(40,1,'Home Office',15,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:45','System'),(41,1,'Home Office',19,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:45','System'),(42,1,'MD Office',19,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(43,1,'Home Office',21,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(44,1,'New England Office',21,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(45,1,'Home Office',22,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(46,1,'NJ Office',22,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(47,1,'Home Office',23,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(48,1,'Home Office',24,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(49,1,'Company of America',24,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:46','System'),(50,1,'Home Office',25,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:47','System'),(51,1,'Home Office',26,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:47','System'),(52,1,'Home Office',27,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:47','System'),(53,1,'Home Office',28,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:47','System'),(54,1,'Home Office',28,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(55,1,'Home Office',29,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(56,1,'SE',31,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(57,1,'SureTec Insurance Company',32,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(58,1,'Navigators Insurance Company',33,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(59,1,'Insco Dico Group',34,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(60,1,'MD Office',34,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(61,1,'Nationwide Insurance Company',35,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:48','System'),(62,1,'Nationwide Insurance Company',35,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:49','System'),(63,1,'Nationwide Insurance Company',35,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:49','System'),(64,1,'Nationwide Insurance Company',35,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:49','System'),(65,1,'Colonial Surety',37,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:49','System'),(66,1,'Richmond Branch',38,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:50','System'),(67,1,'Home Office',39,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:50','System'),(68,1,'New England Office',40,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:50','System'),(69,1,'NY Office',41,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:50','System'),(70,1,'Home Office',42,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:50','System'),(71,1,'Head Office',43,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 00:00:00','System','2014-02-13 02:20:50','System'),(72,1,'SA Obligee',44,NULL,'','',NULL,1,'EN','2014-02-12 21:28:00','Jane Doe','2014-02-13 02:28:00','Jane Doe'),(73,1,'Sandip Test Agency',45,NULL,NULL,'www.saagency.ca',NULL,1,NULL,'2014-02-12 21:30:03','Sandip Test Agency','2014-02-13 02:30:03','Sandip Test Agency'),(74,1,'Alabama Department of  Revenue',46,NULL,'','',NULL,1,'EN','2014-02-12 21:31:43','Jane Doe','2014-02-13 02:31:43','Jane Doe'),(75,1,'Test Client 11',47,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 21:44:55','Sandip Client Client 11','2014-02-13 02:44:55','Sandip Client Client 11'),(76,1,'Test Agency on 12 Feb',48,NULL,NULL,'www.test.com',NULL,1,NULL,'2014-02-12 21:45:18','Agency User','2014-02-13 02:45:30','Agency User'),(77,1,'Test Sub broker 11',49,NULL,NULL,'www.saagency.ca',NULL,1,NULL,'2014-02-12 22:00:00','Test Subbroker','2014-02-13 03:00:00','Test Subbroker'),(78,1,'sub broker client',50,NULL,NULL,NULL,NULL,1,NULL,'2014-02-12 22:00:41','Test Subbroker','2014-02-13 03:00:41','Test Subbroker'),(79,1,'sub broker company',52,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 14:48:44','Test Subbroker','2014-02-13 19:48:44','Test Subbroker'),(80,1,'Subbroker1',53,NULL,NULL,'www.test.com',NULL,1,NULL,'2014-02-13 14:49:34','Subbroker User','2014-02-13 19:49:34','Subbroker User'),(81,1,'sub broker company 1',55,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 14:57:18','Test Subbroker','2014-02-13 19:57:40','Test Subbroker'),(82,1,'Test Client 41',56,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 15:02:48','Test  Client 41','2014-02-13 20:02:48','Test  Client 41'),(83,1,'Org1',57,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 15:03:57','Subbroker User','2014-02-13 20:04:57','Subbroker User'),(87,1,'Agency Test',61,NULL,NULL,'http://www.san.com',NULL,1,NULL,'2014-02-13 11:05:42','kipling avenue','2014-02-13 16:05:42','kipling avenue'),(88,1,'sdfdsf',62,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 11:09:56','kipling avenue','2014-02-13 16:09:56','kipling avenue'),(90,1,'Agency Testw',64,NULL,NULL,'http://www.san.com',NULL,1,NULL,'2014-02-13 11:16:06','agency dew','2014-02-13 16:16:06','agency dew'),(91,1,'sdfdsfe',66,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 11:18:17','agency dew','2014-02-13 16:18:17','agency dew'),(92,1,'thursday',67,NULL,NULL,'http://www.san.com',NULL,1,NULL,'2014-02-13 12:45:45','thursday week','2014-02-13 17:45:45','thursday week'),(93,1,'ABC Inc',68,NULL,NULL,NULL,NULL,1,NULL,'2014-02-13 12:48:51','thursday week','2014-02-13 17:48:51','thursday week'),(94,1,'Agency Teste',70,NULL,NULL,'http://www.san.com',NULL,1,NULL,'2014-02-14 14:38:32','friday week','2014-02-14 19:38:32','friday week'),(95,1,'sdfdsfee',72,NULL,NULL,NULL,NULL,1,NULL,'2014-02-14 14:40:21','friday week','2014-02-14 19:40:21','friday week'),(97,1,'Sandip2',74,NULL,NULL,'http://www.san.com',NULL,1,NULL,'2014-02-14 15:21:14','satday week','2014-02-14 20:21:14','satday week'),(98,1,'ABC1 Inc',76,NULL,NULL,NULL,NULL,1,NULL,'2014-02-14 15:25:25','satday week','2014-02-14 20:25:25','satday week');

如果删除第一个外键CONSTRAINT `FK_ORGANIZATION_01` FOREIGN KEY (`PARENT_ORGANIZATION_ID`) REFERENCES `organization` (`ORGANIZATION_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,，就可以把数据插入数据库中。

我想这个外键实际上是一个指向自己主键的外键，这不是扯么？顶多是一个指向其它已有记录的约束。关键是第一个记录无法增加进去，不就等于把大门关起来了还想进屋？