> I have multiple tables of data already, say TableA, TableB. These tables have > different representations, one may contain a TEXT column, the other may > contain and INTEGER column, but all of them contain an INTEGER field called > time, which is unique.
I don't understand your specifications well enough to give you a solution, but if you have many tables with (Time IPK, Number INT) and many with (Time IPK, String TEXT) you can avoid creating identical tables (by column definitions) by merging these tables together.