MDB:Development/Devices

device

• id -- auto_inc, primary key
• unit -- basic unit information (ECE, CNR, etc); used to determine which devices each unit can see.
• name -- name of the computer, can remain null for non-IT
• dnsdomain -- dns domain for the device (ece.ncsu.edu, cnr.ncsu.edu)
• type -- basic type grouping (workstation, laptop, printer, nonNCSU, Instrument, Other, etc)
• uuid -- Universally Unique Identifier, if can be pulled. One of a few fields that can confirm a new report is a current machine.
• oid
• make
• model
• serialnumber
• bios
• bios_date
• ip_address
• mac_address
• os
• os_version
• service_pack_major
• service_pack_minor
• kernel
• installation_date
• last_boot_date
• memory -- should be generated from total/1GB in device_memory sub table.
• processor_count
• processor_type
• processor_speed
• vpro
• location_building
• location_room
• asset_tag
• cams_tag
• purchase_date
• purchase_price
• purchase_account
• flag_count_warning
• flag_count_error
• tags -- string of all tags associated with the device; define a character to separate them -- each tag must have this character on each side of it to allow easy search.
• record_create_date
• record_update_date
• record_remove_date

device_memory

• id
• device_id
• name -- reported name
• type -- DDR, SDRAM, DDR2, etc
• speed -- in Mhz
• current_size -- (/1GB)
• max_size -- (/1GB)

device_comments

• id - auto_incr
• userid - userid of commenter
• device_id - id of device
• comment
• create_date

device_warranty

• id
• device_id
• desc
• start_date
• end_date
• provider

device_warranty_schedule

• id
• device_id
• last_check_date
• next_check_date
• ship_date