In the general model of a compiler, the Terminal Table is a permanent database that maintains information about all terminal symbols used in the language. The Identifier Table tracks variables and names, the Literal Table stores constants, and while source code is input, it's not a permanent database structure maintained by the compiler.