ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

MaintenanceActions

Information about maintenance Actions performed on Equipment

Columns
PK	Name	Data Type	NULLs	A/N	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(50)				Text code assigned to the service performed
	MaintenanceReason	VarChar(500)				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	ODM2Core.Actions	ODM2Equipment.MaintenanceActions	ActionID	ActionID

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Equipment