$lane,'HTTP'=>0,'DML'=>0,'DDL'=>0];foreach(['nutrition','nutrition_template','nutrition_template_ext'] as $table){$name=$lane==='B'?$p.$table:strtoupper($p.$table);$rows=$lane==='B'?$q('SELECT COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_DEFAULT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY ORDINAL_POSITION',[$name]):$q('SELECT COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE,DATA_DEFAULT FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID',[$name]);$report['tables'][$table]=array_values(array_filter($rows,static function($r){return strtolower($r['column_name'])==='use_volume'||preg_match('/float|double|decimal|real|number/i',$r['column_type']??$r['data_type'])===1;}));}$report['oracle_native_SELECT']=$GLOBALS['ORACLE_JOURNAL'];$save('private-float-metadata-v2.json',$report);echo json_encode($report),"\n";