wiki:quarry/schema

Version 6 (modified by mylan, 14 years ago) (diff)

XEN is no longer supported by RedHat? - proposition to rename XEN to VM as more genreric name

Hardware

    Customers
    Datacenters
    Downtime
    has Additional IP
    Hetzner Server
    IP Address
    Offline
    Provider
    ServerBeach Accounts
    ServerBeach Server

Shared Zope Hosting

    Basecamp
    Customers
    Datacenters
    Instances
    Mappings

Virtualized Hosting

    Datacenters
    Migrations

Linux Servers

    Linux Servers
    Reboots
    Xen Guests (DomU)
    XEN Host (Dom0)
    Hardware Servers
    Shared Hosting Servers

Billing

    2CO Cart Item
    2CO Invoice Items
    2CO Invoices
    2CO Invoices (test)
    2CO Product
    2CO Product Item
    2CO Recurring Item
    2CO Sales
    Customers
    Periodicity
    Products
    Recurring Products

HR

    Exuinters
    has Passport
    Not Wanted
    Person
    Quinters
    Sysadmin
    Футболки

Legal

    Companies
    Компанії
    Угоди

Tickets

    Customers
    Support
    Ticket

Basecamp

    Basecamp

Inventory

    Computers
    Deliveries
    Delivery Item
    hasMAC
    History
    Instances
    Manufacturers
    Models

Hosting/host environment

    Data.fs
    has FileStorage
    Instances

CRM

    2CO Sales
    Customers
    Gmail Search
    Instances
    Mappings

m.Inventory

    m.Computers
    m.Deliveries
    m.Delivery Item
    m.Instances
    m.Manufacturers
    m.Motherboard Types
    m.Motherboards
    m.Operations
    m.Part Types
    m.RAM Types
    m.Stock

Skins

    2CO Cart Item
    2CO Invoice Items
    2CO Invoices
    2CO Product
    2CO Product Item
    2CO Sales
    Customers
    Dummy
    Products

Propositions/Problem/Resolve?

  • Downtime.csv

has column when which is date/time period. Dexterity has no field type for hold DateTime? period. This field divided into when_start and when_end DateTime? fields

  • XENHostDom0.csv - recomended rename to VMHostDom0
  • XENGuestDomU.csv - recomended rename to VMGuestDomU