<?php
use eftec\chaosmachineone\ChaosMachineOne;

 include 'common.php';
$chaos->table('ProductSubTypes', 1000)
		->setDb($db)
		->field('idProductSubType', 'int','identity', 0)
		->field('idProductType', 'int','database')
		->field('name', 'string','database','',0,45)
		->field('lastUpdate', 'datetime','database',new DateTime('now'))
		->field('unitName', 'string','database','',0,45)
		->field('ProductTypes_idProductType', 'int','database')
			->isnullable(true)
		->setArrayFromDBTable('array_ProductTypes_idProductType','ProductTypes','idProductType')
		->gen('when always set ProductTypes_idProductType.value=randomarray("array_ProductTypes_idProductType")')
		->gen('when always set idProductType.value=random(1,100,1,10,10)')
		->gen('when always set name.value=random(0,45)')
		->gen('when always set lastUpdate.speed=random(3600,86400)')
		->gen('when always set unitName.value=random(0,45)')
		->setInsert(true)
		->showTable(['idProductSubType','idProductType','name','lastUpdate','unitName','ProductTypes_idProductType'],true)
		->run(true);