ss
Tables (39)
accesslogtype
- logtype — int(11) — Primary key — NOT NULL
- logname — varchar(100) — NOT NULL
adminbusiness
- deviceid — varchar(50) — Primary key — NOT NULL
- sendday — varchar(50)
- location — varchar(50)
- companyname — varchar(50)
- user — varchar(50)
- phone — varchar(30)
- installer — varchar(30)
- classification — varchar(50)
- devicetype — varchar(30)
- regdate — datetime
- remarks — varchar(2000)
admincoupon
- couponid — varchar(50) — Primary key — NOT NULL
- regdate — datetime
- exp — datetime
- couponname — varchar(100)
- discount — int(11)
- coupontypecd — int(11) — NOT NULL
- adminid — varchar(50)
- statuscd — int(11)
admincouponhistory
- couponid — varchar(50) — Primary key — NOT NULL
- userid — varchar(50) — NOT NULL
- regdate — datetime — NOT NULL
- exp — datetime — NOT NULL
- useregdate — datetime
- statuscd — int(11)
- coupontypecd — int(11)
- adminid — varchar(50)
admincouponstatus
- statuscd — int(11) — Primary key — NOT NULL
- statuscdname — varchar(50)
admincoupontype
- coupontypecd — int(11) — Primary key — NOT NULL
- coupontypename — varchar(50)
adminhistory
- seqno — int(11) — Primary key — NOT NULL
- deviceid — varchar(50) — NOT NULL
- regdate — datetime
- contents — varchar(500)
adminmain
- deviceid — varchar(50) — Primary key — NOT NULL
- salesday — datetime
- sellers — varchar(50)
- companyname — varchar(500)
- user — varchar(50)
- phone — varchar(30)
- regdate — datetime
- plan — varchar(50)
adminpush
- seqno — int(11) — Primary key — NOT NULL
- userid — varchar(50)
- device_conut — text
- device — text
- adminname — varchar(50)
- regdate — datetime
- sendcheck — varchar(50)
- failure — text
- title — varchar(300)
- body — varchar(1000)
- appid — text
- failurecount — int(11)
admintsnet
- deviceid — varchar(50) — Primary key — NOT NULL
- salesday — datetime
- sellers — varchar(50)
- companyname — varchar(500)
- user — varchar(50)
- phone — varchar(30)
- installationdate — varchar(50)
- installer — varchar(50)
- devicetype — varchar(30)
- regdate — datetime
- salesfee — varchar(50)
- plan — varchar(50)
adminuser
- userid — varchar(100) — Primary key — NOT NULL
- username — varchar(100) — NOT NULL
- passwd — varchar(100)
- grade — tinyint(3) — NOT NULL
- puserid — varchar(100)
- startdate — datetime — NOT NULL
- enddate — datetime — NOT NULL
- mobile — varchar(30)
- pushyn — tinyint(4) — NOT NULL
- localecd — char(5) — NOT NULL
- portalid — varchar(100)
- registrationtype — varchar(100)
- oragnization — varchar(255)
adminusercouponstatus
- statuscd — int(11) — Primary key — NOT NULL
- statusname — varchar(500)
channel
- channelid — int(11) — Primary key — NOT NULL
channelname
- channelnamecd — char(2) — Primary key — NOT NULL
- channelname — varchar(255) — NOT NULL
- channelmeasure — varchar(255)
- channelrangetype — enum('R', 'B')
- channelrangedata — varchar(255)
- channelrangedatadefult — varchar(255)
defrostalarmtime
- deviceid — varchar(100) — Primary key — NOT NULL
- devicetypecd — int(11) — Primary key — NOT NULL
- channelid — int(11) — Primary key — NOT NULL
- alarmdata — int(11) — NOT NULL
- alarmtime — datetime
device
- deviceid — varchar(100) — Primary key — NOT NULL
- devicename — varchar(100)
- wifissid — varchar(100)
- wifipasswd — varchar(100)
- deviceinfo — text
- userid — varchar(100) — NOT NULL
- createdate — datetime
- updatedate — datetime
- devicetypecd — int(11) — NOT NULL
- groupid — int(11) — NOT NULL
- devicedesc — text
- deleteflag — enum('Y', 'N') — NOT NULL
- saveinterval — int(11)
- pushenable — enum('Y', 'N')
- pushinterval — int(11)
- pushrepeat — int(11)
- pushsysenable — enum('Y', 'N')
devicealarm
- seqno — int(11) — Primary key — NOT NULL
- deviceid — varchar(100) — NOT NULL
- regdate — datetime — NOT NULL
- data — text
- json — text
- userid — varchar(100)
devicecategory
- categorycd — char(2) — Primary key — NOT NULL
- categoryname — varchar(255) — NOT NULL
devicechannel
- devicetypecd — int(11) — Primary key — NOT NULL
- channelid — int(11) — Primary key — NOT NULL
- channelnamecd — char(2) — NOT NULL
- commandcd — char(2) — NOT NULL
devicechannelrange
- deviceid — varchar(100) — Primary key — NOT NULL
- devicetypecd — int(11) — Primary key — NOT NULL
- channelid — int(11) — Primary key — NOT NULL
- channelrangedata — varchar(255) — NOT NULL
- defrost — enum('Y', 'N')
- defrostinterval — int(11)
- ai — enum('Y', 'N')
devicecommand
- commandcd — char(2) — Primary key — NOT NULL
- command — text — NOT NULL
devicecontorl
- seqno — int(11) — Primary key — NOT NULL
- deviceid — varchar(100) — NOT NULL
- regdate — datetime — NOT NULL
- data — mediumtext
- json — mediumtext
- userid — varchar(100)
devicedata
- seqno — bigint — Primary key — NOT NULL
- deviceid — varchar(100) — NOT NULL
- regdate — datetime — NOT NULL
- data — double(22,1) — NOT NULL
- channelid — int(11) — NOT NULL
devicedatanew
- seqno — bigint — Primary key — NOT NULL
- deviceid — varchar(100) — NOT NULL
- regdate — datetime — NOT NULL
- data — double(22,1) — NOT NULL
- channelid — int(11) — NOT NULL
devicegroup
- groupid — int(11) — Primary key — NOT NULL
- groupname — varchar(255) — NOT NULL
- userid — varchar(100) — NOT NULL
- defaultyn — enum('Y', 'N') — NOT NULL
deviceicon
- deviceiconid — int(11) — Primary key — NOT NULL
- deviceiconcomment — varchar(255) — archar(255) nul
- deviceiconpath — varchar(255) — NOT NULL
devicemanual
- seqno — int(11) — Primary key — NOT NULL
- devicetypecd — int(11) — NOT NULL
- imagepath — varchar(255) — NOT NULL
devicetype
- devicetypecd — int(11) — Primary key — NOT NULL
- devicetypename — varchar(255) — NOT NULL
- devicetypenameble — varchar(255) — NOT NULL
- devicetypefirmware — varchar(255)
- devicetypeversioncode — int(11) — NOT NULL
- deviceiconid — int(11) — NOT NULL
- categorycd — char(2) — NOT NULL
historyplan
- seqno — int(11) — Primary key — NOT NULL
- deviceid — varchar(100) — NOT NULL
- regdate — datetime — NOT NULL
- plantype — int(11)
- planexp — datetime
- adminid — varchar(100)
- note — varchar(100)
locale
- localecd — char(5) — Primary key — NOT NULL
- localename — varchar(255) — NOT NULL
notice
- seqno — int(11) — Primary key — NOT NULL
- classification — varchar(10)
- noticetitle — varchar(100)
- noticecontent — longtext
- regdate — varchar(50)
- localecd — varchar(50)
- flag — char(1)
noticealertnow
- deviceid — varchar(100) — Primary key — NOT NULL
- devicename — varchar(100) — NOT NULL
- organization — varchar(100) — NOT NULL
- userid — varchar(100) — NOT NULL
- username — varchar(100) — NOT NULL
- mobile — varchar(30) — NOT NULL
- createdate — datetime — NOT NULL
- pushenable — enum('Y', 'N')
- dktapikey — varchar(50) — NOT NULL
plan
- deviceid — varchar(100) — Primary key — NOT NULL
- regdate — datetime — NOT NULL
- plantype — int(11)
- planexp — datetime
user
- userid — varchar(100) — Primary key — NOT NULL
- username — varchar(100) — NOT NULL
- passwd — varchar(100)
- grade — tinyint(3) — NOT NULL
- puserid — varchar(100)
- startdate — datetime — NOT NULL
- enddate — datetime — NOT NULL
- mobile — varchar(30)
- pushyn — tinyint(4) — NOT NULL
- localecd — char(5) — NOT NULL
- pushsysyn — tinyint(4) — NOT NULL
- portalid — varchar(100)
- registrationtype — varchar(100)
- organization — varchar(255)
- multiExecDown — tinyint(4) — NOT NULL
- isvalidation — tinyint(4) — NOT NULL
- validationgroupid — int(11) — NOT NULL
- ispasswdexpiration — tinyint(4) — NOT NULL
- passwdperiods — tinyint(4) — NOT NULL
- lastpasswdchangedate — datetime — NOT NULL
- islocked — tinyint(4) — NOT NULL
- invalidpasswdcount — tinyint(4) — NOT NULL
- maxpasswdcount — tinyint(4) — NOT NULL
userDelete
- seqno — int(11) — Primary key — NOT NULL
- userid — varchar(50) — NOT NULL
- regdate — datetime — NOT NULL
useraccesslog
- seqno — int(11) — Primary key — NOT NULL
- userid — varchar(100) — NOT NULL
- logtype — int(11) — NOT NULL
- regdate — datetime — NOT NULL
- puserid — varchar(100)
- logtext — varchar(2000) — NOT NULL
userapp
- appid — varchar(50) — Primary key — NOT NULL
- userid — varchar(100) — NOT NULL
- token — varchar(255) — NOT NULL
- appversion — varchar(255)
- osversion — varchar(255)
- modelname — varchar(255)
- apptype — enum('I', 'A') — NOT NULL
- regdate — datetime — NOT NULL
userdevice
- userid — varchar(100) — Primary key — NOT NULL
- deviceid — varchar(100) — Primary key — NOT NULL
validationgroupinfo
- groupid — int(11) — Primary key — NOT NULL
- groupname — varchar(100) — Primary key — NOT NULL
- adminid — varchar(100) — NOT NULL
- passwdperiods — tinyint(4) — NOT NULL
- maxpasswdcount — tinyint(4) — NOT NULL
- regdate — datetime — NOT NULL