热力网站数据库表关系
2020-07-17 07:30:19 0 举报数据库框架设计
作者其他创作
大纲/内容
hsn_station
PK：Id
FK:typeFK:areaname
hsn_ticket_type
nameicon
物联监测
hsn_ticket_action_field
FK:actionname
hsn_ticket_state
PK:typenamemode
hsn_ticket_track
statusactionFK:ticket
客服管理
N:1(community)
hsn_model_channel
FK:modelnamecyclechannel
1:N(station)S01
hsn_sms_token
mobilecodeexpires
hsn_ticket_action
FK:typenamesstateestate
1:N(factory)
hsn_menu
nametitleparent
hsn_user
nameaccountpasswordFK:dep
hsn_user_token
FK:uidstatusip
1:1(dep)
hsn_sms
FK:uidmobilecontent
hsn_config
valueremark
1:N(state)
hsn_ticket_track_field
statusfieldvalueFK:track
1:1(action)
1:N(type)
N:1(role)
hsn_hour
timevaluefvaluemaxvalue
hsn_biz_community
FK:areaname
hsn_ticket_feedback
FK:ticketoverallspeedlinkman
1:N(alarm)
hsn_factory
FK:typelinkmanname
用户关系
1:1(ticket)
1:N(source)
hsn_alarm_sensor
FK:alarmFK:sourcesensor
1:N(id)
1:N(code)
hsn_realtime
timevalue
hsn_dict_item
FK:codenamevalue
集抄管理
hsn_biz_building
FK:communityname
1:1(track)
hsn_alarm
nameexpression
N:1(uid)
hsn_day
timevalueovaluefvaluemaxvalue
1:1(oid)
系统配置
hsn_role
namestatus
hsn_area
parentname
1:N(uid)
1:N(unit)
hsn_biz_event
categoryaddresscontactunamereason
hsn_model
typename
hsn_sensor
FK:stationFK:unittagname
hsn_feedback
FK:uidtitlecontent
hsn_ticket
FK:typeFK:statesnassigneeFK:uidFK:oid
hsn_dep 部门
statusnameaddress
1:N
1:1(id)
1:N(area)
1:1(code)
hsn_dict
nameremark
hsn_device
FK:factoryFK:stationFK:typeFK:modelFK:codename
1:N(role)
hsn_unit
hsn_biz_terminal
FK:codeFK:buildingname
hsn_ticket_state_role
FK:stateFK:role
hsn_file
filetypestatus
1:N(station)S02
hsn_role_user
FK:userFK:rolestatus
hsn_perm
typeFK:roletype
N:1(model)
N:1(building)
1:1(model)
1:N(user)
收藏
0 条评论
下一页
