//logprivate static Logger logger = Logger.getLogger(RoleApi.class);private static Gson g = new Gson();//columnDefinition字段定义@Column(name = "F_FileFuncType", columnDefinition = "char(1) default ” comment ‘文件类型：A建筑照片，B配电柜照片，C支路布置图，D部署方案’")private char fileFuncType;@Column(name = "F_FileDesc", nullable = true, columnDefinition = "varchar(80) default NULL comment ‘文件描述’")private String fileDesc;@Column(name = "F_FileSize", columnDefinition = "int default 0 comment ‘文件大小：单位byte’")private int fileSize;@Column(name = "F_FileDate", nullable = true, columnDefinition = "datetime COMMENT ‘上传时间’")private Date fileDate;@Column(name = "F_BuildLong", nullable = true, columnDefinition = "numeric(18,4) DEFAULT 0 COMMENT ‘建筑坐标-经度,建筑任意点的经度读数（默认为东经，单位为度，，如131.2576度）’")private BigDecimal buildLong;@Column(name = "F_IsStandard", nullable = true, columnDefinition = "bit DEFAULT 0 COMMENT’是否是标杆建筑,False–否, default True–是’")private boolean isStandard;//数据库前缀T_*_**：T-Table（数据库表） F-Field（数据表字段）T_DC_**：DC-Data Center（数据中心）T_BD_**：BD-Building（建筑）T_DT_**：DT-Dictionary（字典）T_EC_**：EC-Energy Consumption（能耗）T_ST_**：ST-Setting（设计安装）T_OV_**：OV-Original Value（原始值）p_ 表示与权限相关的表tb_ 表示普通的业务表rel_表示中间表如何截断或者外键关联表//取消外键SET FOREIGN_KEY_CHECKS=0;//执行操作truncate tablename;drop table tablename；//启用外键SET FOREIGN_KEY_CHECKS=1;
人生就是一次充满未知的旅行，在乎的是沿途的风景，
