AssetType_CODE Table

AssetType_CODE is an enumerated code table for Asset type.

Table 1. Database columns for AssetType_CODE table

Database Column

Details
AssetTypeID

Type: integer. Key

A unique identifier for Asset type. Possible values and the corresponding default strings are:

  • 1 = Workstation
  • 2 = Server
  • 3 = Monitor
  • 4 = Desk
  • 5 = Chair
  • 6 = Printer
  • 7 = Router
  • 8 = Switch
  • 9 = Telephone
  • 10 = Cell phone
  • 11 = Laptop.
  • 12 = Mobile Device.
AssetType_en

Type: text (max 1000 characters)

Type of the Asset in English.
AssetType_de

Type: text (max 1000 characters)

Type of the Asset in German.
AssetType_fr

Type: text (max 1000 characters)

Type of the Asset in French.
AssetType_ja

Type: text (max 1000 characters)

Type of the Asset in Japanese.
AssetType_es

Type: text (max 1000 characters). Nullable

Type of the Asset in Spanish.