物业供水设备类图

1：1

n：1

equipment _evaluate

-id ：bigintaddtime：timestamp-shebeimingcheng：varchar-baoxiudanhao：varchar-baoxiuneirong：varchar-keshiyuangonghao：varchar-keshiyuanxingming：varchar-keshi：varchar-weixiuriqi：varchar-weixiuzhuangtai：varchar-pingjia：varchar-weixiuyuangonghao：varchar

+AddComment（）+AlterComment（）+DelComment（）+CheckComment（）

equipment_scrapping

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-baofeineirong：varchar-baofeiriqi：date-beizhu：varchar

+AddProduct()+AlterProduct()+DelProduct()

equipment _repair

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-baoxiudanhao：varchar-baoxiuneirong：longtext-baoxiuriqi：date-keshiyuangonghao：varchar-keshiyuanxingming：varchar-keshi：varchar-weixiuriqi：date-weixiuzhuangtai：varchar-weixiuyuangonghao：varchar

+AddrRepair（）+DelRepair（）+AlterRepair（）+CheckRepair（）

borrow

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-jieyongren：varchar-jieyongriqi：date-guihuanriqi：date-beizhu：varchar

+AddBorrow()+DelBorrow()+AlterBorrow()+AddReturn()+DelReturm()+AlterReturn()

equipment_check

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-shebeiqingkuang：longtext-xunchariqi：date-keshiyuangonghao：varchar-keshiyuanxingming：varchar-keshi：varchar-weixiuyuangonghao：varchar-weixiuyuanxingming：varchar

+AddCheck()+AlterCheck()+DelCheck（）

equipment

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-guigexinghao：varchar-pinpai：varchar-shengchanriqi：date-shebeixiangqing：varchar

+AddOrder（）+AlterOrder（）+DelOrder（）+CheckOrder（）

warehouse

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-chukushuliang：varchar-chukuriqi：date-rukushuliang：varchar-rukuriqi：date-beizhu：varchar

1：n

1: 1

return

equipment_operation

-id ：bigint-addtime：timestamp-shebeimingcheng：varchar-shenqingneirong：varchar-shenqingriqi：longtext-keshiyuangonghao：varchar-keshiyuanxingming：varchar-keshi：varchar

+AddOperation（）+AlterOperation（）+DelOperation（）+CheckOperation（）