<?php
global $runnerDbTableInfo;
$runnerDbTableInfo['bank_reconciliation_match'] = array(
	'type' => 0,
	'foreignKeys' => array( 
		 
	),
	'fields' => array( 
		array(
			'name' => 'id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => false,
			'autoinc' => true,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'bank_reconciliation_match_uuid',
			'type' => 200,
			'size' => 36,
			'scale' => 0,
			'typeName' => 'char(36)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'bank_reconciliation_id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'bank_statement_line_id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'matched_transaction_type',
			'type' => 200,
			'size' => 80,
			'scale' => 0,
			'typeName' => 'varchar(80)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'matched_transaction_id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'matched_transaction_uuid',
			'type' => 200,
			'size' => 36,
			'scale' => 0,
			'typeName' => 'char(36)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'matched_amount',
			'type' => 14,
			'size' => 19,
			'scale' => 4,
			'typeName' => 'decimal(19,4)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'match_method',
			'type' => 200,
			'size' => 30,
			'scale' => 0,
			'typeName' => 'varchar(30)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '\'MANUAL\'',
			'defaultValue' => 'MANUAL' 
		),
		array(
			'name' => 'confidence_score',
			'type' => 14,
			'size' => 9,
			'scale' => 6,
			'typeName' => 'decimal(9,6)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'matched_by_platform_user_id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'matched_at',
			'type' => 135,
			'size' => 6,
			'scale' => 0,
			'typeName' => 'datetime(6)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => 'CURRENT_TIMESTAMP(6)',
			'defaultValue' => '' 
		) 
	),
	'primaryKeys' => array( 
		'id' 
	),
	'uniqueFields' => array( 
		 
	),
	'name' => 'bank_reconciliation_match' 
);
?>