<?php
try {
    $db = new PDO('sqlite:d:/Docker/jasan/dda/assets.db');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "--- LAPTOP_ASSETS SCHEMA ---\n";
    $res = $db->query('PRAGMA table_info(laptop_assets)')->fetchAll();
    foreach ($res as $col) {
        echo "{$col['name']} ({$col['type']})\n";
    }

    echo "\n--- LAPTOP_MODELS SCHEMA ---\n";
    $res = $db->query('PRAGMA table_info(laptop_models)')->fetchAll();
    foreach ($res as $col) {
        echo "{$col['name']} ({$col['type']})\n";
    }
} catch (Exception $e) {
    echo $e->getMessage();
}