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