What is the name of the hardware used to build this dinner console table? If you are aware of a similar design I would really appreciate some links. I am looking for a dinner table that has to be "almost invisible" when not in use.
They're called table slides or extension slides. They generally come in 2 versions - one for pedestal type tables (sometimes called equalizer slides) and one for traditionally legged tables.
As far as the design goes, you're pretty much limited to your imagination and woodworking ability. Just build it like you would any other extending table, but with the fixed table top only long enough to accommodate the hardware.
This is the only one I've found, after being inspired by the same table. But I did buy them, and I can stretch a small table for 2 to a table for 8-10.