MaintenanceActions - Table

ODMX [ODMX_DBWrench_Schema.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: MaintenanceActions

Information about maintenance Actions performed on Equipment

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	ActionID	Integer				Primary key and foreign key idenfier of the Equipment MaintenanceAction
	IsFactoryService	Boolean				Boolean indicator of whether the Action is a factory service
	MaintenanceCode	VarChar()				Text code assigned to the service performed
	MaintenanceReason	VarChar()				Text description of why the service Action was required

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MaintenanceActions_Actions	ODMXCore.Actions	ODMXEquipment.MaintenanceActions	ActionID	ActionID

Triggers

(none)

Used in Diagrams