text: -- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
  --
  -- Host: localhost    Database: story_of_stone
  -- ------------------------------------------------------
  -- Server version	5.7.24-0ubuntu0.18.04.1
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `allowance`
  --
  
  DROP TABLE IF EXISTS `allowance`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `allowance` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `type` varchar(255) NOT NULL COMMENT '月例类型名称',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `allowance`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `allowance` WRITE;
  /*!40000 ALTER TABLE `allowance` DISABLE KEYS */;
  INSERT INTO `allowance` VALUES
  ('丰儿','二等丫鬟'),
  ('佳蕙','二等丫鬟'),
  ('入画','小主子一等丫鬟'),
  ('卍儿','小主子一等丫鬟'),
  ('司棋','小主子一等丫鬟'),
  ('周姨娘','姨娘'),
  ('善姐','二等丫鬟'),
  ('四儿','二等丫鬟'),
  ('坠儿','二等丫鬟'),
  ('媚人','小主子一等丫鬟'),
  ('小吉祥','二等丫鬟'),
  ('小红','二等丫鬟'),
  ('小鹊','二等丫鬟'),
  ('尤氏','奶奶'),
  ('平儿','小主子一等丫鬟'),
  ('彩云','大主子一等丫鬟'),
  ('彩屏','小主子一等丫鬟'),
  ('彩霞','大主子一等丫鬟'),
  ('彩鸾','大主子一等丫鬟'),
  ('待书','小主子一等丫鬟'),
  ('文官','大主子一等丫鬟'),
  ('春燕','小主子一等丫鬟'),
  ('春纤','小主子一等丫鬟'),
  ('晴雯','小主子一等丫鬟'),
  ('李纨','李纨'),
  ('檀云','小主子一等丫鬟'),
  ('炒豆','小主子一等丫鬟'),
  ('玉钏','大主子一等丫鬟'),
  ('王夫人','太太'),
  ('王熙凤','奶奶'),
  ('玻璃','大主子一等丫鬟'),
  ('珍珠','大主子一等丫鬟'),
  ('琥珀','大主子一等丫鬟'),
  ('碧痕','小主子一等丫鬟'),
  ('秋纹','小主子一等丫鬟'),
  ('紫鹃','小主子一等丫鬟'),
  ('绣凤','大主子一等丫鬟'),
  ('绣桔','小主子一等丫鬟'),
  ('绣鸾','大主子一等丫鬟'),
  ('绮霰','小主子一等丫鬟'),
  ('缕儿','小主子一等丫鬟'),
  ('翠墨','小主子一等丫鬟'),
  ('翠缕','小主子一等丫鬟'),
  ('翡翠','大主子一等丫鬟'),
  ('艾官','小主子一等丫鬟'),
  ('芳官','小主子一等丫鬟'),
  ('茄官','小主子一等丫鬟'),
  ('茜雪','小主子一等丫鬟'),
  ('莲花儿','二等丫鬟'),
  ('葵官','小主子一等丫鬟'),
  ('藕官','小主子一等丫鬟'),
  ('蝉姐','小主子一等丫鬟'),
  ('袭人','袭人'),
  ('贾母','太太'),
  ('赵姨娘','姨娘'),
  ('邢夫人','太太'),
  ('金钏','大主子一等丫鬟'),
  ('银蝶','小主子一等丫鬟'),
  ('雪雁','小主子一等丫鬟'),
  ('靛儿','二等丫鬟'),
  ('鸳鸯','大主子一等丫鬟'),
  ('鹦鹉','大主子一等丫鬟'),
  ('麝月','小主子一等丫鬟');
  /*!40000 ALTER TABLE `allowance` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `allowance_type`
  --
  
  DROP TABLE IF EXISTS `allowance_type`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `allowance_type` (
    `name` varchar(255) NOT NULL COMMENT '月例类型名称',
    `silver` decimal(10,3) NOT NULL COMMENT '以银两形式发放的量，单位：两',
    `coin` decimal(10,3) NOT NULL COMMENT '以制钱形式发放的量，单位：文，一吊钱=1000文',
    `note` mediumtext NOT NULL COMMENT '月例注解',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `allowance_type`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `allowance_type` WRITE;
  /*!40000 ALTER TABLE `allowance_type` DISABLE KEYS */;
  INSERT INTO `allowance_type` VALUES
  ('二等丫鬟',0.000,500.000,'第36回，佳蕙等八个小丫头，每月人各月钱五百。从旧年他们外头商议的，姨娘们每位的丫头分例减半，人各五百钱。'),
  ('大主子一等丫鬟',1.000,0.000,'第36回，老太太屋里几个大丫头都是一两，王夫人说金钏死了省下一两银子，说明金钏也是大丫头。'),
  ('太太',20.000,0.000,'第45回，李纨跟凤姐商量诗社的活动经费，凤姐讲李纨跟老太太、太太一样月例了。第36回，王夫人说自己的月例是20两。'),
  ('奶奶',3.300,0.000,'第45回，王熙凤对李纨说：你一个月十两银子的月钱，比我们多两倍银子'),
  ('姨娘',2.000,0.000,'第三十六回，王夫人问凤姐，赵姨娘与周姨娘的月例是多少，凤姐回答：“那是定例，每人二两。”'),
  ('小主子',2.000,0.000,''),
  ('小主子一等丫鬟',0.000,1000.000,'第36回，就是晴雯麝月等七个大丫头，每月人各月钱一吊，佳蕙等八个小丫头，每月人各月钱五百'),
  ('李纨',20.000,0.000,'正房太太10两，贾母又特别拨了10两'),
  ('袭人',2.000,1000.000,'第35回，原本从贾母领一两月例，王夫人改为从自己这里领二两银子一吊钱');
  /*!40000 ALTER TABLE `allowance_type` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `family`
  --
  
  DROP TABLE IF EXISTS `family`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `family` (
    `name` varchar(255) NOT NULL COMMENT '名称',
    `branch` enum('正','旁','连宗') NOT NULL COMMENT '分支',
    `cradle` enum('','金陵','京城') DEFAULT NULL COMMENT '发源地',
    `residence` enum('','金陵','京城') DEFAULT NULL COMMENT '现居住地',
    PRIMARY KEY (`name`,`branch`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `family`
  --
  -- ORDER BY:  `name`,`branch`
  
  LOCK TABLES `family` WRITE;
  /*!40000 ALTER TABLE `family` DISABLE KEYS */;
  INSERT INTO `family` VALUES
  ('史家','正','金陵','金陵'),
  ('王家','正','金陵','金陵'),
  ('王家','连宗','',''),
  ('薛家','正','金陵','金陵'),
  ('贾家','正','金陵','京城'),
  ('贾家','旁','金陵','京城'),
  ('贾家','连宗','金陵','京城');
  /*!40000 ALTER TABLE `family` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `kinship`
  --
  
  DROP TABLE IF EXISTS `kinship`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kinship` (
    `subject` varchar(255) NOT NULL COMMENT '主',
    `object` varchar(255) NOT NULL COMMENT '宾',
    `type` enum('夫妻','祖孙','亲子') NOT NULL COMMENT '主类型',
    `sub_type` enum('亲生','收养','过继','正房','偏房','续弦','虚拟','') NOT NULL COMMENT '子类型',
    `note` mediumtext NOT NULL COMMENT '注解',
    PRIMARY KEY (`subject`,`object`,`type`,`sub_type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `kinship`
  --
  -- ORDER BY:  `subject`,`object`,`type`,`sub_type`
  
  LOCK TABLES `kinship` WRITE;
  /*!40000 ALTER TABLE `kinship` DISABLE KEYS */;
  INSERT INTO `kinship` VALUES
  ('史候','史湘云之祖父','亲子','亲生',''),
  ('史候','贾母','亲子','亲生',''),
  ('史湘云之父','史湘云','亲子','亲生',''),
  ('史湘云之祖父','史湘云之父','亲子','亲生',''),
  ('史湘云之祖父','史鼎','亲子','亲生',''),
  ('史湘云之祖父','史鼐','亲子','亲生',''),
  ('李纨','贾兰','亲子','亲生',''),
  ('林如海','林黛玉','亲子','亲生',''),
  ('林如海','贾敏','夫妻','正房',''),
  ('根','史候','亲子','虚拟',''),
  ('根','王公','亲子','虚拟',''),
  ('根','薛公','亲子','虚拟',''),
  ('根','贾代儒之父','亲子','虚拟',''),
  ('根','贾源','亲子','虚拟',''),
  ('根','贾演','亲子','虚拟',''),
  ('王公','王夫人之父','亲子','亲生',''),
  ('王夫人','贾元春','亲子','亲生',''),
  ('王夫人','贾宝玉','亲子','亲生',''),
  ('王夫人','贾珠','亲子','亲生',''),
  ('王夫人之父','王夫人','亲子','亲生',''),
  ('王夫人之父','王子腾','亲子','亲生',''),
  ('王夫人之父','王熙凤之父','亲子','亲生',''),
  ('王夫人之父','薛姨妈','亲子','亲生',''),
  ('王子腾','王子腾之女','亲子','亲生',''),
  ('王熙凤','贾巧姐','亲子','亲生',''),
  ('王熙凤之父','王仁','亲子','亲生',''),
  ('王熙凤之父','王熙凤','亲子','亲生',''),
  ('薛公','薛宝钗之祖父','亲子','亲生',''),
  ('薛姨妈','薛宝钗','亲子','亲生',''),
  ('薛姨妈','薛蟠','亲子','亲生',''),
  ('薛宝琴之父','薛宝琴','亲子','亲生',''),
  ('薛宝琴之父','薛蝌','亲子','亲生',''),
  ('薛宝钗之父','薛姨妈','夫妻','正房',''),
  ('薛宝钗之祖父','薛宝琴之父','亲子','亲生',''),
  ('薛宝钗之祖父','薛宝钗之父','亲子','亲生',''),
  ('薛蝌','邢岫烟','夫妻','正房','第57回，贾母做媒'),
  ('贾代儒','贾瑞之父','亲子','亲生',''),
  ('贾代儒之父','贾代儒','亲子','亲生',''),
  ('贾代化','贾敬','亲子','亲生','第2回，冷子兴演说'),
  ('贾代化','贾敷','亲子','亲生','第2回，冷子兴演说'),
  ('贾代善','贾政','亲子','亲生','第2回，冷子兴演说'),
  ('贾代善','贾敏','亲子','亲生','第2回，冷子兴演说'),
  ('贾代善','贾母','夫妻','正房','第2回，冷子兴演说'),
  ('贾代善','贾赦','亲子','亲生','第2回，冷子兴演说'),
  ('贾政','周姨娘','夫妻','偏房',''),
  ('贾政','王夫人','夫妻','正房',''),
  ('贾政','贾元春','亲子','亲生',''),
  ('贾政','贾宝玉','亲子','亲生',''),
  ('贾政','贾探春','亲子','亲生',''),
  ('贾政','贾环','亲子','亲生',''),
  ('贾政','贾珠','亲子','亲生',''),
  ('贾政','赵姨娘','夫妻','偏房',''),
  ('贾敏','林黛玉','亲子','亲生','第2回，冷子兴演说'),
  ('贾敬','贾惜春','亲子','亲生','第2回，冷子兴演说，惜春是贾珍胞妹。'),
  ('贾敬','贾珍','亲子','亲生','第2回，冷子兴演说'),
  ('贾母','贾政','亲子','亲生','第2回，冷子兴演说。但有争议，http://www.360doc.com/content/16/0131/09/29803221_531819830.shtml'),
  ('贾母','贾敏','亲子','亲生','第2回，冷子兴演说'),
  ('贾母','贾赦','亲子','亲生','第2回，冷子兴演说。但有各种讨论，https://www.zhihu.com/question/20515515'),
  ('贾源','贾代善','亲子','亲生','第2回，冷子兴演说'),
  ('贾演','贾代化','亲子','亲生','第2回，冷子兴演说'),
  ('贾珍','尤氏','夫妻','续弦',''),
  ('贾珍','贾蓉','亲子','亲生',''),
  ('贾珍','贾蔷','亲子','收养',''),
  ('贾珠','李纨','夫妻','正房',''),
  ('贾珠','贾兰','亲子','亲生',''),
  ('贾琏','尤二姐','夫妻','偏房',''),
  ('贾琏','王熙凤','夫妻','正房',''),
  ('贾琏','贾巧姐','亲子','亲生',''),
  ('贾瑞之父','贾瑞','亲子','亲生',''),
  ('贾蓉','秦可卿','夫妻','正房',''),
  ('贾赦','贾琏','亲子','亲生','第2回，冷子兴演说'),
  ('贾赦','贾琮','亲子','亲生','很牵强'),
  ('贾赦','贾迎春','亲子','亲生',''),
  ('贾赦','邢夫人','夫妻','续弦','https://tieba.baidu.com/p/2095378959?red_tag=1698272823'),
  ('赵姨娘','贾探春','亲子','亲生',''),
  ('赵姨娘','贾环','亲子','亲生','');
  /*!40000 ALTER TABLE `kinship` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `kinship_type`
  --
  
  DROP TABLE IF EXISTS `kinship_type`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kinship_type` (
    `type` enum('父母子女','夫妻','祖孙') NOT NULL COMMENT '主类型',
    `sub_type` enum('','虚拟','亲生','收养','过继','正房','偏房') NOT NULL COMMENT '子类型',
    `male_subject` varchar(255) NOT NULL COMMENT '男主称呼',
    `female_subject` varchar(255) NOT NULL COMMENT '女主称呼',
    `male_object` varchar(255) NOT NULL COMMENT '男宾称呼',
    `female_object` varchar(255) NOT NULL COMMENT '女宾称呼',
    PRIMARY KEY (`type`,`sub_type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `kinship_type`
  --
  -- ORDER BY:  `type`,`sub_type`
  
  LOCK TABLES `kinship_type` WRITE;
  /*!40000 ALTER TABLE `kinship_type` DISABLE KEYS */;
  INSERT INTO `kinship_type` VALUES
  ('父母子女','亲生','父亲','母亲','儿子','女儿'),
  ('父母子女','收养','养父','养母','养子','养女'),
  ('父母子女','过继','父亲','母亲','儿子','女儿'),
  ('夫妻','正房','丈夫','','','大太太'),
  ('夫妻','偏房','丈夫','','','姨太太'),
  ('祖孙','','爷爷','奶奶','孙子','孙女');
  /*!40000 ALTER TABLE `kinship_type` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `nick`
  --
  
  DROP TABLE IF EXISTS `nick`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `nick` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `nick` varchar(255) NOT NULL COMMENT '诨名',
    `note` mediumtext NOT NULL COMMENT '注解',
    PRIMARY KEY (`name`,`nick`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `nick`
  --
  -- ORDER BY:  `name`,`nick`
  
  LOCK TABLES `nick` WRITE;
  /*!40000 ALTER TABLE `nick` DISABLE KEYS */;
  INSERT INTO `nick` VALUES
  ('史湘云','史大姑娘',''),
  ('史湘云','枕霞旧友',''),
  ('李纨','稻香老农','第37回，结诗社时取别号'),
  ('来旺','旺儿',''),
  ('林黛玉','潇湘妃子','第37回，诗社里新取的笔名'),
  ('林黛玉','病西施','第65回，兴儿对二尤介绍黛玉'),
  ('林黛玉','颦颦','第3回，宝玉初见取表字颦颦'),
  ('王熙凤','凤辣子','第3回，黛玉进贾府，贾母介绍王熙凤'),
  ('茗烟','焙茗',''),
  ('贾兰','兰哥',''),
  ('贾宝玉','怡红公子','第37回，诗社里新取的笔名'),
  ('贾宝玉','槛内人','第63回，给妙玉回帖中署名'),
  ('贾宝玉','绛洞花王','第37回，诗社里李纨提到的旧号'),
  ('贾探春','玫瑰花','第65回，兴儿向尤二姐提起姑娘们的诨名'),
  ('贾探春','蕉下客','第37回，诗社里新取的笔名'),
  ('贾迎春','二木头','第65回，兴儿向尤二姐提起小姐们的诨名');
  /*!40000 ALTER TABLE `nick` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `person`
  --
  
  DROP TABLE IF EXISTS `person`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `person` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `deduction` tinyint(1) NOT NULL COMMENT '是否是推导出的人物',
    `type` enum('主子','仆人','皇族') DEFAULT NULL,
    `level` tinyint(1) NOT NULL COMMENT '级别。如果是主子就表明第几代；如果是仆人就是第几等',
    `gender` enum('男','女') NOT NULL COMMENT '性别',
    `sort_age` double NOT NULL COMMENT '年龄排序值',
    `sort_position` double NOT NULL COMMENT '地位排序值',
    `dead` tinyint(1) NOT NULL COMMENT '至红楼14年时是否已经死亡',
    `family` varchar(255) NOT NULL COMMENT '现所属家族',
    `branch` varchar(255) NOT NULL COMMENT '现所属家族分支',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `person`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `person` WRITE;
  /*!40000 ALTER TABLE `person` DISABLE KEYS */;
  INSERT INTO `person` VALUES
  ('丰儿',0,'仆人',2,'女',14,258,0,'贾家','正'),
  ('伴鹤',0,'仆人',0,'男',14,280,0,'贾家','正'),
  ('佳蕙',0,'仆人',2,'女',14,258,0,'贾家','正'),
  ('入画',0,'仆人',2,'女',0,200,0,'贾家','正'),
  ('兴儿',0,'仆人',0,'男',0,230,0,'贾家','正'),
  ('卍儿',0,'仆人',1,'女',0,210,0,'贾家','正'),
  ('双寿',0,'仆人',0,'男',14,280,0,'贾家','正'),
  ('双瑞',0,'仆人',0,'男',14,280,0,'贾家','正'),
  ('史候',0,'主子',1,'男',85.2,866,1,'史家','正'),
  ('史湘云',0,'主子',4,'女',0,555,0,'史家','正'),
  ('史湘云之父',0,'主子',3,'男',48.2,800,1,'史家','正'),
  ('史湘云之祖父',0,'主子',2,'男',68.2,866,1,'史家','正'),
  ('史鼎',0,'主子',3,'男',48,798,0,'史家','正'),
  ('史鼐',0,'主子',3,'男',48.1,799,0,'史家','正'),
  ('司棋',0,'仆人',1,'女',16,250,0,'贾家','正'),
  ('同喜',0,'仆人',3,'女',15,200,0,'薛家','正'),
  ('同贵',0,'仆人',3,'女',15,199,0,'薛家','正'),
  ('周姨娘',0,'主子',3,'女',30,200,0,'贾家','正'),
  ('善姐',0,'仆人',1,'女',16,230,0,'贾家','正'),
  ('喜儿',0,'仆人',0,'男',0,200,0,'贾家','正'),
  ('四儿',0,'仆人',2,'女',14,259,0,'贾家','正'),
  ('坠儿',0,'仆人',2,'女',14,260,0,'贾家','正'),
  ('墨雨',0,'仆人',0,'男',14,299,0,'贾家','正'),
  ('媚人',0,'仆人',1,'女',16,330,0,'贾家','正'),
  ('宝官',0,'仆人',0,'女',16,220,0,'贾家','正'),
  ('宝珠',0,'仆人',1,'女',16,260,0,'贾家','正'),
  ('寿儿',0,'仆人',0,'男',0,200,0,'贾家','正'),
  ('小吉祥',0,'仆人',2,'女',0,201,0,'贾家','正'),
  ('小红',0,'仆人',2,'女',15,230,0,'贾家','正'),
  ('小鹊',0,'仆人',2,'女',0,200,0,'贾家','正'),
  ('尤二姐',0,'主子',4,'女',23,450,0,'贾家','正'),
  ('尤氏',0,'主子',4,'女',40,700,0,'贾家','正'),
  ('平儿',0,'仆人',1,'女',17,333,0,'贾家','正'),
  ('庆儿',0,'仆人',0,'男',0,228,0,'贾家','正'),
  ('引泉',0,'仆人',0,'男',14,280,0,'贾家','正'),
  ('张若锦',0,'仆人',0,'男',19,199,0,'贾家','正'),
  ('彩云',0,'仆人',1,'女',0,275,0,'贾家','正'),
  ('彩屏',0,'仆人',2,'女',0,199,0,'贾家','正'),
  ('彩霞',0,'仆人',1,'女',0,274,0,'贾家','正'),
  ('彩鸾',0,'仆人',2,'女',0,200,0,'贾家','正'),
  ('待书',0,'仆人',1,'女',16,250,0,'贾家','正'),
  ('扫红',0,'仆人',0,'男',14,299,0,'贾家','正'),
  ('扫花',0,'仆人',0,'男',14,280,0,'贾家','正'),
  ('挑云',0,'仆人',0,'男',14,280,0,'贾家','正'),
  ('文官',0,'仆人',0,'女',0,280,0,'贾家','正'),
  ('文杏',0,'仆人',3,'女',15,199,0,'薛家','正'),
  ('春燕',0,'仆人',2,'女',16,300,0,'贾家','正'),
  ('春纤',0,'仆人',2,'女',16,200,0,'贾家','正'),
  ('昭儿',0,'仆人',0,'男',0,229,0,'贾家','正'),
  ('晴雯',0,'仆人',1,'女',16,329,0,'贾家','正'),
  ('李纨',0,'主子',4,'女',27,670,0,'贾家','正'),
  ('来旺',0,'仆人',0,'男',0,230,0,'贾家','正'),
  ('林如海',0,'主子',3,'男',48,777,0,'贾家','正'),
  ('林黛玉',0,'主子',4,'女',13.5,555,0,'贾家','正'),
  ('根',1,'主子',0,'男',100,999,1,'',''),
  ('檀云',0,'仆人',1,'女',16,319,0,'贾家','正'),
  ('炒豆',0,'仆人',2,'女',0,200,0,'贾家','正'),
  ('玉官',0,'仆人',0,'女',16,220,0,'贾家','正'),
  ('玉钏',0,'仆人',1,'女',0,278,0,'贾家','正'),
  ('王仁',0,'主子',4,'男',27,600,0,'王家','正'),
  ('王信',0,'仆人',0,'男',0,227,0,'贾家','正'),
  ('王公',1,'主子',1,'男',85.1,866,1,'王家','正'),
  ('王夫人',0,'主子',3,'女',48,775,0,'贾家','正'),
  ('王夫人之父',1,'主子',2,'男',68.1,865,0,'王家','正'),
  ('王子腾',0,'主子',3,'男',49,868,0,'王家','正'),
  ('王熙凤',0,'主子',4,'女',26,710,0,'贾家','正'),
  ('王熙凤之父',1,'主子',3,'男',50,869,0,'王家','正'),
  ('王荣',0,'仆人',0,'男',19,200,0,'贾家','正'),
  ('玻璃',0,'仆人',1,'女',18,340,0,'贾家','正'),
  ('珍珠',0,'仆人',1,'女',18,340,0,'贾家','正'),
  ('琥珀',0,'仆人',1,'女',19,350,0,'贾家','正'),
  ('瑞珠',0,'仆人',1,'女',16,250,1,'贾家','正'),
  ('碧月',0,'仆人',1,'女',16,219,0,'贾家','正'),
  ('碧痕',0,'仆人',1,'女',16,320,0,'贾家','正'),
  ('秋纹',0,'仆人',1,'女',16,320,0,'贾家','正'),
  ('秦可卿',0,'主子',5,'女',23,333,1,'贾家','正'),
  ('素云',0,'仆人',1,'女',16,220,0,'贾家','正'),
  ('紫鹃',0,'仆人',2,'女',16,230,0,'贾家','正'),
  ('绣凤',0,'仆人',1,'女',0,276,0,'贾家','正'),
  ('绣桔',0,'仆人',1,'女',16,215,0,'贾家','正'),
  ('绣鸾',0,'仆人',1,'女',0,277,0,'贾家','正'),
  ('绮霰',0,'仆人',1,'女',16,328,0,'贾家','正'),
  ('缕儿',0,'仆人',2,'女',0,260,0,'贾家','正'),
  ('翠墨',0,'仆人',1,'女',15,230,0,'贾家','正'),
  ('翠缕',0,'仆人',2,'女',0,260,0,'贾家','正'),
  ('翡翠',0,'仆人',1,'女',18,340,0,'贾家','正'),
  ('艾官',0,'仆人',0,'女',16,210,0,'贾家','正'),
  ('芳官',0,'仆人',0,'女',16,201,0,'贾家','正'),
  ('茄官',0,'仆人',0,'女',16,220,0,'贾家','正'),
  ('茗烟',0,'仆人',0,'男',14,300,0,'贾家','正'),
  ('茜雪',0,'仆人',1,'女',16,318,0,'贾家','正'),
  ('莲花儿',0,'仆人',2,'女',14,210,0,'贾家','正'),
  ('莺儿',0,'仆人',3,'女',15,200,0,'薛家','正'),
  ('菂官',0,'仆人',0,'女',16,220,1,'贾家','正'),
  ('葵官',0,'仆人',0,'女',16,220,0,'贾家','正'),
  ('蕊官',0,'仆人',0,'女',16,220,0,'贾家','正'),
  ('薛公',1,'主子',1,'男',85,888,1,'薛家','正'),
  ('薛姨妈',0,'主子',3,'女',47,555,0,'薛家','正'),
  ('薛宝琴',0,'主子',4,'女',15,555,0,'薛家','正'),
  ('薛宝琴之父',1,'主子',3,'男',48,555,1,'薛家','正'),
  ('薛宝钗',0,'主子',4,'女',16,555,0,'薛家','正'),
  ('薛宝钗之父',1,'主子',3,'男',48,555,1,'薛家','正'),
  ('薛宝钗之祖父',1,'主子',2,'男',68,555,1,'薛家','正'),
  ('薛蝌',0,'主子',4,'男',17,555,0,'薛家','正'),
  ('薛蟠',0,'主子',4,'男',17,555,0,'薛家','正'),
  ('藕官',0,'仆人',0,'女',16,190,0,'贾家','正'),
  ('蝉姐',0,'仆人',2,'女',19,220,0,'贾家','正'),
  ('袭人',0,'仆人',1,'女',16.5,333,0,'贾家','正'),
  ('豆官',0,'仆人',0,'女',16,220,0,'贾家','正'),
  ('贾代儒',0,'主子',2,'男',68,299,0,'贾家','旁'),
  ('贾代儒之父',1,'主子',1,'男',85,300,1,'贾家','旁'),
  ('贾代化',0,'主子',2,'男',70.5,886,1,'贾家','正'),
  ('贾代善',0,'主子',2,'男',68.3,885,1,'贾家','正'),
  ('贾元春',0,'主子',4,'女',25,888,0,'贾家','正'),
  ('贾兰',0,'主子',5,'男',11,333,0,'贾家','正'),
  ('贾宝玉',0,'主子',4,'男',14.5,666,0,'贾家','正'),
  ('贾巧姐',0,'主子',5,'女',2,333,0,'贾家','正'),
  ('贾惜春',0,'主子',4,'女',12,400,0,'贾家','正'),
  ('贾探春',0,'主子',4,'女',13.5,555,0,'贾家','正'),
  ('贾政',0,'主子',3,'男',48,800,0,'贾家','正'),
  ('贾敏',0,'主子',3,'女',47,700,1,'贾家','正'),
  ('贾敬',0,'主子',3,'男',54.5,880,0,'贾家','正'),
  ('贾敷',0,'主子',3,'男',55,880,1,'贾家','正'),
  ('贾母',0,'主子',2,'女',68.3,880,0,'贾家','正'),
  ('贾源',0,'主子',1,'男',85.3,888,1,'贾家','正'),
  ('贾演',0,'主子',1,'男',85.5,887,1,'贾家','正'),
  ('贾王扁',0,'主子',4,'男',0,160,0,'贾家','正'),
  ('贾环',0,'主子',4,'男',13.5,444,0,'贾家','正'),
  ('贾珍',0,'主子',4,'男',39,680,0,'贾家','正'),
  ('贾珖',0,'主子',4,'男',0,158,0,'贾家','正'),
  ('贾珠',0,'主子',4,'男',28,670,1,'贾家','正'),
  ('贾珩',0,'主子',4,'男',0,159,0,'贾家','正'),
  ('贾琏',0,'主子',4,'男',29,666,0,'贾家','正'),
  ('贾琛',0,'主子',4,'男',0,158,0,'贾家','正'),
  ('贾琮',0,'主子',4,'男',13,333,0,'贾家','正'),
  ('贾琼',0,'主子',4,'男',0,150,0,'贾家','正'),
  ('贾瑞',0,'主子',4,'男',28,297,1,'贾家','旁'),
  ('贾瑞之父',1,'主子',3,'男',48,298,1,'贾家','旁'),
  ('贾璘',0,'主子',4,'男',0,157,0,'贾家','正'),
  ('贾芝',0,'主子',5,'男',0,121,0,'贾家','正'),
  ('贾芬',0,'主子',5,'男',0,124,0,'贾家','正'),
  ('贾芳',0,'主子',5,'男',0,123,0,'贾家','正'),
  ('贾菌',0,'主子',5,'男',0,122,0,'贾家','正'),
  ('贾菖',0,'主子',5,'男',0,130,0,'贾家','正'),
  ('贾菱',0,'主子',5,'男',0,129,0,'贾家','正'),
  ('贾萍',0,'主子',5,'男',0,127,0,'贾家','正'),
  ('贾蓁',0,'主子',5,'男',0,128,0,'贾家','正'),
  ('贾蓉',0,'主子',5,'男',25,444,0,'贾家','正'),
  ('贾蔷',0,'主子',5,'男',19,333,0,'贾家','正'),
  ('贾藻',0,'主子',5,'男',0,126,0,'贾家','正'),
  ('贾蘅',0,'主子',5,'男',0,125,0,'贾家','正'),
  ('贾赦',0,'主子',3,'男',49,780,0,'贾家','正'),
  ('贾迎春',0,'主子',4,'女',15,500,0,'贾家','正'),
  ('赵亦华',0,'仆人',0,'男',19,198,0,'贾家','正'),
  ('赵姨娘',0,'主子',3,'女',30,333,0,'贾家','正'),
  ('邢夫人',0,'主子',3,'女',33,777,0,'贾家','正'),
  ('邢岫烟',0,'主子',4,'女',15,555,0,'薛家','正'),
  ('金钏',0,'仆人',1,'女',0,280,0,'贾家','正'),
  ('钱启',0,'仆人',0,'男',19,197,0,'贾家','正'),
  ('钱槐',0,'仆人',0,'男',16,200,0,'贾家','正'),
  ('银蝶',0,'仆人',2,'女',0,200,0,'贾家','正'),
  ('锄药',0,'仆人',0,'男',14,299,0,'贾家','正'),
  ('隆儿',0,'仆人',0,'男',0,230,0,'贾家','正'),
  ('雪雁',0,'仆人',2,'女',16,220,0,'贾家','正'),
  ('靛儿',0,'仆人',2,'女',15,340,0,'贾家','正'),
  ('鸳鸯',0,'仆人',1,'女',19,400,0,'贾家','正'),
  ('鹦鹉',0,'仆人',1,'女',18,340,0,'贾家','正'),
  ('麝月',0,'仆人',1,'女',16,325,0,'贾家','正'),
  ('龄官',0,'仆人',0,'女',16,220,0,'贾家','正');
  /*!40000 ALTER TABLE `person` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `person_action`
  --
  
  DROP TABLE IF EXISTS `person_action`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `person_action` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `chap` int(10) unsigned NOT NULL COMMENT '首次活动回目，本人活动出场回目',
    `note` mediumtext NOT NULL COMMENT '首次活动注解',
    `refer_chap` int(10) unsigned NOT NULL COMMENT '首次提及回目：本人未出场，但先被别人提到了',
    `refer_note` mediumtext NOT NULL COMMENT '首次提及注解',
    `name_chap` int(10) unsigned NOT NULL COMMENT '首次称呼回目：人物的名字出现位置可能和首次出场不同，也可能和首次提及回目不同',
    `name_note` mediumtext NOT NULL COMMENT '首次称呼注解',
    `die_chap` int(10) unsigned NOT NULL COMMENT '死亡回目',
    `die_note` mediumtext NOT NULL COMMENT '死亡注解',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `person_action`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `person_action` WRITE;
  /*!40000 ALTER TABLE `person_action` DISABLE KEYS */;
  INSERT INTO `person_action` VALUES
  ('丰儿',25,'凤姐被马道婆施法变疯，丰儿哭的泪天泪地',7,'周瑞家的送宫花给凤姐，丰儿在凤姐房门后坐着',7,'',0,''),
  ('伴鹤',0,'',24,'贾芸来见宝玉，看到引泉，扫花，挑云，伴鹤在房檐上掏小雀',24,'',0,''),
  ('佳蕙',25,'佳蕙向小红展示自己得到的赏钱',25,'',25,'',0,''),
  ('入画',0,'',7,'惜春让入画收了周瑞家的送的宫花',7,'',0,''),
  ('兴儿',0,'',53,'贾珍收礼，丫头传话里提到了兴儿',53,'',0,''),
  ('卍儿',19,'茗烟跟卍儿干那警幻所训之事',19,'',19,'',0,''),
  ('双寿',0,'',28,'宝玉去见冯紫英，带了双瑞、双寿',28,'',0,''),
  ('双瑞',0,'',28,'宝玉去见冯紫英，带了双瑞、双寿',28,'',0,''),
  ('史湘云',20,'史湘云回应黛玉对其咬舌子口音的嘲笑',20,'宝玉正和宝钗顽笑，忽见人说：“史大姑娘来了。”',20,'',0,''),
  ('司棋',7,'周瑞家的送宫花给迎春，司棋正从屋内出来',7,'',7,'',0,''),
  ('同喜',29,'贾府打平安醮，同喜、同贵陪同薛姨妈',29,'',29,'',0,''),
  ('同贵',29,'贾府打平安醮，同喜、同贵陪同薛姨妈',29,'',29,'',0,''),
  ('周姨娘',25,'赵姨娘找马道婆害宝玉后，周姨娘来看望宝玉',25,'',25,'',0,''),
  ('善姐',68,'善姐不服从尤二姐使唤',68,'',68,'',0,''),
  ('喜儿',64,'喜儿和寿儿吃酒',64,'',64,'',0,''),
  ('四儿',21,'宝玉看到两个送茶的小丫头，其中一个是蕙香，但宝玉给改名四儿',21,'',21,'',0,''),
  ('坠儿',26,'坠儿带贾芸去见宝玉',26,'',26,'',0,''),
  ('墨雨',9,'茗烟跟随宝玉入学，打了金荣，锄药、扫红、墨雨也一起打',9,'',9,'',0,''),
  ('媚人',0,'',5,'宝玉睡在秦可卿处，媚人留下照顾',5,'',0,''),
  ('宝官',0,'',30,'宝玉看完龄官画蔷后看到了宝官和玉官',30,'',0,''),
  ('宝珠',13,'宝珠做秦可卿义女',13,'',13,'',0,''),
  ('寿儿',64,'喜儿和寿儿吃酒',64,'',64,'',0,''),
  ('小吉祥',0,'',57,'雪雁说赵姨娘带小吉祥儿去送殡',57,'',0,''),
  ('小红',24,'贾芸给凤姐送冰片后找宝玉，小红帮忙传信。',23,'宝玉住怡红院，新添4个丫头负责打扫，儿小红应该就在其中，http://www.todayonhistory.com/people/201610/18748.html',24,'宝玉喊人倒水，小红进屋帮忙倒水',0,''),
  ('小鹊',0,'',73,'小鹊来找宝玉传个信儿',73,'',0,''),
  ('尤二姐',63,'尤氏找家里姐妹来贾府',63,'',63,'',0,''),
  ('尤氏',5,'尤氏在宁府治酒请大家赏梅花，才有了宝玉游幻境',5,'',5,'',0,''),
  ('平儿',7,'周瑞家的送宫花，平儿替凤姐收着',6,'贾蓉找凤姐借玻璃炕屏，凤姐命平儿拿钥匙',68,'',0,''),
  ('庆儿',0,'',68,'凤姐差庆儿打听事',68,'',0,''),
  ('引泉',0,'',24,'贾芸来见宝玉，看到引泉，扫花，挑云，伴鹤在房檐上掏小雀',24,'',0,''),
  ('张若锦',52,'宝玉送殡，几个仆人跟随',52,'',52,'',0,''),
  ('彩云',23,'宝玉见贾政，彩云等笑宝玉',23,'',23,'',0,''),
  ('彩屏',0,'',29,'荣府女眷打醮，彩屏也一起',7,'',0,''),
  ('彩霞',23,'宝玉见贾政，彩霞等笑宝玉',23,'',23,'',0,''),
  ('彩鸾',62,'宝玉生日，彩鸾来拜寿',62,'',62,'',0,''),
  ('待书',7,'周瑞家的送宫花给迎春，司棋正从屋内出来',7,'',7,'',0,''),
  ('扫红',9,'茗烟跟随宝玉入学，打了金荣，锄药、扫红、墨雨也一起打',9,'',9,'',0,''),
  ('扫花',0,'',24,'贾芸来见宝玉，看到引泉，扫花，挑云，伴鹤在房檐上掏小雀',24,'',0,''),
  ('挑云',0,'',24,'贾芸来见宝玉，看到引泉，扫花，挑云，伴鹤在房檐上掏小雀',24,'',0,''),
  ('文官',54,'贾母做寿，文官带领十二官表演',27,'只是顺手提到了',27,'',0,''),
  ('文杏',29,'贾府打平安醮，莺儿、文杏陪同宝钗',29,'',29,'',0,''),
  ('春燕',59,'何婆的小女春燕问藕官烧什么纸',59,'',59,'',0,''),
  ('春纤',0,'',29,'荣府女眷打醮，春纤在列',29,'',0,''),
  ('昭儿',14,'林如海死后，昭儿跟随贾琏去苏州，回来后被凤姐问话',14,'',14,'',0,''),
  ('晴雯',0,'',5,'宝玉睡在秦可卿处，晴雯留下照顾',5,'',0,''),
  ('李纨',3,'黛玉进贾府，贾珠之妻李氏捧饭',3,'',4,'黛玉到李纨房中时才详细介绍李纨姓名',0,''),
  ('来旺',0,'',15,'凤姐包揽诉讼，来往是负责跑腿的心腹',15,'',0,''),
  ('林如海',2,'冷子兴演说荣国府提到',3,'贾雨村向林如海谋官',2,'',0,''),
  ('林黛玉',3,'黛玉进入荣国府',2,'陈述贾雨村做林府西宾',2,'陈述贾雨村做林府西宾',0,''),
  ('檀云',0,'',24,'宝玉要吃茶，但丫头都不在，提到了檀云',24,'',0,''),
  ('炒豆',75,'银蝶和炒豆随尤氏看望李纨',75,'',75,'',0,''),
  ('玉官',0,'',30,'宝玉看完龄官画蔷后看到了宝官和玉官',30,'',0,''),
  ('玉钏',35,'玉钏为宝玉尝荷叶汤',25,'贾环在王夫人面前抄金刚经，让玉钏剪蜡花',25,'',0,''),
  ('王信',68,'凤姐让王信在察院虚张声势',68,'',68,'',0,''),
  ('王夫人',2,'冷子兴演说贾府提到政老爹的夫人王氏',3,'黛玉进贾府时王夫人与王熙凤对话',2,'',0,''),
  ('王熙凤',2,'冷子兴演说荣国府提到贾琏娶了王氏内侄女',3,'黛玉进贾府，王熙凤来迎接',3,'',0,''),
  ('王荣',52,'宝玉送殡，几个仆人跟随',52,'',52,'',0,''),
  ('玻璃',59,'丫鬟为贾母打点物品，玻璃也在其内',59,'',59,'',0,''),
  ('珍珠',0,'',29,'荣府女眷外出打醮，提到了珍珠。但这个珍珠有疑点：https://baike.baidu.com/item/%E7%8F%8D%E7%8F%A0/6123468',59,'',0,''),
  ('琥珀',38,'吃螃蟹，琥珀跟平儿闹',29,'荣府女眷外出打醮，提到了琥珀',29,'',0,''),
  ('瑞珠',13,'瑞珠在秦可卿死后触柱而亡',13,'',13,'',13,''),
  ('碧月',29,'荣府女眷打醮，碧月在列',29,'',29,'',0,''),
  ('碧痕',20,'晴雯、绮霰、碧痕等无事耍戏',20,'',20,'',0,''),
  ('秋纹',19,'秋纹跟宝玉解释晴雯躺床上的原因是被李嬷嬷气的',19,'',19,'',0,''),
  ('秦可卿',5,'宝玉在宁国府倦怠，由贾蓉之妻侵氏安排休息。',5,'',5,'宝玉梦中惊醒喊“可卿救我”',13,''),
  ('素云',29,'荣府女眷打醮，素云在列',29,'',29,'',0,''),
  ('紫鹃',3,'宝玉来看黛玉，紫鹃与宝玉对话',3,'贾母将二等丫头紫鹃给了黛玉',3,'',0,''),
  ('绣凤',23,'宝玉见贾政，绣凤等笑宝玉',23,'',23,'',0,''),
  ('绣桔',29,'荣府女眷打醮，绣桔在列',29,'',29,'',0,''),
  ('绣鸾',23,'宝玉见贾政，绣鸾等笑宝玉',23,'',23,'',0,''),
  ('绮霰',20,'晴雯、绮霰等无事耍戏',20,'',20,'',0,''),
  ('缕儿',0,'',32,'史湘云让袭人问缕儿',32,'',0,''),
  ('翠墨',29,'荣府女眷打醮，翠墨在列',29,'',29,'',0,''),
  ('翠缕',31,'史湘云跟翠缕讨论阴阳',31,'',31,'',0,''),
  ('翡翠',59,'丫鬟为贾母打点物品，翡翠也在其内',59,'',59,'',0,''),
  ('艾官',58,'',58,'艾官归了探春',58,'',0,''),
  ('芳官',58,'芳官归了宝玉，发生了洗头事件',58,'',58,'',0,''),
  ('茄官',58,'',58,'茄官归了尤氏',58,'',0,''),
  ('茗烟',9,'茗烟跟随宝玉入学，打了金荣',9,'',9,'',0,''),
  ('茜雪',8,'风露茶事件，茜雪是主要人物',8,'宝',8,'',0,''),
  ('莲花儿',61,'莲花儿找柳家的要炖鸡蛋',61,'',61,'',0,''),
  ('莺儿',8,'金玉姻缘的诗文首次通过莺儿之口读了出来',8,'',8,'',0,''),
  ('菂官',58,'',58,'芳官向宝玉解释藕官烧纸是为了死去的菂官',58,'',0,''),
  ('葵官',58,'',58,'葵官归了湘云',0,'',0,''),
  ('蕊官',58,'',58,'蕊官归了宝钗',58,'',0,''),
  ('薛姨妈',4,'薛蟠跟薛姨妈商量进京',0,'',0,'',0,''),
  ('薛宝琴',49,'薛宝琴入驻荣府',49,'宝钗猜薛蝌和他妹妹来了',49,'',0,''),
  ('薛宝钗',4,'宝钗入住贾府，与黛玉众姐妹相处',4,'葫芦案一章介绍薛家提到了薛蟠的妹妹宝钗',4,'',0,''),
  ('薛蝌',49,'薛蝌入住荣府',49,'宝钗猜薛蝌来了',49,'',0,''),
  ('薛蟠',4,'薛蟠跟薛姨妈商量进京',4,'门子跟贾雨村讲薛蟠跟冯渊的案子',4,'',0,''),
  ('藕官',58,'藕官烧纸事件',58,'藕官归了黛玉',58,'',0,''),
  ('蝉姐',60,'翠墨命蝉姐买糕',60,'',60,'',0,''),
  ('袭人',3,'黛玉进入荣国府，袭人劝慰黛玉',3,'',3,'',0,''),
  ('豆官',58,'',58,'小花面豆官送了宝琴',58,'',0,''),
  ('贾代儒',9,'宝玉秦钟入私塾，代儒留了作业',8,'提到贾家私塾的老师是代儒',8,'',0,''),
  ('贾代化',0,'0',2,'冷子兴演说荣国府时提到',2,'',0,''),
  ('贾代善',0,'0',2,'冷子兴演说荣国府时提到',2,'',0,''),
  ('贾元春',18,'元春归省荣国府',2,'冷子兴演说荣国府时提到贾珠是王夫人第二胎',0,'',0,''),
  ('贾兰',9,'家塾出乱子，贾兰贾菌也被波及。',4,'介绍李纨时，说贾珠有一子，取名贾兰。',4,'',0,''),
  ('贾宝玉',3,'黛玉进入荣国府初见宝玉',2,'冷子兴演说荣国府时提到',2,'冷子兴演说荣国府时提到',0,''),
  ('贾巧姐',0,'巧姐一直没有主动活动，都是描述别人时带着她',6,'刘姥姥一进荣国府，来到贾琏的女儿大姐的睡觉之所。',2,'',0,''),
  ('贾惜春',10,'璜大奶奶和金氏见了尤氏，正好贾珍也进屋',2,'冷子兴说道四小姐惜春是珍爷胞妹',2,'',0,''),
  ('贾探春',18,'元春归省荣国府',2,'冷子兴演说荣国府时提到贾珠是王夫人第二胎',0,'',0,''),
  ('贾政',9,'宝玉进学堂前，贾政训话',2,'冷子兴演说荣国府时提到代善次子是贾政',2,'',0,''),
  ('贾敏',0,'',2,'冷子兴说道贾敏',2,'',0,''),
  ('贾敬',11,'贾敬生日，贾蓉跟贾敬有些交流',2,'冷子兴演说荣国府时提到贾代化次子贾敬袭了官，但一味好道',2,'',63,'忽见东府中几个人慌慌张张跑来说：老爷宾天了。'),
  ('贾敷',0,'',2,'冷子兴演说荣国府时提到贾代化长子贾敷七八岁就死了',2,'',0,''),
  ('贾母',3,'黛玉进荣国府见贾母',2,'冷子兴演说荣国府时提到贾代善娶了史侯家的小姐为妻',0,'',0,''),
  ('贾源',0,'0',2,'冷子兴演说荣国府时提到',2,'',0,''),
  ('贾演',0,'0',2,'冷子兴演说荣国府时提到',2,'',0,''),
  ('贾王扁',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾环',20,'贾环赌钱耍赖',18,'元妃省亲，贾环染病未痊',18,'',0,''),
  ('贾珍',10,'璜大奶奶和金氏见了尤氏，正好贾珍也进屋。',2,'冷子兴说道贾敬早年留下一子贾珍',2,'',0,''),
  ('贾珖',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾珠',0,'',2,'冷子兴演说荣国府时提到贾珠是王夫人头胎',0,'',0,''),
  ('贾珩',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾琏',4,'薛蟠进荣国府，贾琏引着拜见贾赦',2,'冷子兴说贾琏是贾政长子',2,'',0,''),
  ('贾琛',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾琮',13,'秦可卿丧事贾琮也来了',13,'',13,'',0,''),
  ('贾琼',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾瑞',9,'代儒暂离私塾后，贾瑞代为管理',9,'',9,'',12,'迷恋风月宝鉴精尽人亡'),
  ('贾璘',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾芝',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾芬',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾芳',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾菌',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾菖',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾菱',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾萍',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾蓁',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾蓉',6,'姥姥一进荣国府时，贾蓉找凤姐要玻璃炕屏。',2,'冷子兴说贾琏是贾政长子',2,'',0,''),
  ('贾蔷',9,'家塾里贾蔷挑唆茗烟跟金荣斗气',9,'',9,'',0,''),
  ('贾藻',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾蘅',0,'',13,'参加秦可卿丧礼',13,'',0,''),
  ('贾赦',11,'贾敬生日，贾蓉跟贾敬有些交流',2,'冷子兴演说荣国府时提到贾代化次子贾敬袭了官，但一味好道',2,'',0,''),
  ('贾迎春',2,'冷子兴演说荣国府提到二小姐乃赦老爹所出，名迎春',3,'黛玉进贾府，迎春姊妹三个迎接',3,'',0,''),
  ('赵亦华',52,'宝玉送殡，几个仆人跟随',52,'',52,'',0,''),
  ('赵姨娘',20,'王熙凤正言弹妒意这回，赵姨娘骂贾环',20,'',20,'',0,''),
  ('邢夫人',3,'黛玉进贾府，邢夫人领着黛玉',3,'',3,'',0,''),
  ('邢岫烟',49,'邢岫烟入住贾府后穿旧衣服',49,'邢岫烟随父母投奔邢夫人',49,'',0,''),
  ('金钏',7,'周瑞家的送宫花过程中跟金钏讨论香菱',7,'周瑞家的送宫花，路上看见了金钏和香菱在玩',7,'',0,''),
  ('钱启',52,'宝玉送殡，几个仆人跟随',52,'',52,'',0,''),
  ('钱槐',60,'钱槐对五儿有意',60,'',60,'',0,''),
  ('银蝶',75,'银蝶和炒豆随尤氏看望李纨',75,'',75,'',0,''),
  ('锄药',9,'茗烟跟随宝玉入学，打了金荣，锄药、扫红、墨雨也一起打',9,'',9,'',0,''),
  ('隆儿',65,'贾琏找尤二姐，心腹小童隆儿拴马',65,'',65,'',0,''),
  ('雪雁',8,'雪雁奉紫娟之命给黛玉送手炉',3,'黛玉从家中带来的丫头',3,'',0,''),
  ('靛儿',30,'靛儿找扇子，被宝钗借扇机带双敲',30,'',30,'',0,''),
  ('鸳鸯',24,'宝玉要吃鸳鸯嘴上的胭脂',20,'丫鬟们在一起耍戏，提到了鸳鸯',20,'',0,''),
  ('鹦鹉',0,'',59,'荣府女眷外出打醮，提到了鹦鹉。',59,'',0,''),
  ('麝月',20,'所有丫头都在玩，独麝月看家，宝玉赞叹',9,'宝玉早晨上学前嘱咐晴雯麝月几句',9,'',0,''),
  ('龄官',18,'龄官受到了元妃的奖赏',18,'',18,'',0,'');
  /*!40000 ALTER TABLE `person_action` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `person_ext`
  --
  
  DROP TABLE IF EXISTS `person_ext`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `person_ext` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `age` int(10) unsigned NOT NULL COMMENT '大致年龄',
    `age_note` mediumtext NOT NULL COMMENT '大致年龄的注解',
    `family_name` varchar(50) NOT NULL COMMENT '姓',
    `old_name` varchar(255) NOT NULL COMMENT '原名',
    `old_name_note` varchar(255) NOT NULL COMMENT '原名注解',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `person_ext`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `person_ext` WRITE;
  /*!40000 ALTER TABLE `person_ext` DISABLE KEYS */;
  INSERT INTO `person_ext` VALUES
  ('丰儿',14,'比较瞎猜','','',''),
  ('伴鹤',14,'比较瞎猜','','',''),
  ('佳蕙',14,'比较瞎猜','','',''),
  ('双寿',14,'比较瞎猜','','',''),
  ('双瑞',14,'比较瞎猜','','',''),
  ('史候',85,'瞎猜','','',''),
  ('史湘云之父',48,'瞎猜','','',''),
  ('史湘云之祖父',68,'瞎猜','','',''),
  ('史鼎',48,'瞎猜','','',''),
  ('史鼐',48,'瞎猜','','',''),
  ('司棋',16,'比较瞎猜','','',''),
  ('周姨娘',30,'瞎猜','周','',''),
  ('善姐',16,'比较瞎猜','','',''),
  ('四儿',14,'比较瞎猜','','蕙香',''),
  ('坠儿',14,'比较瞎猜','','',''),
  ('墨雨',14,'比较瞎猜','','',''),
  ('媚人',16,'比较瞎猜','','',''),
  ('宝官',16,'比较瞎猜','','',''),
  ('宝珠',16,'比较瞎猜','','',''),
  ('小红',15,'比较瞎猜','林','林红玉',''),
  ('尤二姐',23,'尤二姐比贾蓉小，推导：https://zh.wikipedia.org/wiki/%E7%BA%A2%E6%A5%BC%E6%A2%A6%E5%B9%B4%E8%B0%B1#cite_note-38','尤','',''),
  ('尤氏',40,'第76回，尤氏40，推算：https://zh.wikipedia.org/wiki/%E7%BA%A2%E6%A5%BC%E6%A2%A6%E5%B9%B4%E8%B0%B1#cite_note-38','尤','',''),
  ('平儿',17,'https://zh.wikipedia.org/wiki/%E7%BA%A2%E6%A5%BC%E6%A2%A6%E5%B9%B4%E8%B0%B1#cite_note-84','','',''),
  ('引泉',14,'比较瞎猜','','',''),
  ('张若锦',19,'比较瞎猜','','',''),
  ('待书',16,'比较瞎猜','','',''),
  ('扫红',14,'比较瞎猜','','',''),
  ('扫花',14,'比较瞎猜','','',''),
  ('挑云',14,'比较瞎猜','','',''),
  ('春燕',16,'比较瞎猜','','',''),
  ('春纤',16,'比较瞎猜','','',''),
  ('晴雯',16,'比较瞎猜','','',''),
  ('李纨',27,'李纨年龄比王熙凤大，推导：https://zh.wikipedia.org/wiki/%E7%BA%A2%E6%A5%BC%E6%A2%A6%E5%B9%B4%E8%B0%B1#cite_note-38','李','',''),
  ('林如海',48,'第2回时，林如海40岁，黛玉5岁。','林','',''),
  ('林黛玉',13,'http://blog.sina.com.cn/s/blog_6755590d0102va0e.html','林','',''),
  ('根',100,'','贾','',''),
  ('檀云',16,'比较瞎猜','','',''),
  ('玉官',16,'比较瞎猜','','',''),
  ('王仁',27,'瞎猜','','',''),
  ('王公',85,'瞎猜','','',''),
  ('王夫人',48,'http://blog.sina.com.cn/s/blog_6755590d0102va0e.html','王','',''),
  ('王夫人之父',68,'瞎猜','','',''),
  ('王子腾',49,'瞎猜','','',''),
  ('王熙凤',26,'王熙凤死的时候30岁，倒推：https://zh.wikipedia.org/wiki/%E7%BA%A2%E6%A5%BC%E6%A2%A6%E5%B9%B4%E8%B0%B1#cite_note-38','王','',''),
  ('王熙凤之父',50,'瞎猜','','',''),
  ('王荣',19,'比较瞎猜','','',''),
  ('玻璃',18,'比较瞎猜','','',''),
  ('珍珠',18,'比较瞎猜，http://www.52hlpm.com/wy/tgq/tg077.htm','','',''),
  ('琥珀',19,'http://www.52hlpm.com/wy/tgq/tg077.htm','','',''),
  ('瑞珠',16,'比较瞎猜','','',''),
  ('碧月',16,'比较瞎猜','','',''),
  ('碧痕',16,'比较瞎猜','','',''),
  ('秋纹',16,'比较瞎猜','','',''),
  ('秦可卿',23,'纯猜测，年龄应该比其夫贾蓉小个一两岁','秦','',''),
  ('素云',16,'比较瞎猜','','',''),
  ('紫鹃',16,'比较瞎猜','','鹦哥','https://www.zhihu.com/question/36151524'),
  ('绣桔',16,'比较瞎猜','','',''),
  ('绮霰',16,'比较瞎猜','','',''),
  ('翠墨',15,'比较瞎猜','','',''),
  ('翡翠',18,'比较瞎猜','','',''),
  ('艾官',16,'比较瞎猜','','',''),
  ('芳官',16,'比较瞎猜','','',''),
  ('茄官',16,'比较瞎猜','','',''),
  ('茗烟',14,'比较瞎猜','','',''),
  ('茜雪',16,'比较瞎猜','','',''),
  ('莲花儿',14,'比较瞎猜','','',''),
  ('菂官',16,'比较瞎猜','','',''),
  ('葵官',16,'比较瞎猜','','',''),
  ('蕊官',16,'比较瞎猜','','',''),
  ('薛姨妈',47,'第46回，贾母对薛姨妈说“你这个姐姐”，更多推导见http://blog.sina.com.cn/s/blog_4913fd3d0102xkzu.html','王','',''),
  ('薛宝钗',16,'推导：https://baijiahao.baidu.com/s?id=1568506289620419&wfr=spider&for=pc','','',''),
  ('薛蟠',18,'比较瞎猜，比宝钗大','','',''),
  ('藕官',16,'比较瞎猜','','',''),
  ('蝉姐',19,'比较瞎猜','','',''),
  ('袭人',16,'https://www.douban.com/group/topic/28547104/','花','花珍珠','第23回，贾政问王夫人袭人是谁，宝玉解释道'),
  ('豆官',16,'比较瞎猜','','',''),
  ('贾代化',70,'纯拍脑袋瞎猜','贾','',''),
  ('贾代善',68,'纯拍脑袋瞎猜','贾','',''),
  ('贾元春',25,'元春年龄比较乱，http://ibekolu.blogchina.com/1586561.html','贾','',''),
  ('贾兰',11,'第78回。https://tieba.baidu.com/p/681397160?red_tag=3245362885','贾','',''),
  ('贾宝玉',14,'http://blog.sina.com.cn/s/blog_6755590d0102va0e.html','贾','',''),
  ('贾巧姐',2,'大姐和巧姐归总为巧姐，年龄混乱。','贾','',''),
  ('贾惜春',12,'https://tieba.baidu.com/p/2542784236?red_tag=2408789060','贾','',''),
  ('贾探春',13,'跟黛玉、湘云差不多，难分清楚。讨论也很多。','贾','',''),
  ('贾政',48,'纯粹拍脑袋瞎猜。第33回，贾政打宝玉，王夫人说如今已将五十岁的人。','贾','',''),
  ('贾敏',47,'年龄比贾政小。第2回，林如海40岁时，黛玉5岁。至大观园时，黛玉12、13岁。','贾','',''),
  ('贾敬',54,'纯粹拍脑袋瞎猜','贾','',''),
  ('贾敷',55,'纯粹拍脑袋瞎猜','贾','',''),
  ('贾母',68,'第39回，刘姥姥说自己75岁，贾母说比自己大好几岁','史','',''),
  ('贾源',85,'纯拍脑袋瞎猜','贾','',''),
  ('贾演',85,'纯拍脑袋瞎猜','贾','',''),
  ('贾环',13,'第78回。https://tieba.baidu.com/p/681397160?red_tag=3245362885','贾','',''),
  ('贾珍',39,'第2回，贾雨村说黛玉5岁，冷子兴说贾蓉16岁。那推算下，等黛玉长到14岁时，贾蓉贾蓉25岁，那贾珍可能40了。第76回，其妻尤氏说本四十岁的人了。','贾','',''),
  ('贾珠',28,'第2回，冷子兴说贾珠不到20生贾兰','贾','',''),
  ('贾琏',29,'第2回，冷子兴推演时黛玉5岁，贾琏已经二十来往.至大观园黛玉13岁时，贾琏至少也29岁了。','贾','',''),
  ('贾琮',13,'年龄可能跟贾环差不多。http://www.guoxue123.com/hongxue/0001/hlwy/074.htm','贾','',''),
  ('贾蓉',25,'第2回，冷子兴推演时黛玉5岁，贾蓉16岁。至大观园黛玉13岁时，贾蓉24岁左右。','贾','',''),
  ('贾蔷',19,'第9回，贾蔷16岁，大概比宝玉大个5、6岁','贾','',''),
  ('贾赦',49,'纯粹拍脑袋瞎猜。第11回贾珍称邢夫人、王夫人为婶子，说明贾赦贾政都比贾敬小。','贾','',''),
  ('贾迎春',15,'第73回，迎春称呼宝姐姐林妹妹，大致推算。','贾','',''),
  ('赵亦华',19,'比较瞎猜','','',''),
  ('赵姨娘',30,'https://baike.baidu.com/item/%E8%B5%B5%E5%A7%A8%E5%A8%98','赵','',''),
  ('邢夫人',33,'比较猜测，http://bbs.tianya.cn/post-106-544458-1.shtml','邢','',''),
  ('钱启',19,'比较瞎猜','','',''),
  ('钱槐',16,'比较瞎猜','','',''),
  ('锄药',14,'比较瞎猜','','',''),
  ('雪雁',16,'比较瞎猜','','',''),
  ('靛儿',15,'瞎猜','','',''),
  ('鸳鸯',19,'http://www.52hlpm.com/wy/tgq/tg077.htm','金','第46回，凤姐向邢夫人介绍鸳鸯家庭情况说鸳鸯的爹叫金彩',''),
  ('鹦鹉',18,'比较瞎猜','','',''),
  ('麝月',16,'比较瞎猜','','',''),
  ('龄官',16,'比较瞎猜','','','');
  /*!40000 ALTER TABLE `person_ext` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `serve`
  --
  
  DROP TABLE IF EXISTS `serve`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `serve` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `serve` varchar(255) NOT NULL COMMENT '侍奉对象',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `serve`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `serve` WRITE;
  /*!40000 ALTER TABLE `serve` DISABLE KEYS */;
  INSERT INTO `serve` VALUES
  ('丰儿','王熙凤'),
  ('伴鹤','贾宝玉'),
  ('佳蕙','贾宝玉'),
  ('入画','贾惜春'),
  ('兴儿','贾珍'),
  ('卍儿','尤氏'),
  ('双寿','贾宝玉'),
  ('双瑞','贾宝玉'),
  ('司棋','贾迎春'),
  ('同喜','薛姨妈'),
  ('同贵','薛姨妈'),
  ('善姐','尤二姐'),
  ('喜儿','贾珍'),
  ('四儿','贾宝玉'),
  ('坠儿','贾宝玉'),
  ('墨雨','贾宝玉'),
  ('媚人','贾宝玉'),
  ('宝珠','秦可卿'),
  ('寿儿','贾珍'),
  ('小吉祥','赵姨娘'),
  ('小红','王熙凤'),
  ('小鹊','赵姨娘'),
  ('平儿','王熙凤'),
  ('庆儿','王熙凤'),
  ('引泉','贾宝玉'),
  ('张若锦','贾宝玉'),
  ('彩云','王夫人'),
  ('彩屏','贾惜春'),
  ('彩霞','王夫人'),
  ('彩鸾','王夫人'),
  ('待书','贾探春'),
  ('扫红','贾宝玉'),
  ('扫花','贾宝玉'),
  ('挑云','贾宝玉'),
  ('文官','贾母'),
  ('文杏','薛宝钗'),
  ('春燕','贾宝玉'),
  ('春纤','林黛玉'),
  ('昭儿','贾琏'),
  ('晴雯','贾宝玉'),
  ('来旺','王熙凤'),
  ('檀云','贾宝玉'),
  ('炒豆','尤氏'),
  ('玉钏','王夫人'),
  ('王信','王熙凤'),
  ('王荣','贾宝玉'),
  ('玻璃','贾母'),
  ('珍珠','贾母'),
  ('琥珀','贾母'),
  ('瑞珠','秦可卿'),
  ('碧月','李纨'),
  ('碧痕','贾宝玉'),
  ('秋纹','贾宝玉'),
  ('素云','李纨'),
  ('紫鹃','林黛玉'),
  ('绣凤','王夫人'),
  ('绣桔','贾迎春'),
  ('绣鸾','王夫人'),
  ('绮霰','贾宝玉'),
  ('缕儿','史湘云'),
  ('翠墨','贾探春'),
  ('翠缕','史湘云'),
  ('翡翠','贾母'),
  ('艾官','贾探春'),
  ('芳官','贾宝玉'),
  ('茄官','尤氏'),
  ('茗烟','贾宝玉'),
  ('茜雪','贾宝玉'),
  ('莲花儿','贾迎春'),
  ('莺儿','薛宝钗'),
  ('葵官','史湘云'),
  ('蕊官','薛宝钗'),
  ('藕官','林黛玉'),
  ('蝉姐','贾探春'),
  ('袭人','贾宝玉'),
  ('豆官','薛宝琴'),
  ('赵亦华','贾宝玉'),
  ('金钏','王夫人'),
  ('钱启','贾宝玉'),
  ('钱槐','贾环'),
  ('银蝶','尤氏'),
  ('锄药','贾宝玉'),
  ('隆儿','贾琏'),
  ('雪雁','林黛玉'),
  ('靛儿','贾母'),
  ('鸳鸯','贾母'),
  ('鹦鹉','贾母'),
  ('麝月','贾宝玉');
  /*!40000 ALTER TABLE `serve` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `social_position`
  --
  
  DROP TABLE IF EXISTS `social_position`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `social_position` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `nobility_rank` enum('','公','候','伯','子','男') DEFAULT NULL COMMENT '爵位级别',
    `nobility_title` varchar(255) NOT NULL COMMENT '爵位名称',
    `nobility_note` mediumtext NOT NULL COMMENT '爵位注解',
    `official_rank` int(10) unsigned NOT NULL DEFAULT '999' COMMENT '官位品级',
    `official_title` varchar(255) NOT NULL COMMENT '官位名称',
    `official_note` mediumtext NOT NULL COMMENT '官位注解',
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `social_position`
  --
  -- ORDER BY:  `name`
  
  LOCK TABLES `social_position` WRITE;
  /*!40000 ALTER TABLE `social_position` DISABLE KEYS */;
  INSERT INTO `social_position` VALUES
  ('史候','候','保龄候','',0,'尚书令',''),
  ('史湘云之祖父','候','保龄候','',0,'',''),
  ('史鼎','候','忠靖侯','',0,'',''),
  ('史鼐','候','保龄候','',0,'',''),
  ('林如海','','','',2,'兰台寺大夫','第2回，贾雨村听到的新闻，当时林如海同时还做了巡盐御史'),
  ('王公','','都太尉统制','第4回，护官符侧批',0,'县伯','第4回，护官符侧批'),
  ('王子腾','','','',1,'九省都检点',''),
  ('薛公','','','',0,'紫微舍人','第4回，护官符甲戌侧批'),
  ('贾代化','候','一等神威将军','降级袭爵。第13回，贾蓉的履历给戴权看，看到代化的官爵。',0,'京营节度使','第13回，贾蓉的履历给戴权看，看到代化的官爵。'),
  ('贾代善','公','荣国公','第29回，张道士说宝玉跟荣国公是一个模子里刻出来的，而贾母又说，除了宝玉，没一个人像他爷爷。',0,'',''),
  ('贾元春','','贤德妃','',0,'凤藻宫尚书',''),
  ('贾政','候','','父亲代善是国公，贾政降级袭爵',5,'工部员外郎','第3回，林如海向贾雨村介绍贾政时提到'),
  ('贾敬','伯','','',5,'','第63回，死亡时追赐'),
  ('贾源','公','荣国公','',0,'',''),
  ('贾演','公','宁国公','',0,'',''),
  ('贾珍','子','三品爵威烈将军','降级袭爵。第13回，贾蓉的履历给戴权看，看到贾珍的官爵。',0,'',''),
  ('贾琏','伯','','降级袭爵',5,'同知','第2回，冷子兴演说将贾琏捐了个官'),
  ('贾蓉','男','','降级袭爵',5,'龙禁尉','第13回，贾珍给贾蓉捐了个官，好让秦可卿的葬礼风光些。'),
  ('贾赦','','一等将军','第2回，冷子兴说贾赦袭了贾代善官职',0,'','');
  /*!40000 ALTER TABLE `social_position` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `title`
  --
  
  DROP TABLE IF EXISTS `title`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `title` (
    `name` varchar(255) NOT NULL COMMENT '称呼',
    `title` varchar(255) NOT NULL COMMENT '尊称',
    `note` mediumtext NOT NULL COMMENT '注解',
    PRIMARY KEY (`name`,`title`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `title`
  --
  -- ORDER BY:  `name`,`title`
  
  LOCK TABLES `title` WRITE;
  /*!40000 ALTER TABLE `title` DISABLE KEYS */;
  INSERT INTO `title` VALUES
  ('尤氏','大奶奶',''),
  ('李纨','大奶奶',''),
  ('王熙凤','二奶奶',''),
  ('袭人','花大姑娘',''),
  ('贾宝玉','宝二爷',''),
  ('贾惜春','四小姐','冷子兴演说荣国府提到四小姐名探春'),
  ('贾探春','三小姐','冷子兴推演荣国府说三小姐名探春'),
  ('贾敬','太爷','第11回，贾敬生日，各人口中都称他太爷'),
  ('贾母','史太君',''),
  ('贾母','老太太',''),
  ('贾母','老祖宗',''),
  ('贾珍','大爷','第14回，王熙凤跟宁国府众仆人说辛苦下，事情完了你们家大爷会赏。'),
  ('贾珍','族长','第4回，薛蟠进贾府后被引诱的更坏了，解释说贾珍这族长管理的不成样子。'),
  ('贾琏','琏二爷',''),
  ('贾迎春','二小姐','冷子兴演说荣国府说二小姐名迎春'),
  ('邢夫人','大太太','');
  /*!40000 ALTER TABLE `title` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed
  