SSH/SFTP Sync with local directory

This idea is simple: a connection is always open, there is a timer to execute a "sync" event to execute a couple of things. First it needs to get a recursion of a directory, from a host, of files and folder which will be loaded to a table with the date modified of each file and sorted descending by date modified with seconds. Then a recursion is taken from a local directory of files and folders and loaded to another table which also has date modified and is sorted descending by date modified. Now below these two tables is another table which will get any changes in comparison between the two. Both tables remain intact and are only modified until exiting the application. The two tables should appear to match and the changes table will be empty after syncing changes. Each time the timer is executed the app should compare the files from the host & locally with the data in the tables. The tables must be saved for later comparisons for deletion events. The dates must include seconds. It should handle files and folders as well as for deletions, modifications/creations and moving files. I have tested an idea for recursion that can be accomplished via API which has shown to have an exceedingly high rate of performance but it didn't include the date modification information which would be handled at a later stage in comparisons.