1.创建主表
CREATE TABLE `c_type` (
`id` varchar(32) NOT NULL,
`parent_id` varchar(32) DEFAULT NULL,
`type` varchar(32) DEFAULT NULL,
`display_name` varchar(16) DEFAULT NULL,
`display_order` int(11) DEFAULT NULL,
`comments` varchar(256) DEFAULT NULL,
`state` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.创建从表
CREATE TABLE `zhubiao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(32) DEFAULT NULL,
`reason` varchar(32) DEFAULT NULL,
`reason_desc` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`),
CONSTRAINT `FK_zhubiao_type` FOREIGN KEY (`type`) REFERENCES `c_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83137 DEFAULT CHARSET=utf8;