Component database layout

Company

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

Properties

• name, long form with AS/LLC
• Contact
  • e-mail
  • web-page
  • phone number

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( Company)
• user manual
• datasheet
• Short description

Template

• Product

Category

• Products
  • CoM modules

Device

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

Device represents a specific instance of a device

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.
  • name should include a barcode
• Product
• owner ( Company or RTU kapp)
• location
  • GPS coordinates
• barcode

Template

• Device

Data included from other pages

• service history
• Warranty
  • start
  • end
• Quality Control test results
• configuration
• SW version
• Components
  • Component
• 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.
  • name should include a barcode
• barcode
• Batch

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.
• Product
• Manufacturer ( Company)
• Revision
• List of components( Products)

Service

Properties

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

Template

• Service

Category

• Service

Contact

There should be contacts for companies and the people who work there.

Properties

• name(page)
  • Companys contact info page name ex: Martem contact
  • Person ex: Roland Uuesoo
• company
• e-mail
• phone number
• WWW page
  • mostly if company
• Position(job)

Template

• Contact

Category

• Contacts