Layout with Tools

1 ZTS (c) DbSchema Hover columns to read the comments. Fk fk_Host_HW Hardware ref ZTStatus ( Host ) Fk fk_Host_HW Hardware ref ZTStatus ( Host ) Host Fk fk_Host_NW Network ref ZTStatus ( Host ) Fk fk_Host_NW Network ref ZTStatus ( Host ) Host Fk fk_Host_PN Printers ref ZTStatus ( Host ) Fk fk_Host_PN Printers ref ZTStatus ( Host ) Host Fk fk_Host_QF QuickFix ref ZTStatus ( Host ) Fk fk_Host_QF QuickFix ref ZTStatus ( Host ) Host Fk fk_Host_SV Services ref ZTStatus ( Host ) Fk fk_Host_SV Services ref ZTStatus ( Host ) Host Fk fk_Host_SW Software ref ZTStatus ( Host ) Fk fk_Host_SW Software ref ZTStatus ( Host ) Host Fk fk_Host_US Users ref ZTStatus ( Host ) Fk fk_Host_US Users ref ZTStatus ( Host ) Host Fk fk_Host_WN Windows ref ZTStatus ( Host ) Fk fk_Host_WN Windows ref ZTStatus ( Host ) Host Fk fk_Host_ZT ZTasks ref ZTStatus ( Host ) Fk fk_Host_ZT ZTasks ref ZTStatus ( Host ) Host HardwareTable ZTS.Hardware fk_Host_HW ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) TypTyp char(64) char(64) NameName char(64) char(64) DataData char(64) char(64) NetworkTable ZTS.Network fk_Host_NW ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) IdxIdx char(64) char(64) NameName char(64) char(64) DataData char(64) char(64) PrintersTable ZTS.Printers fk_Host_PN ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) IdxIdx char(64) char(64) NameName char(64) char(64) PortPort char(64) char(64) QuickFixTable ZTS.QuickFix fk_Host_QF ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) IdxIdx char(64) char(64) DescriptionDescription char(64) char(64) InstalledOnInstalledOn char(64) char(64) ServicesTable ZTS.Services fk_Host_SV ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) ServiceNameServiceName char(64) char(64) DisplayNameDisplayName char(64) char(64) StatusStatus char(64) char(64) SoftwareTable ZTS.Software fk_Host_SW ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) DisplayNameDisplayName char(64) char(64) PublisherPublisher char(64) char(64) DisplayVersionDisplayVersion char(64) char(64) UsersTable ZTS.Users fk_Host_US ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) IdxIdx char(64) char(64) DataData char(64) char(64) WindowsTable ZTS.Windows fk_Host_WN ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) NameName char(64) char(64) DataData char(64) char(64) ZTStatusTable ZTS.ZTStatus Pk pk_ztstatus ( Host ) HostHost * char(32) char(32)Referred by Hardware ( Host ) Referred by Network ( Host ) Referred by Printers ( Host ) Referred by QuickFix ( Host ) Referred by Services ( Host ) Referred by Software ( Host ) Referred by Users ( Host ) Referred by Windows ( Host ) Referred by ZTasks ( Host ) DateTimeDateTime char(32) char(32) ZTasksTable ZTS.ZTasks fk_Host_ZT ( Host ) HostHost char(32) char(32)References ZTStatus ( Host ) TimeTime char(64) char(64) DayDay char(64) char(64) ShwTskShwTsk char(64) char(64) RepTskRepTsk char(64) char(64) TypTyp char(64) char(64) PathPath char(64) char(64)


Table Hardware
IdxField NameData Type
Host char(32)
  Typ char(64)
  Name char(64)
  Data char(64)
Indexes
fk_Host_HW ON Host
Foreign Keys
fk_Host_HW ( Host ) ref ZTStatus (Host)


Table Network
IdxField NameData Type
Host char(32)
  Idx char(64)
  Name char(64)
  Data char(64)
Indexes
fk_Host_NW ON Host
Foreign Keys
fk_Host_NW ( Host ) ref ZTStatus (Host)


Table Printers
IdxField NameData Type
Host char(32)
  Idx char(64)
  Name char(64)
  Port char(64)
Indexes
fk_Host_PN ON Host
Foreign Keys
fk_Host_PN ( Host ) ref ZTStatus (Host)


Table QuickFix
IdxField NameData Type
Host char(32)
  Idx char(64)
  Description char(64)
  InstalledOn char(64)
Indexes
fk_Host_QF ON Host
Foreign Keys
fk_Host_QF ( Host ) ref ZTStatus (Host)


Table Services
IdxField NameData Type
Host char(32)
  ServiceName char(64)
  DisplayName char(64)
  Status char(64)
Indexes
fk_Host_SV ON Host
Foreign Keys
fk_Host_SV ( Host ) ref ZTStatus (Host)


Table Software
IdxField NameData Type
Host char(32)
  DisplayName char(64)
  Publisher char(64)
  DisplayVersion char(64)
Indexes
fk_Host_SW ON Host
Foreign Keys
fk_Host_SW ( Host ) ref ZTStatus (Host)


Table Users
IdxField NameData Type
Host char(32)
  Idx char(64)
  Data char(64)
Indexes
fk_Host_US ON Host
Foreign Keys
fk_Host_US ( Host ) ref ZTStatus (Host)


Table Windows
IdxField NameData Type
Host char(32)
  Name char(64)
  Data char(64)
Indexes
fk_Host_WN ON Host
Foreign Keys
fk_Host_WN ( Host ) ref ZTStatus (Host)


Table ZTStatus
IdxField NameData Type
* Host char(32)
  DateTime char(32)
Indexes
pk_ztstatus ON Host


Table ZTasks
IdxField NameData Type
Host char(32)
  Time char(64)
  Day char(64)
  ShwTsk char(64)
  RepTsk char(64)
  Typ char(64)
  Path char(64)
Indexes
fk_Host_ZT ON Host
Foreign Keys
fk_Host_ZT ( Host ) ref ZTStatus (Host)