test

Tables (12)

CPU_Share

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • Date — varchar(20)
  • Time — varchar(20)
  • Check — int(1)
  • Values — varchar(20)

Device

  • Device_IP — varchar(30) — Primary key — NOT NULL
  • User_id — varchar(20) — Foreign key → User.User_id — NOT NULL
  • Device_Kind — varchar(15)
  • Device_Protocol — varchar(10) — NOT NULL
  • Device_Manegement — int(1) — NOT NULL — 1이면 관리
  • Device_Date — varchar(10)
  • Device_Availability — int(1) — NOT NULL
  • Device-Name — varchar(20)
  • CPU_CriticalValues — varchar(20)
  • Memory_CriticalValues — varchar(20) — NOT NULL

EventOf_Critical

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • date — varchar(20) — NOT NULL
  • Time — varchar(20)
  • Content — varchar(50)
  • Check — int(1)

InterfaceOfDevice

  • InterfaceNO — varchar(3)
  • Device_IP — varchar(30) — Foreign key → Device.Device_IP
  • Interface_Kind — varchar(30)
  • Interface_Availability — varchar(5) — NOT NULL

LogMessage

  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • Date — char(9) — NOT NULL
  • time — char(8) — NOT NULL
  • Risk — varchar(10) — NOT NULL
  • Event_Content — varchar(50) — NOT NULL
  • Check — int(1) — NOT NULL — 1이면 확인

Memory_Share

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • Date — varchar(20)
  • Time — varchar(20)
  • Check — int(1)
  • Values — varchar(20)

OptionOf_Device

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • PeriodOf_CPUSpeed — varchar(10)
  • PeriodOf_MemorySpeed — varchar(10)
  • PeriodOf_MemoryShare — varchar(10)
  • PeriodOf_CpuShare — varchar(10)
  • PeriodOf_Temperature — varchar(10)

RateOfMemorySpeed

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • Date — char(9) — NOT NULL
  • time — char(8) — NOT NULL
  • Memory_Speed — varchar(10) — NOT NULL
  • Check — int(1) — NOT NULL — 1이면 확인

RateOf_Temperature

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • Date — varchar(20)
  • Time — varchar(20)
  • Check — int(1)
  • Values — varchar(20)

Rate_OfCpuSpeed

  • Device_IP — varchar(30) — Foreign key → Device.Device_IP — NOT NULL
  • User_id — varchar(20) — Foreign key → Device.User_id — NOT NULL
  • Date — char(9) — NOT NULL
  • time — char(8) — NOT NULL
  • Cpu_Speed — varchar(10) — NOT NULL
  • Check — int(1) — NOT NULL — 1이면 확인

Rate_OfInterface

  • InterfaceNO — varchar(3) — Foreign key → InterfaceOfDevice.InterfaceNO — NOT NULL
  • Device_IP — varchar(30) — Foreign key → InterfaceOfDevice.Device_IP — NOT NULL
  • Date — char(9) — NOT NULL
  • time — char(8)
  • bpsRate — varchar(20)
  • ppsRate — varchar(20)

User

  • User_id — varchar(20) — Primary key — NOT NULL
  • User_Name — varchar(20) — NOT NULL
  • User_Password — varchar(20) — NOT NULL
  • User_Sex — varchar(5) — NOT NULL
  • User_Email — varchar(30) — NOT NULL
  • User_PhoneNumber — varchar(25) — NOT NULL
  • User_NetworkName — varchar(30) — NOT NULL
  • date — of — NOT NULL