//log
private 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;