[mysql]enum

show create table ti_road_node_relation;

CREATE TABLE `ti_road_node_relation` (
  `en_road_node_id` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '入口节点编号',
  `ex_road_node_id` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '出口节点编号',
  `miles` int(10) NOT NULL COMMENT '里程（米）',
  `seq_no` mediumint(9) NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NOT NULL,
  `remark` varchar(255) COLLATE utf8_bin NOT NULL,
  `type` enum('收费站-收费单元','收费单元-收费单元','收费单元-收费站') COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`seq_no`) USING BTREE
) /*!50100 TABLESPACE `innodb_system` */ 
ENGINE=InnoDB AUTO_INCREMENT=34527 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='相邻节点关系表'

private String type;

转载于:https://my.oschina.net/u/2464371/blog/3071324