final db scaffold, with salvaged validation from previous attempt