CMDB Relationships

A Configuration Management Schema Items Oriented around Change management

Derived from CMDB Relationship Diagram (pdf)

Table: HardwareCI

HardwareID
RFCID
ComponentTypeID
VendorID
DocumentID
HardwareLocationID
DateInstalled
Version
ModelNumber
SerialNumber

Table: Location

LocationID
LocationName
LocationIPSubnet

Table: VendorInfo

VendorID VendorName ContactLastName ContactFirstName PhoneNumber FaxNumber MobileNumber EmailAddress

Table: DriverInformation

DriverID HardwareID RFCID VendorID Version DriverName DateInstalled

Table: SoftwareCI

SoftwareID RFCID VendorID DocumentID ApplicationName DateInstalled PhysicalSoftwareLocation Version ServicePack

Table: Licence

LicenceDetailsID SoftwareID LicenceDesc

Table: ServiceInfomation

ServiceID HardwareID SoftwareID EmployeePositionID ServiceName ServiceFunction

Table: EmployeePosition

EmployeePositionID PositionDescription Qualifications

Table: EmployeeInformation

EmployeeID EmployeePositionID FirstName LastName Email

Table: DocumentCI

DocumentID RFCID DocumentName DocumentLocation

Table: RequestForChange

RFCID EmployeeID ChangePriorityID ChangeCategorisationID DateImplemented ChangeOwner ChangeInitiator ReasonforChange ChangeDetails CABRecomendations DateAuthorised DateImplementationReviewed

Table: ChangePriority

ChangePriorityID PriorityDescription AuthorisationRequired

Table: ChangeCategorisation

ChangeCategorisationID ChangeCategorisationDesc AuthorisationRequired