DOC/3设计阶段/DB/00_table/PUB_ADDRESS_INF.sql

CREATE TABLE PUB_ADDRESS_INF (
  ADD_ID 			INT(11)  				COMMENT 'ID',
  ADD_CODE 			VARCHAR(6)  			COMMENT '编号',
  ADD_NAME 			VARCHAR(20)  			COMMENT '城市名称',
  ADD_CITYCODE 		VARCHAR(6)  			COMMENT '上级编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全国省市县数据表';