<?php
global $runnerDbTableInfo;
$runnerDbTableInfo['vw_dashboard_storage_capacity'] = array(
	'type' => 0,
	'foreignKeys' => array( 
		 
	),
	'fields' => array( 
		array(
			'name' => 'id',
			'type' => 3,
			'size' => 11,
			'scale' => 0,
			'typeName' => 'int(11)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '0',
			'defaultValue' => '0' 
		),
		array(
			'name' => 'stock_type',
			'type' => 129,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'enum(\'FFP\',\'NFI\')',
			'enumValues' => array( 
				'FFP',
				'NFI' 
			),
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'capacity_qty',
			'type' => 14,
			'size' => 18,
			'scale' => 2,
			'typeName' => 'decimal(18,2)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '0.00',
			'defaultValue' => '0.00' 
		),
		array(
			'name' => 'current_stock_qty',
			'type' => 14,
			'size' => 18,
			'scale' => 2,
			'typeName' => 'decimal(18,2)',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => '0.00',
			'defaultValue' => '0.00' 
		),
		array(
			'name' => 'utilization_percent',
			'type' => 14,
			'size' => 22,
			'scale' => 0,
			'typeName' => 'decimal(22,0)',
			'nullable' => true,
			'autoinc' => false,
			'defaultValueSQL' => null,
			'defaultValue' => '' 
		),
		array(
			'name' => 'data_as_of',
			'type' => 135,
			'size' => 0,
			'scale' => 0,
			'typeName' => 'datetime',
			'nullable' => false,
			'autoinc' => false,
			'defaultValueSQL' => 'current_timestamp()',
			'defaultValue' => 'CURRENT_TIMESTAMP' 
		) 
	),
	'primaryKeys' => array( 
		 
	),
	'uniqueFields' => array( 
		 
	),
	'name' => 'vw_dashboard_storage_capacity' 
);
?>