guomao/DOC/DB/00_table/ap_enclosure_info.sql

CREATE TABLE AP_ENCLOSURE_INFO(
  AEI_ID   				VARCHAR(20)	 	NOT NULL 		COMMENT '编号',
  AEI_ROUTE   			VARCHAR(200)	  	    		COMMENT '路径',
  AEI_ACCESS_PATH   	VARCHAR(200)	  	    		COMMENT '访问路径',
  AEI_RECORD_ID   		VARCHAR(20)	  	    			COMMENT '记录表编号 AP_RECORD_SHEET:ARC_ID',
  AEI_TYPE   		    VARCHAR(2)	  	    			COMMENT '类型00图片01pdf',
  PRIMARY KEY (AEI_ID)
) ENGINE=INNODB DEFAULT CHARSET=UTF8 COMMENT='附件信息表';