Component database layout

Company

Page, pages name is short form without AS or LLC ending.

Properties

• name, long form with AS/LLC
• e-mail
• web page
• contact address

Template

• Company

Category

• Companies

Product

Page

Properties

• name
  • there is no need to create a property for the name, since the title of each page representing a product will be the name of that product.
• Manufacturer
• user manual
• datasheet
• Short description

CoM modules

• RAM
• FLASH
• CPU

Template

• Product

Category

• Products

Device

Ex. Telem-GW6, RTA-A, Vamp-255...

Properties

• name
  • there is no need to create a property for the name, since the title of each page representing a device will be the name of that device.
• Product
• owner
• barcode

Template

• Device

Data included from other pages

• service history
• Warranty
  • start
  • end
• Quality Control test results
• configuration
• SW version
• Components
• Installation location (name of substation)

Category

• Devices

Component

ex. Telem-RTC, Telem-COM8, Telem-GW6Lin-rev1, Telem-GW6Lin-rev2, Telem-GW6Lin-rev3

Properties

• name
  • there is no need to create a property for the name, since the title of each page representing a product will be the name of that product.
• product
• barcode

Template

• Component

Category

• Components

Batch

Properties

• name
  • there is no need to create a property for the name, since the title of each page representing a product will be the name of that product.
• component
• Manufacturer

Service

Properties

• name(page)
• parent ( was worked on )
• warrany
• task
  • software update
  • hardware repair
• Free text

Template

• Service

Category

• Service

Contact

Properties

• name(page)
• company
• e-mail
• phone number
• Position(job)

Template

• Contact

Category

• Contacts