<?php
global $runnerDbTableInfo;
$runnerDbTableInfo['qa_maintenance_checklist_result'] = array(
	'type' => 0,
	'foreignKeys' => array( 
		array(
			'name' => 'fk_qa_maintenance_result_checklist',
			'refTable' => 'qa_maintenance_checklist_setup',
			'refSchema' => '',
			'del_rule' => 1,
			'upd_rule' => 1,
			'columns' => array( 
				array(
					'column' => 'checklist_id',
					'ref_column' => 'id' 
				) 
			) 
		),
		array(
			'name' => 'fk_qa_maintenance_result_header',
			'refTable' => 'qa_maintenance_inspection',
			'refSchema' => '',
			'del_rule' => 1,
			'upd_rule' => 1,
			'columns' => array( 
				array(
					'column' => 'qa_maintenance_inspection_id',
					'ref_column' => 'id' 
				) 
			) 
		) 
	),
	'fields' => array( 
		array(
			'name' => 'id',
			'type' => 20,
			'size' => 20,
			'scale' => 0,
			'typeName' => 'bigint(20)',
			'nullable' => false,
			'autoinc' => true,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'qa_maintenance_inspection_id',
			'type' => 20,
			'size' => 20,
			'scale' => 0,
			'typeName' => 'bigint(20)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'checklist_id',
			'type' => 20,
			'size' => 20,
			'scale' => 0,
			'typeName' => 'bigint(20)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'answer',
			'type' => 129,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'enum(\'YES\',\'NO\',\'N/A\')',
			'enumValues' => array( 
				'YES',
				'NO',
				'N/A' 
			),
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'response_value',
			'type' => 200,
			'size' => 500,
			'scale' => 0,
			'typeName' => 'varchar(500)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'remarks',
			'type' => 200,
			'size' => 500,
			'scale' => 0,
			'typeName' => 'varchar(500)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		) 
	),
	'primaryKeys' => array( 
		'id' 
	),
	'uniqueFields' => array( 
		 
	),
	'name' => 'qa_maintenance_checklist_result' 
);
?>