SQL Schema for Asset/Device Data
Other Schemas: Ticket Data
Device: Device/Asset data and system fields
Xtype: Device/Asset Types
Generic: Device/Asset Groups
DeviceInfo/Info: Asset/Device Field data (such as Serial Number or Model)
(DeviceInfo data is actually stored in Info table and DeviceInfo table is a view)
TypeInfo: Link between Device/Asset Types and Device/Asset Fields
Field: List of Device/Asset Fields (where yseq = T)