<?php
global $runnerDbTableInfo;
$runnerDbTableInfo['augmentation_portal_request_detail'] = array(
	'type' => 0,
	'foreignKeys' => array( 
		array(
			'name' => 'fk_aug_portal_req_detail_category',
			'refTable' => 'augmentation_request_category',
			'refSchema' => '',
			'del_rule' => 4,
			'upd_rule' => 1,
			'columns' => array( 
				array(
					'column' => 'category_id',
					'ref_column' => 'category_id' 
				) 
			) 
		),
		array(
			'name' => 'fk_aug_portal_req_detail_header',
			'refTable' => 'augmentation_portal_request',
			'refSchema' => '',
			'del_rule' => 1,
			'upd_rule' => 1,
			'columns' => array( 
				array(
					'column' => 'portal_request_id',
					'ref_column' => 'portal_request_id' 
				) 
			) 
		),
		array(
			'name' => 'fk_aug_portal_req_detail_item',
			'refTable' => 'item',
			'refSchema' => '',
			'del_rule' => 2,
			'upd_rule' => 1,
			'columns' => array( 
				array(
					'column' => 'mapped_item_id',
					'ref_column' => 'id' 
				) 
			) 
		) 
	),
	'fields' => array( 
		array(
			'name' => 'portal_request_detail_id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => false,
			'autoinc' => true,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'portal_request_id',
			'type' => 20,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'bigint',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'line_no',
			'type' => 3,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'int',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '1',
			'defaultValue' => '1' 
		),
		array(
			'name' => 'category_id',
			'type' => 3,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'int',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'requested_item_description',
			'type' => 200,
			'size' => 255,
			'scale' => 0,
			'typeName' => 'varchar(255)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'quantity',
			'type' => 14,
			'size' => 14,
			'scale' => 2,
			'typeName' => 'decimal(14,2)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '0.00',
			'defaultValue' => '0.00' 
		),
		array(
			'name' => 'unit',
			'type' => 200,
			'size' => 50,
			'scale' => 0,
			'typeName' => 'varchar(50)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'remarks',
			'type' => 200,
			'size' => 255,
			'scale' => 0,
			'typeName' => 'varchar(255)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'mapped_item_id',
			'type' => 3,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'int',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'mapped_item_description',
			'type' => 200,
			'size' => 255,
			'scale' => 0,
			'typeName' => 'varchar(255)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'approved_qty',
			'type' => 14,
			'size' => 14,
			'scale' => 2,
			'typeName' => 'decimal(14,2)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '0.00',
			'defaultValue' => '0.00' 
		),
		array(
			'name' => 'created_at',
			'type' => 135,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'datetime',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => 'CURRENT_TIMESTAMP',
			'defaultValue' => 'CURRENT_TIMESTAMP' 
		) 
	),
	'primaryKeys' => array( 
		'portal_request_detail_id' 
	),
	'uniqueFields' => array( 
		 
	),
	'name' => 'augmentation_portal_request_detail' 
);
?>