Component database layout

From Phobos Wiki
Revision as of 13:34, 30 March 2012 by Roland (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
  • 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 )
  • 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